I read in some article that LINQ to SQL gives better performance when executing stored procedure than Entity framework. Any obvious reasons for it?
A:
There could be a performance difference, in L2S you can make your sproc return a list of l2s objects which are going to be tracked for changes. For large result sets this could be a severe performance hit, if you're not going to change these objects.
I don't know how Entity Framework handles these kind of situations.
In L2S you can also turn this behaviour off in your datacontext. (ObjectTrackingEnabled = false)
JJoos
2010-04-28 09:23:53
ok.. but i guess tracking can be disabled in EF for context level too..
Shetty
2010-05-06 04:38:10