We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
The column alias seems to be missing when using window functions with IQueryable.ToQueryString().
Other columns are aliased ok.
taking this example from the docs:
using var dbContext = new MyDbContext(); var query = dbContext.TestRows .Select(r => new { Max = EF.Functions.Max( r.Col1, EF.Functions.Over() .OrderBy(r.Col2)), });
States it generates this SQL:
SELECT MAX([t].[Col1]) OVER(ORDER BY [t].[Col2]) AS [Max] FROM [TestRows] AS [t] ORDER BY [t].[Id]
but when using:
IQueryable<>.ToQueryString()
seems to generate the below (no alias on col1):
SELECT MAX([t].[Col1]) OVER(ORDER BY [t].[Col2]) FROM [TestRows] AS [t] ORDER BY [t].[Id]
This is a problem as we are are using the ToQueryString() to generate source controlled SQL views which need column aliases
any ideas? Thanks
The text was updated successfully, but these errors were encountered:
No branches or pull requests
The column alias seems to be missing when using window functions with IQueryable.ToQueryString().
Other columns are aliased ok.
taking this example from the docs:
States it generates this SQL:
but when using:
seems to generate the below (no alias on col1):
This is a problem as we are are using the ToQueryString() to generate source controlled SQL views which need column aliases
any ideas? Thanks
The text was updated successfully, but these errors were encountered: