How to seed data with AddOrUpdate with a complex key in EF 4.3

c# entity-framework-4.3 seed linq-expressions entity-framework-migrations
Keith Sirmons picture Keith Sirmons · Apr 19, 2012 · Viewed 34.1k times · Source

I am trying to seed a development database with some test data.

I have used context.People.AddOrUpdate(p => p.Id, people)); with much success.

I have another table that I need to seed, in which I would not know the primary key.

For example, I would want to AddOrUpdate based on the First and Last names matching.

I am unsure how to write the Expression correctly.

context.People.AddOrUpdate(p => p.FirstName && p.LastName, people);

is obviously incorrect, but I hope it conveys the solution I am looking for.

Answer

Ladislav Mrnka picture Ladislav Mrnka · Apr 19, 2012

Try this:

context.People.AddOrUpdate(p => new { p.FirstName, p.LastName }, people);

Related questions

What difference does .AsNoTracking() make?

I have a question regarding the .AsNoTracking() extension, as this is all quite new and quite confusing. I'm using a per-request context for a website. A lot of my entities don't change so don't need to be tracked, but I …

Read More
Mapping a foreign key with a custom column name

I'm using Entity Framework 4.3 code-first with Oracle. I'm getting the following error: System.InvalidOperationException : The ForeignKeyAttribute on property 'WidgetSequence' on type 'WidgetDistributor.WidgetEntity' is not valid. The foreign key name 'WIDGETSEQUENCE_ID' was not found on the dependent type 'WidgetDistributor.…

Read More
conversion of a datetime2 data type to a datetime data type error with EF Code first?

I'm using EF Code first with my asp.net mvc application. here is my code: Request.RequestDate = DateTime.Now; the type of RequestDate is datetime in my database. and this is error that occurred when i use the above code!: …

Read More