Find object for given primary key in entity framework

c# .net entity-framework system.data.sqlite
saurabh picture saurabh · Dec 4, 2011 · Viewed 19.8k times · Source

I have a table "Customer" and it's corresponding ORMapping Entity Customer in entity framework and I want to find an object corresponding to a given primary key. Something like customerobject.getbjectByID() instead of lambda expression or query.

Answer

Icarus picture Icarus · Dec 4, 2011 
var Customer = from c in datacontext.Customer
               where c.CustomerID == your_key
               select c;

That's assuming your customer table has a CustomerID column and that is the primary key.

Using DbSet's Find method:

Customer customer= db.Customer.Find(your_key);

Using a lambda expression:

 var customer= dataContext.Customer.Where(x=>x.CustomerID==your_key).FirstOrDefault();

Related questions

MetadataException: Unable to load the specified metadata resource

All of a sudden I keep getting a MetadataException on instantiating my generated ObjectContext class. The connection string in App.Config looks correct - hasn't changed since last it worked - and I've tried regenerating a new model (edmx-file) from …

Read More
Unable to update the EntitySet - because it has a DefiningQuery and no <UpdateFunction> element exist

I am using Entity Framework 1 with .net 3.5. I am doing something simple like this: var roomDetails = context.Rooms.ToList(); foreach (var room in roomDetails) { room.LastUpdated = DateTime.Now; } I am getting this error when I try to do: context.SaveChanges(); …

Read More
How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?

Is there a way to compare two DateTime variables in Linq2Sql but to disregard the Time part. The app stores items in the DB and adds a published date. I want to keep the exact time but still be …

Read More