public List <Product> GetProductByTag(int pageSize = 4, int pageNumber = 1, string ProductName = null) { var results = ctx.Set <Product>().FromSqlRaw("exec SP_GetProductByTag '',1,1").ToList(); return(results); //var userType = ctx.Set().FromSql("dbo.SomeSproc @Id = {0}, @Name = {1}", 45, "Ada"); //ctx.Database.ExecuteSqlCommand() //ctx.Products.FromSql("GetStudents 'Bill'").ToList(); //IList<TEntity> ts = new List<GetProductByTag>(); //IList<TEntity> ts = new List<TEntity>(); //var user = new SqlParameter("user", "johndoe"); // var userTypeProductsoaramslissdst = ctx.Set<GetProductByTag>().FromSqlRaw("exec SP_testCategories").ToList(); //var userTypeProductsoaramslisttestresult = ctx.testresult.FromSqlRaw("exec SP_testCategories").ToList(); //var userTypeProductsoaramslist = ctx.Products.FromSqlRaw("exec SP_testCategories").ToList(); //var userTypeProductsoaramslissdstsds = ctx.Set<testresult>().FromSqlRaw("exec SP_testCategories") // .Select(e => (object)e) // .ToList(); //var userTypeProductsoarams = ctx.Products.FromSqlRaw("exec SP_testCategories"); //var u85 = ctx.Products.FromSqlRaw("select 85 where 1=1").ToList(); //var sdfsd = ctx.Database.ExecuteSqlRaw("exec SP_testCategories"); //var sdfssdd = ctx.Database.ExecuteSqlRaw(@"select 85 where 1=1"); //var userType = ctx.Set().FromSql("dbo.SomeSproc @Id = {0}, @Name = {1}", 45, "Ada"); //var userTypeProducts = ctx.Products.FromSqlRaw("exec SP_GetProductByTag '',1,1"); //var userTypeProductsoarams2 = ctx.Products.FromSqlRaw("exec SP_GetProductByTag", "", 1, 1); //ctx.Products.FromSqlRaw("GetStudents 'Bill'").ToList(); //ctx.Database.FromSqlRaw("GetStudents 'Bill'").ToList(); }
public async Task <IEnumerable <Product> > GetProductsbyParentcategoriAsync(int pageSize = 4, int pageNumber = 1, string category = null) { int CAtegoriID = ctx.Categories.FirstOrDefault(c => c.CategoryName == category).CategoryId; var results = ctx.Set <Product>().FromSqlRaw("exec SP_GetProductsbyParentcategori {0}, {1},{2}", pageSize, pageNumber, CAtegoriID).ToListAsync(); return(await results); }
public TEntity Add(TEntity entity) { try { ctx.Set <TEntity>().Add(entity); ctx.SaveChanges(); return(entity); } catch (Exception ex) { throw; } }