How to insert multiple records at once in SQLite

Arvind Chourasiya

Hii
i want to insert multiple record in my SQLite table at a time. See this line of code
var items = await MgoApi.Get("Assignment/GetAssigstudents", param);
in this line i'm getting multiple record in items from API, now how can i insert items all record in local database table.

i'm using xamarin android, SQLite database with SQLiteAsyncConnection in VS2013

how i have tried see

foreach(var _items in items)
{
obj.Amount = _items.Amount;
obj.Purpose_Of_Spending = _items.Purpose_Of_Spending;
obj.Type = _items.Type;
obj.Subject=_items.Subject;
obj.Rank=_items.Rank
var RowAffted= Repository_obj.Insert(obj);
}

is this way is correct or not, if you people have more efficient way can suggest me. Thank You

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Arvind Chourasiya10y ago
Thank you for your response :)
but here i don't the expression or inline queries. just i have 1 var item, from this only i have to iterate all records.
so can't use that scenario. :)
0
Suresh M10y ago
You can insert multiple records at a time like below
INSERTINTOtable
(column1,column2,...)
SELECTexpression1,expression2,...
FROMsource_table
[WHEREconditions];
For more details
http://www.techonthenet.com/sqlite/insert.php
+1