.First or .FirstOrDefault does not work

[Carloscrmk]

This code is giving the following exception:
_context.User.FirstOrDefault(p => p.Id == 3)

exception:
"ORA-00933: SQL command not properly ended"

When I use .ToList() work normaly

[alexkeh]

I assume you are using Oracle DB 11.2. If so, use the extension method and set it to UseOracleSQLCompatibility("11") as described in the doc included with the NuGet package.

[Carloscrmk]

Tks!!!