locked
How to insert all data using InsertAllAsync RRS feed

  • Question

  • User373377 posted

    Hello.. anyone know how to insert all data using InsertAllAsync.. i want to insert all data before i delete data in sqlite.

    Thursday, April 18, 2019 5:44 AM

Answers

  • User382871 posted

    Try the following code: ... SQLiteAsyncConnection conn = new SQLiteAsyncConnection("Database_name"); await conn.InsertAllAsync("list"); Check the link https://github.com/bellinda/BonApetit-Rss-App/blob/master/BonApetitRSS/Pages/NoTimePage.xaml.cs

    • Marked as answer by Anonymous Thursday, June 3, 2021 12:00 AM
    Thursday, April 18, 2019 8:07 AM

All replies

  • User382871 posted

    Try the following code: ... SQLiteAsyncConnection conn = new SQLiteAsyncConnection("Database_name"); await conn.InsertAllAsync("list"); Check the link https://github.com/bellinda/BonApetit-Rss-App/blob/master/BonApetitRSS/Pages/NoTimePage.xaml.cs

    • Marked as answer by Anonymous Thursday, June 3, 2021 12:00 AM
    Thursday, April 18, 2019 8:07 AM
  • User373377 posted

    @yelinzh sorry late reply.. ok.. now its work.. thanks

    Friday, April 19, 2019 4:06 AM
  • User204688 posted

    @Jarvan is their any way to handle t InsertAllAsync throwing exception "Constraint" for duplicate items pfresent already in db so that update the item and continue with insertion?

    Thursday, April 23, 2020 10:57 AM
  • User373377 posted

    @Jarvan i think before you wan't to insertallasync, i prefer you to check first either item is already in database or not,. just checking by ID, or any condition you want.

    Tuesday, May 26, 2020 3:45 PM