The linq expression is in a method of a class which has access to a
single model of my database schema (I believe that is what you mean
from DataContext).
The method is called each time with a different input, which
represents the element for the where clause of the select.
Simplified method:
public List<Slot> GetWarehouseSlotDetails(WarehouseStation
warehouseStation)
{
var slots = from ps in SchemaModel.PickSlot
where ps.StationID ==
warehouseStation.Id.Value
join s in SchemaModel.SkU on ps.SkUID
equals s.SkUID into tmpProductSlot
from subsku in
tmpProductSlot.DefaultIfEmpty()
select new
{
ps.PickSlotID,
subsku.Description
};
}
Thank you,
James
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en
-~----------~----~----~----~------~----~------~--~---
