search

yv989c / BlazarTech.QueryableValues

This library allows you to efficiently compose an IEnumerable<T> in your Entity Framework Core queries when using the SQL Server database provider.
Other
93 stars 6 forks source link

Question: Nullable columns #48

Closed topherZa closed 7 months ago

topherZa commented 7 months ago

Hi, I'm trying to convert a few of my existing queries to use your library and one of them is causing an issue.

I've got a Guid? column in my table that I'm attempting to do a Contains on.

Using .Value will throw an error because it causes client side evaluation.

I get the below error:

Error CS1929 'IQueryable' does not contain a definition for 'Contains' and the best extension method overload 'MemoryExtensions.Contains<Guid?>(ReadOnlySpan<Guid?>, Guid?)' requires a receiver of type 'System.ReadOnlySpan<System.Guid?>'

Is there any alternative/recommended approach?

Thanks in advance.

EDIT:

I think I've resolved it by using the Join function instead. Thanks for the useful tool.