Apr
15
comment Simple Query Running slowly in SQL Server?
Of course I am. But the code you posted products.include(p => p.Image) will select all. Please paste your code exactly how it is in your question.. as this could have a big effect to how EF is constructing your query..
Apr
15
comment Simple Query Running slowly in SQL Server?
So you're returning 50000 products at once? And you're selecting every column from Product and Image? Why?
Apr
15
comment Simple Query Running slowly in SQL Server?
Yes, but show the code you are writing which generates this query.. Ie your LINQ code in your method
Apr
15
comment Simple Query Running slowly in SQL Server?
What is your code that you are writing which outputs this query?
Apr
11
answered Mapping Foreign Key twice with different names in Entity Framework
Apr
10
comment Populate one dropdown list based on the selection of other dropdown
What happens at the minute?
Apr
9
comment ForeignKey attribute is not valid error
Have you added a new migration to reflect the change in your model?
Apr
9
comment ForeignKey attribute is not valid error
Hmm, see my edit again, I've just created that with no problems..
Apr
9
revised ForeignKey attribute is not valid error
added 1266 characters in body
Apr
9
revised ForeignKey attribute is not valid error
[Edit removed during grace period]
Apr
9
comment ForeignKey attribute is not valid error
Try making Linea virtual, see my edit.
Apr
9
answered ForeignKey attribute is not valid error
Apr
4
awarded Taxonomist
Apr
4
accepted Casting chars to integers gives unexpected values
Apr
4
asked Casting chars to integers gives unexpected values
Apr
4
answered Creating an admin page in asp.net mvc 5
Apr
1
answered The model item passed into the dictionary is of type 'System.Collections.Generic.List`,
Apr
1
revised asp.net using a different model in a partial view than in its parent?
added 1 characters in body
Apr
1
comment asp.net using a different model in a partial view than in its parent?
If you show some code on how you're currently populating your model, I will show you how to do it the first way.. I don't know how you're currently doing it..
Mar
28
comment Correct query using Entity Framework
Thanks for the correction. I've changed my answer to state that its Eager loading, not Lazy Loading :)
1 2 3 4 5