c# - How can I make this LINQ to SQL where clause with conditions faster?

Question

I have the following LINQ to SQL query but I want to know if there is a faster way to validate data from a post action before adding them in a where clause? ex:

bookFilter = Informations coming from the post action

int count = from b in _libraryContext.Book
            join ba in _libraryContext.BookAuthor
            on b.Id equals ba.BookId
            where (!string.IsNullOrWhiteSpace(bookFilter.Name) ? 
            b.Name.Contains(bookFilter.Name.ToUpper()) : 1 == 1 )
            where (!string.IsNullOrWhiteSpace(bookFilter.Decription) ? 
            b.Description.Contains(bookFilter.Description.ToUpper()) : 1 == 1)
            where (bookFilter.BookId > 0 ? ba.BookId == bookFilter.BookId : 1 == 1)

return count;

question from:https://stackoverflow.com/questions/65891994/how-can-i-make-this-linq-to-sql-where-clause-with-conditions-faster

Answer 1

I've never used this type of syntax much so I'm sure if you can do it this way, but you can certainly do it with LINQ and build up your query step by step like so:

var query = _libraryContext.Set<Book>();

if(!string.IsNullOrWhiteSpace(bookFilter.Name))
{
    query = query.Where(x => x.Name.Contains(bookFilter.Name.ToUpper()));
}

if(!string.IsNullOrWhiteSpace(bookFilter.Description))
{
    query = query.Where(x => x.Description.Contains(bookFilter.Description.ToUpper()));
}

if(bookFilter.BookId > 0)
{
    query = query.Where(x => x.BookId == bookFilter.Id);
}

return query.Count();

Note: I have omitted the JOIN here as it seems unnecessary, but you can of course do the join in this syntax too if you need it.