Need to remove multiple entity objects when using Entity Framework 4.0

Question

I am new in Entity Framework. I want to remove multiple entities in one database context. If I used DBContext.Remove(Object) then It delete only the one entity from database. Please consider my code:

            CCSRequest objCCSRequest = DBContext.CCSRequest.Find(ccsRequestId);
            if (objCCSRequest != null)
            {
                DBContext.CCSRequest.Remove(objCCSRequest);
                DBContext.SaveChanges();
            }
            CCProducts objCCProducts = DBContext.CCProducts.Find(ccsRequestId);
            if (objCCProducts != null)
            {                    
                DBContext.CCProducts.Remove(objCCProducts);
                DBContext.SaveChanges();
            }

I want to remove entity in both CCSRequest and CCProducts table. Thank you in advance.

mr100 · Accepted Answer · 2014-06-14 07:07:19Z

0

If you want to have a loop that will remove entities of different types you might use this:

object[] entities = new object[]{
    DBContext.CCSRequest.Find(ccsRequestId),
    DBContext.CCProducts.Find(ccsRequestId)
};
foreach(object entity in entities)
{
    DBContext.Entry(entity).State = EntityState.Deleted;
}

answered Jun 14, 2014 at 7:07

mr100

4,4382 gold badges29 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Samar Over a year ago

Yes, I want to remove entities with different types not a same type. The problem is when I use EntityState.Deleted the i found some error like "The name EntityState" does not exist in the current context". I am using Entity Framework 4.0. Thank you for your assistance.

mr100 Over a year ago

Because you need to use proper namespace for that!!! Shame on you for not resolving such a problem yourself.

Samar Over a year ago

Sorry for wrong question I was searching in System.Data.Entity namespace and replied you quickly. Thank you

mr100 Over a year ago

You're welcome. We are here not for providing whole ready-to-use code but instead to help solve some problems. When you ask question you should as well show some effort :)

Samar Over a year ago

Really Thanks for you nice assistance :)

Community · Accepted Answer · 2017-05-23 12:27:10Z

0

Going by the answer to a similar question, you will need to do this in a loop. Please check the answer to this question:

how to delete multiple rows of data with linq to EF using DbContext

edited May 23, 2017 at 12:27

CommunityBot

11 silver badge

answered Jun 14, 2014 at 7:03

user3624833

Collectives™ on Stack Overflow

Need to remove multiple entity objects when using Entity Framework 4.0

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related