.net - 如何在 LINQ 中执行 "INSERT INTO table1 (...) SELECT (...) FROM table2"？

Question

我如何编写一个 LINQ to SQL 等价于:

INSERT INTO Table1 (field1, field2, field3)
SELECT field1, field2, field3
FROM Table2
WHERE (field1= @field1)

谢谢

Answer 1

由于您没有返回任何结果，只需使用低级 DataContext.ExecuteCommand()方法:

using (MyDataContext dc = new MyDataContext())
{
    dc.ExecuteCommand(@"
        INSERT INTO Table1 (field1, field2, field3)
        SELECT field1, field2, field3
        FROM Table2
        WHERE (field1= {0})
        ",
        field1);
}