c# - 哪个.Net ORM支持批量插入/更新/删除之类的sql？

Question

哪个ORM支持批量插入/更新/删除之类的sql:

var user=new UserInfoFields();
var update=user.Update().Set
(
   user.Field1=1,
   user.Field2="xxxx"
).Where(user.Name=="Jim" && user.Enable==true);

update.Excute();

对应的T-sql为:

UPDATE UserInfo 
SET 
    Field1=1,
    Field2="xxxx"
WHERE Name='Jim' and Enable=1

Answer 1

checkout BLToolkit -> BLToolkit Linq Extensions - Update

db.Employee
    .Where(e => e.Title == "Spectre")
    .Update(e => new Northwind.Employee
    {
        Title = "Commander"
    });

或

db.Employee
    .Where(e => e.Title == "Spectre")
    .Set(e => e.Title, "Commander")
    .Update();

=

UPDATE
    [e]
SET
    [Title] = 'Commander'
FROM
    [Employees] [e]
WHERE
    [e].[Title] = 'Spectre'

现在已经使用它 2-3 年了，它很棒 :D

首先阅读这个 -> High Level Vision, Global Architecture Strategy & Concept Model Design