Today, we translate this as @value IS NULL OR LTRIM(RTRIM(@value)) = N''. But I have a few questions:

1. Why do we trim both the start and the end? Just one would produce the same result with less processing.
2. More importantly, why do we trim at all? As we know from our StartsWith research, N' ' = N'' returns true in SQL Server.

IMHO, the translation should be `@value IS NULL OR @valu

Great article, but please note that "setup" is a noun, and not a verb.

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 97d622b2-1e4b-4d76-b3df-fefaa5ba99cb
• Version Independent ID: ec833af2-275e-981f-689f-8c65edfc00cd
• Content: [Generated Values - EF Core](https://docs.microsoft.com/en-us/ef/core/modeling

date_trunc('week', now()::date

Looking to make a call similar to this, and can't figure out what should be used now. I've also looked at EF.Property<DateTime>() but that doesn't seem to help.