EF using skip and execute stored procedure

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)?

+4
source share

Source: https://habr.com/ru/post/1676789/


All Articles