Jel moze neko da mi pomogne oko pisanje ovakvog SQL-a u LINQ
Code:
select
s4.serial,
s4.serviceguid,
s4.info0,
s4.info1,
s4.info2,
from services4 s4
left outer join services4connections s4c on s4c.serviceguid = s4.serviceguid and s4c.deleted = 0
select
s4.serial,
s4.serviceguid,
s4.info0,
s4.info1,
s4.info2,
from services4 s4
left outer join services4connections s4c on s4c.serviceguid = s4.serviceguid and s4c.deleted = 0
Ovo sam ja uradio
Code:
services4.GroupJoin(
services4connections,
s => new { s.serviceguid },
cs => new { cs.serviceguid },
(services, sconnection) => new { Services4 = services, Services4connections = sconnection })
.SelectMany(
x => x.Services4connections.DefaultIfEmpty(),
(services, sconnection) => new { computer = services.Services4, folder = sconnection })
services4.GroupJoin(
services4connections,
s => new { s.serviceguid },
cs => new { cs.serviceguid },
(services, sconnection) => new { Services4 = services, Services4connections = sconnection })
.SelectMany(
x => x.Services4connections.DefaultIfEmpty(),
(services, sconnection) => new { computer = services.Services4, folder = sconnection })
i to generise
Code:
SELECT
[Extent1].[serial] AS [serial],
[Extent1].[serviceguid] AS [serviceguid],
[Extent1].[info0] AS [info0],
[Extent1].[info1] AS [info1],
[Extent1].[info2] AS [info2],
FROM [dbo].[services4] AS [Extent1]
LEFT OUTER JOIN [dbo].[services4connections] AS [Extent2] ON [Extent1].[serviceguid] = [Extent2].[serviceguid]
SELECT
[Extent1].[serial] AS [serial],
[Extent1].[serviceguid] AS [serviceguid],
[Extent1].[info0] AS [info0],
[Extent1].[info1] AS [info1],
[Extent1].[info2] AS [info2],
FROM [dbo].[services4] AS [Extent1]
LEFT OUTER JOIN [dbo].[services4connections] AS [Extent2] ON [Extent1].[serviceguid] = [Extent2].[serviceguid]
Znaci ovo na kraju
Citat:
and s4c.deleted = 0
Unapred hvala
To sto nekoliko miliona ljudi tvrdi da nisi u pravu ne znaci da stvarno nisi - Frank Zappa
https://youtu.be/DLe358DPGXU
https://youtu.be/DLe358DPGXU