Hi there
I am retrieving data from SQL 2005 / .NET 2.0 in a fairly common scenario.
The only thing is that I am using views to filter my role based data retrieval. I am going around in circles trying to figure out the best performance strategy.
I have the following views..
vwCategoryDetails ( Contains Category + CategoryRoles joined ~ 2 tables )
vwCategoryProductDetails ( Contains many to many intersection table from Category to Product ~ Single table )
vwSkuDetails ( Contains SKU + SKURoles joined ~ 2 tables )
Now, on one of my pages I need to display a unique Category ( single entity ) and all the related Products for the Category, and all the Related SKUs for the Products.
I used to use prefetches for related entities and use the Category entity, but now it's in a view ( vwCategorydetails ) , I don't have access to get a single entity by unique contraint ( even though effectively the view will bring a unique record back using composite key = role, CategoryName ) .
I don't know if I should be using data readers, SP's with projections of Entity fetches. The whole thing would be read only.
I appreciate any advice you can give me!
thanks for your time
Kind regards
Martin