Pfthb

I want to do a query with lambda expression.
My database is a Cosmos DB.
I want to filter for two parameters and one of the two can be null.

For example i want to search for name and lastname and one of both is null.

This is that I am trying:

var result = this._client.CreateDocumentQuery<Person>(
 UriFactory.CreateDocumentCollectionUri(_idDatabase, _idCollection), queryOptions)
 .Where((f) => f.Name == Name && f.LastName == lastName )
 .AsEnumerable()
 .ToList();

So this?

var result = this._client.CreateDocumentQuery<Person>(
 UriFactory.CreateDocumentCollectionUri(_idDatabase, _idCollection), queryOptions)
 .Where((f) => (f.Name == Name || (f.Name == null && f.LastName != null)) && (f.LastName == lastName || (f.LastName == null && f.Name != null))
 .AsEnumerable()
 .ToList();

try something like this:

var result = this._client.CreateDocumentQuery<Person>(
 UriFactory.CreateDocumentCollectionUri(_idDatabase, _idCollection), queryOptions)
 .Where(f => f.Name == $"Name ?? f.Name") &&
 f.LastName == $"lastName ?? f.LastName") )
 .AsEnumerable()
 .ToList();

Maybe you can work with IQueryable:

IQueryable<Person> iPerson = this._client.CreateDocumentQuery<Person>(
 UriFactory.CreateDocumentCollectionUri(_idDatabase, _idCollection), queryOptions);

if(Name != null) iPerson = iPerson.Where(f => f.Name == Name);
if(lastName != null) iPerson = iPerson.Where(f => f.LastName == lastName)
return iPerson.AsEnumerable().ToList();