How to output related tables in ASP.NET MVC?

Question

ASP.NET

controller:

[HttpGet]
        public ActionResult Products()
        {
           



            return View();
        }
        
        [HttpPost]
        public ActionResult Products(string Buy)
        {

            return View();
        }

Products:
Trash

Query in SQL like this:

SELECT [Products].Name,[Products].Description,[Products].Price FROM Products,Trash WHERE [Trash].IdProduct=[Products].Id

How to present it in the controller, and then in the view? And with the help of what is it implemented?

Answer 1

Usually use an ORM like EntityFramework. It might be worth starting with examples .