Ok, I'm still getting asp.net and MVC framework freezes and converting my knowledge from classic ASP and VB - so please be careful.
I have my first look (/ home / details / X), functioning well thanks to the previous hint pointing me in the right direction , now I need to add data from several tables and queries / views to the MVC view (I hate that SQL and MVCs use the word representation for different meanings).
I'm not looking for someone to write me an answer (unless they really feel energetic), especially for someone to point me in the right direction, what should I look at, and read on to understand this and do it yourself.
My problem
There are several datasets that I need to display in this view, and every other dataset has the correct PK / FK 1-M ratio, and the resulting records should be looped.
How i would do it earlier
In my classic ASP days, I would simply define an SQL query at the top of the page where the data should have been used, with a select expression in rows:
SELECT * FROM query_name
WHERE query_uniquecolumnname = Request.QueryString("value")
Once this is done, you should set do while query_name NOT BOF / EOF up, then drop the names of the fields you want from this request, and all this has been done.
How to do it now?
, ASP, MVC?
/, , ( , , ), , , "", .