SELECT DISTINCT D.ID, D.Name, D.CreateDate, D.UpdateDate, D.Active FROM Domain AS D
LEFT JOIN dbo.Domain2Host AS D2H ON (D.ID = D2H.FK_DomainID)
LEFT JOIN dbo.Host AS H ON (D2H.FK_HostID = H.ID)
LEFT JOIN dbo.Host2IP AS H2I ON (H.ID = H2I.FK_HostID)
LEFT JOIN dbo.IP ON (H2I.FK_IPID = IP.ID)
WHERE IP.Address LIKE @IPAddres
entities.IP.Where(ip => ip.Address == "74.125.87.99").First().Host.First().Domain.AsEnumerable();
var query = from ip in entities.IP
join domain in entities.Domain on ip.Host.FirstOrDefault() equals domain.Host.FirstOrDefault()
where ip.Address == "74.125.87.99"
select domain;
|
|
|
var query = from domain in this.bll.entities.Domain
join d2h in this.bll.entities.Domain2Host
on domain.ID equals d2h.FK_DomainID
join h2i in this.bll.entities.Host2IP
on d2h.FK_HostID equals h2i.FK_HostID
join ip in this.bll.entities.IP
on h2i.FK_IPID equals ip.ID
where ip.Address == IPAddress
select domain;
|
|
|
Du kannst deinen ursprünglichen Join auch ohne abbilden. Im SQL benutzt dus ja auch nicht.