CODEWITHSUNDEEP
c#.netentity-frameworklinq-to-entities
pdiddy
pdiddy

Reputation: 6297

Linq to entities insert EF 1

I have a 2 Entity : Person (Id, CategoryId) and Category(Id).

Now when I try to insert a new Person with only the Id and CategoryId it throws an exception about the Person having a relationship with Category.

The following code doesn't work:

Person newPerson = new Person();
newPerson.Id = 1;
newPerson.CategoryId = 1;
context.AddToPersonSet(newPerson);
context.SaveChanges

This code works 

Person newPerson = new Person();
newPerson.Id = 1;
newPerson.Category = context.CategorySet.Where(cat=> cat.Id == 1).First(); 
newPerson.CategoryId = 1;
context.AddToPersonSet(newPerson);
context.SaveChanges

Is there another way to insert without having to fetch the Category entity ?

Upvotes: 2

Views: 4410

Answers (2)

Glennular
Glennular

Reputation: 18225

similar: best practise/way for master detail / multi table Insert in Entity Framework

Upvotes: 1

Craig Stuntz
Craig Stuntz

Reputation: 126587

In EF 4 with FK associations your first code would "just work", so I'll assume you're using EF 1, although you don't say.

Workaround for EF 1 is:

Person newPerson = new Person();
newPerson.Id = 1;
// substitute the correct strings for your mapping.
newPerson.CategoryReference.EntityKey = 
    new EntityKey("MyEntities.Categories", "CategoryId", 1);
context.AddToPersonSet(newPerson);
context.SaveChanges();

You should not have Person.CategoryId mapped at all in EF 1. It shouldn't even be a part of the Person type.

Obviously, the best solution is to use EF 4. But if that's not an option, the above works fine.

Upvotes: 2

Related Questions