Bug detected with PGSQL provider
Sorry if not the right spot for this:
Found a bug this evening:
This query: Drivers.Where(d => d.UserId == 1)
Returns this error: "Column is null"
The generated SQL query is:
SELECT d."DriversId", d."Aggression", d."CarId", d."CarNumber", d."CreatedDate", d."CustId", d."DriverAge", d."DriverName", d."Optimism", d."PitCrewSkill", d."RosterId", d."Skill", d."Smoothness", d."StrategyRiskiness", d."UpdateDateTime", d."UserId"
FROM "Drivers" AS d
WHERE d."UserId" = 1
GO
If I run that SQL query in DataGrip, it fails. If I delete the "GO" and run it, the query runs perfectly fine.
Further, when I test the method from my C# application, the LINQ query:
Drivers.Where(d => d.UserId == 1) works as expected and returns the objects from the database.
Again, sorry if this isn't the right place for this.
Thanks!
![](https://secure.gravatar.com/avatar/8aa5e2f036e525845f0760733182d77a?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)