public HomeIndexViewModel CreateModel(string search) { using (var _context = new OnlineshoppingDBEntities()) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@searchText", search ?? (object)DBNull.Value) }; //SqlParameter param = null; //SqlParameter param = new SqlParameter("@searchText", search ?? (object)DBNull.Value); //IEnumerable<tblProduct> lst = _context.Database.SqlQuery<tblProduct>("GetSearch @searchText", param); IEnumerable <tblProduct> lst = repositoryProduct.spCall("GetSearch @searchText", param); return(new HomeIndexViewModel { lstproducts = lst.ToList() }); } }
public Repository(OnlineshoppingDBEntities db) { this._Context = db; _dSet = _Context.Set <T>(); }