3

Is it possible with BLToolKit (http://bltoolkit.net) to create a set of records for list of object (batch insert)?

If yes, how is this possible?

Thanks a lot!

Robert Koritnik
  • 103,639
  • 52
  • 277
  • 404
Budda
  • 18,015
  • 33
  • 124
  • 206

3 Answers3

8
using (var db = new DbManager())
    db.InsertBatch(list);
IT.
  • 859
  • 4
  • 11
2
using (var db = new DbManager())
{
    var ret = (from s in db.tablename
               select new ObjectList
               {
                   Id = (int)s.Id,
                   Name = s.Name
               }).ToList();
    return ret;
}
likeitlikeit
  • 5,563
  • 5
  • 42
  • 56
1
using (var db = new DbManager())
{
    db.SetSpCommand("Person_Insert")
      .ExecuteForEach<Person>(list);
}

Where list is provided by other means of your application functionality.

Robert Koritnik
  • 103,639
  • 52
  • 277
  • 404