更新时间:2023-02-13 16:08:53
EF 4,您可以执行对对象上下文TSQL语句:
使用(VAR上下文=新EntityFrameworkExampleEntities())
{
VAR数=
context.ExecuteStoreCommand(@DELETE FROM公司里[CompanyID] = 4);
}
请参阅以下博客的详细信息。
http://blogs.microsoft.co.il/blogs/gilf/archive/2009/11/25/execute-t-sql-statements-in-entity-framework-4.aspx
I read that the new Entity Framework will include a method to delete multiple items (Linq to SQL has DeleteAllOnSubmit()) but I can't find the function/method to do that.
Is this in Beta 2 or do I have to make my own?
UPDATE:
This is what I'm using now:
public void DeleteObjects(IEnumerable<object> objects)
{
foreach (object o in objects)
{
DeleteObject(o);
}
SaveChanges();
}
EF 4 allows you to execute TSQL statements against an object context:
using (var context = new EntityFrameworkExampleEntities())
{
var count =
context.ExecuteStoreCommand(@"DELETE FROM Companies WHERE [CompanyID]=4");
}
See the following blog for details.