You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Query to the server would be:
exec sp_executesql N'SELECT TOP(@__p_1) [b].[BlogId] AS [Id]
FROM (
SELECT * FROM Blogs
) AS [b]',N'@__p_1 int',@__p_1=100
As it should be.
So why ef can't capsulate sql query correctly without Take-parameter?
Sample: EFGetStarted.zip
The text was updated successfully, but these errors were encountered:
I noticed that EF is doing a rather inefficient query
If I made query like:
Query to the server would be:
SELECT * FROM Blogs
It should be:
SELECT [b].[BlogId] AS [Id]
FROM
(
SELECT * FROM Blogs
) AS [b]
If I add Take-parameter to ef query
Query to the server would be:
exec sp_executesql N'SELECT TOP(@__p_1) [b].[BlogId] AS [Id]
FROM (
SELECT * FROM Blogs
) AS [b]',N'@__p_1 int',@__p_1=100
As it should be.
So why ef can't capsulate sql query correctly without Take-parameter?
Sample:
EFGetStarted.zip
The text was updated successfully, but these errors were encountered: