How to work Skip()and Take()in the Entity Framework when you call a stored procedure? I cannot access the sql profiler for verification, but I want me to optimize the amount of data sent between the servers.
Let's say I have the following code where it MyStoredProcedurereturns 1000+ lines.
List<MyComplex_Result> myComplexList = db.MyStoredProcedure()
.Skip(50)
.Take(10);
Will it Take(10)make sure that only 10 of these rows are sent from the database server to the web server or all 1000+ rows will be sent (although only 10 will be sent to the client)?
source
share