Translate to NULLIF - Githubissues

dotnet / efcore

EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.

https://docs.microsoft.com/ef/

MIT License

13.68k stars 3.17k forks source link

Translate to NULLIF #31682

Open roji opened 1 year ago

roji commented 1 year ago

All relational database support, NULLIF, which is the inverse of COALESCE: NULLIF(value, '(none)') returns null if value is (none), otherwise the value is returned

Database	Functions
PostgreSQL	NULLIF
MySQL	NULLIF
MariaDB	NULLIF
SQLite	NULLIF
SQL Server	NULLIF
Oracle	NULLIF

bricelam commented 1 year ago

Oh funny, I thought I already filed an issue for this. It turns out it was just a comment. https://github.com/dotnet/efcore/issues/16092#issuecomment-529012832