CODEWITHSUNDEEP
c#linqlinq-to-entities
Luke101
Luke101

Reputation: 65238

How to delete data with linq to entities

This code is giving me this error:

The object cannot be deleted because it was not found in the ObjectStateManager

using (var context = new MvcApplication4.Entity.test2Entities())
            {

                var q = (from t in context.tag
                        where t.tag_id == tag
                        select new
                        {
                            t
                        }).FirstOrDefault();



                if (q != null)
                {
                    context.DeleteObject(q);
                    context.SaveChanges();
                }
            }

Am I missing something here?

Upvotes: 0

Views: 2047

Answers (2)

Nick Larsen
Nick Larsen

Reputation: 18877

Try just selecting t and not making an anonymous object with t as a property.

Upvotes: 0

Panagiotis Kanavos
Panagiotis Kanavos

Reputation: 131189

You are creating an anonymous object with new {t} that just happens to contain a property called t of type Tag, which is not registered in the ObjectContext. You don't have to write select new {t}, just select t will return your Tag object.

Upvotes: 3

Related Questions