static void Main(string[] args) { // example 1 // via Entity framework from database using (var context = new ViaEF.MyExampleEntities()) { var result1 = context.GetProducts(); var result2 = context.GetProductsFilteredByRating(4); var result3 = context.GetProductsById(1); var result4 = context.GetTwoCollectionOfProducts(); } // example 2 // using (var context = new ViaEF.MyExampleEntities()) { context.Database.Log = logInfo => Debug.WriteLine(logInfo); var result = context.Database.SqlQuery <ViaEF.Products>("SELECT * FROM Products").ToList(); var result2 = context.Database.SqlQuery <ViaEF.Products>("exec GetProducts").ToList(); var result3 = context.Products.Select(x => new { x.ID, x.Name }).Where(x => x.ID > 2).ToList(); } }