linq query : let with include statement

Question

When I execute this request

var req = (from A in _context.STUDENT.Include("RESULT")
                   select A).ToList();

I have the expected result : For each STUDENT I have a number of RESULTs

but when I add a let statement like below, for each student I have 0 RESULT

var req = (from A in _context.STUDENT.Include("RESULT")
                   let b = 1
                   select A).ToList();

I'm I doing something wrong or is it a known issue or something ?

Answer 1

A let statement that is not used should have no impact on your query.

To be sure, turn logging on and see for yourself in the console output that the generated TSQL is identical for both queries:

myContext.Log = Console.Out;