Which LINQ statement is efficient for searching record using entity framework

Question

Which of the following statements is efficient for searching record from database using Entity Framework.

 var user = db.User.Where(u => u.id == userid).FirstOrDefault();
 // or
 var user = db.User.FirstOrDefault(u => u.id == userid);

Although both work.

Robert Wagner · Accepted Answer · 2014-03-11 22:48:25Z

5

They will both be evaluated to the same SQL.

Use SQL Profiler to see what SQL is created.

answered Mar 11, 2014 at 22:48

Robert Wagner

17.8k9 gold badges59 silver badges72 bronze badges

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

1 Comment

This is such a simple query that it won't matter how you write it, it'll be the same SQL