tags:

views:

62

answers:

1

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
ok.. but i guess tracking can be disabled in EF for context level too..
Shetty