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.
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>
()
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)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With