Рассуждения о Generic Repository паттерне

public class GenericRepository<TEntity> : IGenericRepository<TEntity> where TEntity : class
    {
        private MyDbContext context;
        private DbSet<TEntity> dbSet;
 
        public GenericRepository(MyDbContext dbcontext)
        {
            this.context = dbcontext;
            this.dbSet = context.Set<TEntity>();
        }
 
        public IQueryable<TEntity> FindAll()
        {
              return dbSet;
         }

public IQueryable<TEntity> FindAll()
{
       return dbSet;
}

MyDbContext context = new MyDbContext();
GenericRepository<Product> productRepository = new GenericRepository<Product> (context);

var query = productRepository.FindAll().Where(p=>p.ID==23).ToList()

public IQueryable<TEntity> GetManyByFilter(Expression<Func<TEntity, bool>> filter)
        {
            IQueryable<TEntity> query = dbSet.Where(filter);
            return query;
        }

productRepository.FindAll().Where(p=>p......)
productRepository.FindAll().GroupBy(p=>p......)

query   {SELECT 
    [Extent1].[ID] AS [ID], 
    [Extent1].[Name] AS [Name], 
    [Extent1].[Adress] AS [Adress]
    FROM [dbo].[Products] AS [Extent1]
    WHERE 3 = [Extent1].[ID]}

query   {SELECT 
    [Extent1].[ID] AS [ID], 
    [Extent1].[Name] AS [Name], 
    [Extent1].[Adress] AS [Adress]
    FROM [dbo].[Products] AS [Extent1]
    WHERE 3 = [Extent1].[ID]}

dbContext.Products.Where(...)

var result = from p in productRepository.FindAll()
join c in customerRepository.FindAll() on p.CustomerId = c.CustomerId
where c.CustomerId=8
select p;

var result=productRepository.FindAll().Where(p=>p.Customer.CustomerID==8)

List<Product> products = customerRepository.GetProducts(8);

var someData = context.Where(sd => sd.Prop == num); //IEnumerable

var someData = context.Where(sd => sd.Prop == num); //Queryable

var someData = context.Where(sd => sd.Prop == num);