且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

实体框架4多对象删除(removeall过)

更新时间: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.

http://blogs.microsoft.co.il/blogs/gilf/archive/2009/11/25/execute-t-sql-statements-in-entity-framework-4.aspx