I'm trying to get values of a table that's in SQL server. Currently we use
var selectproducts = new List<Product>();
using (var newdb = new NorthWNDModel())
selectproducts = newdb.Products.SqlQuery("dbo.GetProductsByCategory @p0", selectedCategoryID).ToList();
We would like to get the tables without using SQL. Is this possible? We are using Entity Frame 6.1 Code First from Database. If so, could you provide an example? Thanks.