I want to select all rows from a table using the following type of syntax:
public IQueryable<Company> GetCompanies()
{
return DbContext.Set<Company>()
.// Select all
}
Forgive me as I am completely new to EF.
Add a comment
|
3 Answers
Set<T>() is already IQueryable<T> and it returns all rows from table
public IQueryable<Company> GetCompanies()
{
return DbContext.Set<Company>();
}
Also generated DbContext will have named properties for each table. Look for DbContext.Companies - it's same as DbContext.Set<Company>()
answered Dec 1, 2012 at 11:17
Sergey Berezovskiy
237k44 gold badges441 silver badges468 bronze badges
2 Comments
Demodave
Does this not need async?
Erik Philips
It does not need async, but it is compatible with it.
The normal way to do this is by instantiating your dbContext.
For example:
public IQueryable<Company> GetCompanies()
{
using(var context = new MyContext()){
return context.Companies;
}
}
There are lots of good tutorials on using CodeFirst Entity framework (which i assume you are using if you have a DbContext and are new)
Comments
I prefer work on list, also have all relations here
For example:
public List<Company> GetCompanies()
{
using (var context = new MyContext())
{
return context.Companies.ToList();
}
}
1 Comment
CrossBound
Use
.ToListAsync() if you want to do this asynchronously and avoid the blocking call