// GET: ProductList public ActionResult Index() { using (mvcContext db = new mvcContext()) { string sqlQuery = @"select p.ProductID ,p.ProductName,ps.Price,ps.Image,p.Quantity from Products p join (select * from( select ROW_NUMBER()OVER(PARTITION BY [ProductID],[Price] ORDER by [ProductID])as rown,* FROM [ProductSpecifications])AS T1 WHERE rown = 1) ps on ps.ProductID=p.ProductID"; var Results = db.Database.SqlQuery <ProductListViewModels>(sqlQuery).ToList(); return(View(Results)); } }
public SellerService(mvcContext context) { _context = context; }
public DepartmentsController(mvcContext context) { _context = context; }
public SeedingService(mvcContext context) { _context = context; }