EFBulk 1.0.1

How to use

Sample Code

public class Item
{
    public int ItemId { get; set; }
    public string Title { get; set; }
    [Column("Price DB")] // optional column name
    public Decimal Price { get; set; }
}
public class MyContext : DbContext
{
    public DbSet<Item> Items { get; set; }
    public MyContext() : base("name=DataConnection") { }        
}
class Program
{
    static void Main(string[] args)
    {
        MyContext db = new MyContext();
        SqlParameter[] sqlParameters;
        
        //Update op: Approach 1, this will return the Update SQL statement
        var stmt = db.Items.Where(s => s.Title == "Game")
            .GetUpdateStmt(o => new Item { Price = 999, Title = "Tablet" }
            , out sqlParameters);
        //Update op: Approach 2, this will excute the Update SQL statement
        var count = db.Items.Where(s => s.Title == "Game")
            .Update(o => new Item { Price = 999, Title = "Tablet" }, db);
        
        //Delete op: Approach 1, this will return the Delete SQL statement
        var stmt2 = db.Items.Where(s => s.Title == "Micro").GetDeleteStmt();
        //Delete op: Approach 2, this will excute the Delete SQL statement
        var count2 = db.Items.Where(s => s.Title == "Micro").Delete(db);
    }
}