Based solely off of how it seems your database is arranged the SQL statement for the view would be
SELECT CategoryID = cat.ID
, cat.CategoryName
, ContentID = con.ID
, ContentLink = con.Link
FROM Categorie cat
INNER JOIN Contents con ON cat.ID = con.Category
Generally I would recommended using names that are not so ambiguous; such as CategoryID and ContentID.
The MVC Model would then start off as
public class CategoryContent {
public Category category { get; set; }
public Contents content { get; set; }
}
Submit an article or tip