I have a basic EF4 model with two entities. I'm using Self Tracking Entities
Client has ClientAddresses relationship on clientkey = clientkey. (1 to many)
How do i get a list/collection of client entities (STE) and their addresses (STE) but only ones where they live in a particular state or some such filter on the address???
This seems to filter and bring back clients but doesnt bring back addresses.
var j = from client in context.Clients
where client.ClientAddresses.All(c => c.ZIP == "80923")
select client;
I cant get this to create the Addresses because ClientAddresses is IEnumerable and it needs a TrackableCollection
var query = from t1 in context.Clients
join t2 in context.ClientAddresses
on t1.ClientKey equals t2.ClientKey
where t2.ZIP == "80923"
select new Client
{
FirstName = t1.FirstName,
LastName = t1.LastName,
IsEnabled = t1.IsEnabled,
ClientKey = t1.ClientKey,
ChangeUser = t1.ChangeUser,
ChangeDate = t1.ChangeDate,
ClientAddresses = from a in t1.ClientAddresses
select new ClientAddress
{
AddressKey = a.AddressKey,
AddressLine1 = a.AddressLine1,
AddressLine2 = a.AddressLine2,
AddressTypeCode = a.AddressTypeCode,
City = a.City,
ClientKey = a.ClientKey,
State = a.State,
ZIP = a.ZIP
}
};
Any pointers would be appreciated.
Thanks
Edit:
This seems to work....
var j = from client in context.Clients.Include("ClientAddresses")
where client.ClientAddresses.Any(c => c.ZIP == "80923")
select client;
