Bulk Insert/Update/Delete for Sqlserver
A quick example:
public class Page
{
[key]
public int PageId { get; set; }
public string PageName { get; set; }
public string PageLink { get; set; }
}
using (var db = new SqlConnection("Data Source=.;Initial Catalog=SqlBulkTestDb;Integrated Security=True"))
{
//insert
db.BulkInsert(list);
//update PageName,PageLink by PageId
row = db.BulkUpdate(list, p => new { p.PageName, p.PageLink }, p => new { p.PageId });
//update PageName,PageLink by PageId
row = db.BulkUpdate(list, p => new { p.PageName, p.PageLink }, p => p.PageId });
//update PageName by PageId
row = db.BulkUpdate(list, p => p.PageName, p => p.PageId });
//delete by PageName and PageLink
row = db.BulkDelete(list, p => new { p.PageName, p.PageLink });
//delete by PageId
row = db.BulkDelete(list, p => p.PageId);
//delete all
db.BulkDelete<Page>();
}For more information, would you see Example?
other query: Other Query Example
ExecuteSqlBulk is provided under The MIT License.
Copyright (c) 2018 - Colindcli