// 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;
}
