don't user Where clause in SQL if use predicate as Func<...>

if i run this code

var _context = new LightSpeedContext<LSModel.LSModelUnitOfWork>();
using (var context = _context.CreateUnitOfWork())
{
                Func<LSModel.Consumer, bool> predicate = c => c.Id < 10;
                var list = context.Consumers.Where(predicate);
}

it use this select

SELECT   consumers.consumerID AS "consumers.consumerID",   consumers.Created AS "consumers.Created",   consumers.Name AS "consumers.Name"
FROM   consumers

without WHERE  section

But if i change last line on

                var list = context.Consumers.Where( c => c.Id < 10);

it work right and create WHERE section

addition:

if i use

var list = context.Consumers.Where( c => c.Id < 10);

Console.Write(list.Count());

this corresponds SQL

 SELECT  COUNT(*) FROM  consumers WHERE consumers.consumerID < 10

Func<LSModel.Consumer, bool> predicate = c => c.Id < 10;
var list = context.Consumers.Where(predicate);

this corresponds SQL

 SELECT   consumers.consumerID AS "consumers.consumerID",  consumers.Created AS "consumers.Created",  consumers.Name AS "consumers.Name"
FROM  consumers

without COUNT clause

Thanks to all. The mistake I found a solution.
The fact that there are two different functions Where
one for class IQueryable
public static IQueryable <TSource> Where <TSource> (this IQueryable <TSource> source,

Expression <Func <TSource, bool>> predicate);

one for IEnumerable
public static IEnumerable <TSource> Where <TSource> (this IEnumerable <TSource> source,

Func <TSource, bool> predicate);


in that code in the example was used  IEnumerable

 

rewrote the code

Expression<Func<LSModel.Consumer, bool>> predicate = c => c.Id < 10;

var list = context.Consumers.Where(predicate);

everything worked.