I love the new modelbinding, but running in several issues.
Here I have a ef model with master detail. The page should show records and amount of Child records as number. Cause of the model binding, I have choosen to extend the model Master class with a propety amount, which returns in getter child.count.
Works, but is very slow, cause full select of master and one select for every child is fired in sql server (sql profiler).
If I would hack it as view or SP, join and count(*) would be much much faster.
So how to create model oder linq to optimize the query
Go to the complete details ...