C Sharp - Linq - Where

You can add Where clauses to linq statements.

Here is an example

public IResult<List<NoteEntity>> GetAll(string companyKey)
{
    return new Result<List<NoteEntity>>(_context.Notes
                                    .Where (r => r.CompanyKey == companyKey)
                                    .Include(r => r.NoteTypeEntity)
                                    .ToList()
                            ).ReturnSuccess(LogInformation("Retrieved all Notes records successfully"));
}

Notice the where clause

I think you put this before include for performance.

For an And statement use && instead of and.

For example

.Where (e => e.Id == id && e.CompanyKey == companyKey);