Home  /  Questions  /  Question

50   50
Sep 08, 2016

Insert list in one transaction

As have study the current pattern I can only insert 1 record at a time(one object) When I need to insert a List<object>. I would like to do this in one transaction. For example I have 100 records doing it one by one in a loop takes a long time. There must be a better way to do this.



0   0
Sep 21, 2016
Generate Query with string builder  and  

var sql=@"";

use db,execute(sql);