SQL query to LINQ

[ pl4stik @ 29.05.2020. 00:38 ] @

Pozdrav

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

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 })

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]

Znaci ovo na kraju

Citat:

and s4c.deleted = 0

nikako ne mogu da napravim evo drugi ceo dan pa molim za pomoc ako neko zna..

Unapred hvala

[ pl4stik @ 29.05.2020. 08:28 ] @

Reseno :)

Code:

            services4.GroupJoin(
                services4connections.Where(z => z.deleted == false),
                s => new { s.serviceguid },
                cs => new { cs.serviceguid },
                (services, sconnection) => new { Services4 = services, Services4connections = sconnection })
                .SelectMany(x => x.Services4connections.DefaultIfEmpty(),
                (services, sconnectio) => new { computer = services.Services4, folder = sconnectio })

_{[Ovu poruku je menjao pl4stik dana 29.05.2020. u 11:13 GMT+1]}