ExecuteSqlBulk

Bulk Insert/Update/Delete for Sqlserver

NuGet Gallery

• NuGet Gallery: ExecuteSqlBulk

Usage

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

Performance

Bulk	20000 records	200000 records	1000000 records
Insert	217 ms	1176 ms	6529 ms
Update	251 ms	1586 ms	6595 ms
Delete	163 ms	1277 ms	6956 ms
Delete All	9 ms	9 ms	13 ms

License

ExecuteSqlBulk is provided under The MIT License.

Copyright (c) 2018 - Colindcli