An example of using LINQ in a C# repository to filter data by tenant ID

ProductRepository.cs

public class ProductRepository : IProductRepository
{
    private readonly DatabaseContext _context;

    public ProductRepository(DatabaseContext context)
    {
        _context = context;
    }

    public async Task<ProductModel> Get(int tenantId)
    {
        /* 
          LINQ query that compiles to something like the below in SQL:

              SELECT * FROM product as p
              WHERE p.tenant_id = {tenant_id};
        */

        return await _context.Products
            .Where(p => p.TenantId == tenantId)
            .ToListAsync();
    }
}