How to get all rows on basis of a condition from entity framework

Question

I am building a website using MVC ASP.Net. In the website when user clicks a category, then i want to find all the items having that category as foreign key from entity framework database. I came across method of Find() but it doesn't fulfill my requirement. What I want is something like

Database1Entities.Categories.Select(x => x.Cat_Id == Id);

But I dont know the exact way to do this. Any Help will be highly appreciated.

Answer 1

How about using Where()

Database1Entities.Categories.Where(x => x.Cat_Id == Id);