dataContext.storedProcedure(params).Skip(4).Take(3) - where is it executed

[Seishin]

Hi! let's assume that the sproc returnes 20 rows. well, i know that the sproc is going to be executed on the DB but will Skip and Take do their stuff after the data (20 rows) from the sproc is returned to the application or will linq "do it's magic" and call converted to sql statements Skip and Take on the DB and return only 3 rows to the application? thanks for any help

life is study!!!

[pmarfleet]

You can check this yourself. Load up SQL Profiler and execute a trace on your database. Step through your LINQ code in debug mode and observe what SQL statements are being executed against the database from the trace output.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[Pete OHanlon]

Skip and Take will work on the data that has been returned from the stored procedure. There's no way that it could step into the SP and change its behaviour.

Deja View - the feeling that you've seen this post before.

My blog | My articles

[Seishin]

hmm.. well I was wondering if linq can convert such a call into a query with exec sproc and select rows from the resluts of exec.. oh, well.. I'll have to work this paging problem some other way.. thanks for your reply!

life is study!!!

[Seishin]

there's no profiler with sql express :/

life is study!!!

[pmarfleet]

You might want to look at this[^] then.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[Seishin]

thanks a lot!!!

life is study!!!