-
Notifications
You must be signed in to change notification settings - Fork 454
New issue
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
[Association] with QueryExpressionMethod does not honor CanBeNull property #4454
Comments
It is not a bug, we have special code which ignores CanBeNull for complex associations. Does it make performance isssues for your queries? |
This looks like a dupe of #3658, which was supposedly fixed in 5.0.0. |
For what reason?
No, it doesn't. At least for now. It's more about correctness. I don't know what is the point of
I tested with SqlServer and Sqlite. Queries was slighly different, but I doubt it matters. |
Describe your issue
If
CanBeNull
is false, I would expect generated SQL to useINNER JOIN
orCROSS APPLY
. But it usesLEFT JOIN
orOUTER APPLY
instead.Steps to reproduce
Environment details
Linq To DB
version: 5.4.0Database (with version): SQL Server 2008
ADO.NET Provider (with version): Microsoft.Data.SqlClient 4.1.0
.NET Version: .NET Core 2.1
The text was updated successfully, but these errors were encountered: