public Sales_InvoiceQuery <Sales_InvoiceLineQuery <K, T>, T> JoinSales_Invoice(JoinType joinType = JoinType.Inner, bool preloadEntities = false)
{
var joinedQuery = new Sales_InvoiceQuery <Sales_InvoiceLineQuery <K, T>, T>(Db);
return(Join(joinedQuery, string.Concat(joinType.GetJoinString(), " [Sales].[Invoices] AS {1} {0} ON", "{2}.[InvoiceID] = {1}.[InvoiceID]"), o => ((Sales_InvoiceLine)o)?.Sales_Invoice, (e, fv, ppe) =>
{
var child = (Sales_Invoice)ppe(QueryHelpers.Fill <Sales_Invoice>(null, fv));
if (e != null)
{
((Sales_InvoiceLine)e).Sales_Invoice = child;
}
return child;
}
, typeof(Sales_Invoice), preloadEntities));
}
public Sales_InvoiceQuery <Sales_OrderQuery <K, T>, T> JoinSales_Invoices(JoinType joinType = JoinType.Inner, bool attach = false)
{
var joinedQuery = new Sales_InvoiceQuery <Sales_OrderQuery <K, T>, T>(Db);
return(JoinSet(() => new Sales_InvoiceTableQuery <Sales_Invoice>(Db), joinedQuery, string.Concat(joinType.GetJoinString(), " [Sales].[Invoices] AS {1} {0} ON", "{2}.[OrderID] = {1}.[OrderID]"), (p, ids) => ((Sales_InvoiceWrapper)p).Id.In(ids.Select(id => (System.Int32)id)), (o, v) => ((Sales_Order)o).Sales_Invoices.Attach(v.Cast <Sales_Invoice>()), p => (long)((Sales_Invoice)p).OrderID, attach));
}
