Writing my first MVC app and using VS2013 and SQL Server 2008 R2, EF6 and a database first approach.
I have all the basics working for my app, but not sure how to approach this issue. I have a jobs table (JobID is PK) and an items table (with JobID as FK). There can be millions of items per job and I want a count of items displayed in the job record.
I can easily make a view or an SP to return a column with the item count, but I have many more examples like this and want to learn the correct way to do things like this in MVC apps
Not sure how best to accomplish this.
Could someone point me int he right direction?