December 7, 2012 at 9:31 am
Hi all,
I'm currently experiencing problem with a C# application that runs query against a SQL Server 2008 R2 database. A SQL command is issued through Entity Framework and using SQL Server genuine trace tool, I can see that it takes 8 minutes for the query to bring the required 6000 rows back.
When I copy the query text from the statement in tracing tool, and run it "as is" in a Management Studio query upon the same database, the query always complete within two seconds.
I'm really disappointed. Does anyone have explanation to that strange behavior?
Thanks a lot.
Jean-Yves
December 7, 2012 at 11:04 am
I've heard nothing but bad things about Entity Framework, but that aside, have you tried (and will EF support?) putting that query iinside of a stored procedure and have the framework execute that instead ? Let me know...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply