How to find data using using primary key in Entity Framework?

Question

I'm using Entity Framework. I need to find a record using its primary key.

I try like this.

tabCom com = db.tabCom.Find(3);

but there is error and it says

'System.Data.Objects.ObjectSet' does not contain a definition for 'Find' and no extension method 'Find' accepting a first argument of type 'System.Data.Objects.ObjectSet' could be found (are you missing a using directive or an assembly reference?)

How to find the data using primary key. what the wrong with my code or Is there is another way?

MSDN link

Nilesh
– Nilesh

2013-08-26 02:20:30 +00:00
Commented Aug 26, 2013 at 2:20 — Nilesh
– Nilesh, Commented Aug 26, 2013 at 2:20

Jonesopolis · Accepted Answer · 2013-08-26 02:16:26Z

6

tabCom com = db.tabCom.Single(tab => tab.PrimaryKeyColumn == 3);

answered Aug 26, 2013 at 2:16

Jonesopolis

25.4k12 gold badges72 silver badges115 bronze badges

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

Comments

Timothy Walters · Accepted Answer · 2013-08-26 02:52:06Z

1

The Find method was introduced in EF 4.1.

In EF 5 it has optimizations that will check the in-memory cache before going off to the database. Using Single(entity => entity.PrimaryKey == id) will not provide the same optimization.

Please check which version of EF your code is referencing.

answered Aug 26, 2013 at 2:52

Timothy Walters

16.9k2 gold badges44 silver badges49 bronze badges

2 Comments

ta.speot.is Over a year ago

As best I can tell, Find is a member of DbSet. From OP: error ... says 'System.Data.Objects.**ObjectSet*' does not contain a definition for 'Find'*

Timothy Walters Over a year ago

@ta.speot.is that means not only do you have to worry about which version of EF, but also if it is DB-first or Code-first, with each getting slightly different features.

Collectives™ on Stack Overflow

How to find data using using primary key in Entity Framework?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related