MVC need to link 2 tables into one model?

Question

I have a C# MVC project with a database first approach. I also have to tables Products and Company. The product has a foreign key to the company table. I want to be able to load the product as a model yet be able to show the company code and logo with the product information.


I have looked at a lot of different articles etc but it doesn't seem to answer my question.


I'm not new to C# ASP.NET but am new to the MVC side.