simshp
asked on
Linq to sql LET statement
Can the "let" statement be used to create joins in linq to sql or just temporary variable. For example here :
var r =
from cust in Cust.GetTable()
let invs = cust.InvoiceDetails
let jobs = cust.Jobs
select new
{
.
.
.
};
var r =
from cust in Cust.GetTable()
let invs = cust.InvoiceDetails
let jobs = cust.Jobs
select new
{
.
.
.
};
Can you expand? I don't see where you are trying to do a join in the above example.
ASKER
Thanks .. I am just asking a factual question ... I am new to linq - so the from the code I posted, are the let stmts just assigning a column value to a variable. Like
let invs = cust.InvoiceDetails
simply places the all the columns values into the variable invs ?
let invs = cust.InvoiceDetails
simply places the all the columns values into the variable invs ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
Not a problem, just glad to help.
try this way
Open in new window