Query syntax: var count = (from t in context.MyTable where t.Id == @Id select t).Count(); Method syntax: var count = context.MyTable .Where(t => t.Id == @Id) .Count() Both generate the same SQL query.
Category: Entity Framework
Most Viewed Posts
- Get the User Name and Domain Name from an Email Address in SQL (843)
- Get the First and Last Word from a String or Sentence in SQL (754)
- How to select distinct rows in a datatable in C# (697)
- How to add default value for Entity Framework migrations for DateTime and Bool (584)
- Add Constraint to SQL Table to ensure email contains @ (519)