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