Get object by ID eg SQL WHERE predicate in Entity Framework

Question

I had a look at Entity Framework, get object by ID.

I can't get that to work.

I specifically want the

WHERE [Extent1].[CatId] = 1

as I don't want to return everything that filter it as in

using (ApplicationContext db = new ApplicationContext())  
{
    IQueryable<Project> projects = db.Projects; // Get all
    var p =  (from i in db.Projects where i.Id == ProjectID select i);
    Console.WriteLine("Project #  {0} added and Named:{1} ", ProjectID, p.First().Name);
    Assert.IsNotNull(projects.First().Name);
}

So what I am looking for in SQL terms is

SELECT *   
FROM Projects 
WHERE id = 1

Hope that makes sense.

It's not really clear what the issue is. Are you just looking for db.Projects.Single(p => p.Id == ProjectID)? — David
– David, Commented Jun 26, 2015 at 14:03

mateuscb · Accepted Answer · 2015-06-26 14:09:04Z

0

You should be able to use LINQ fluent syntax:

var project = db.Projects.SingleOrDefault(i => i.Id == ProjectId);

Great LINQ reference and examples

edited Jun 26, 2015 at 14:09

answered Jun 26, 2015 at 14:03

mateuscb

10.8k3 gold badges55 silver badges76 bronze badges

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

Collectives™ on Stack Overflow

Get object by ID eg SQL WHERE predicate in Entity Framework

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related