Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- ai.crArtNrLeverancier,
- pli.crartnr
- FROM [tblArtikelImport] ai
- LEFT JOIN tblPLInkoop pli on pli.crArtNr = ai.crArtNrLeverancier
- WHERE pli.crartnr is not null
- var data = await _context.TblArtikelImport.GroupJoin(_context.TblPlinkoop,
- ai => ai.CrArtNrLeverancier,
- pli => pli.CrArtNr,
- (ai, pli) => new { ArtikelImport = ai, PLInkoop = pli })
- .Where(c => c.PLInkoop.Any(cc => cc.CrArtNr != null)).ToListAsync();
- InvalidOperationException: Error generated for warning 'Microsoft.EntityFrameworkCore.Query.QueryClientEvaluationWarning: The LINQ expression 'where ([cc].CrArtNr != null)' could not be translated and will be evaluated locally.'.
- var data2 = await _context.TblArtikelImport.GroupJoin(_context.TblPlinkoop,
- ai => ai.CrArtNrLeverancier,
- pli => pli.CrArtNr,
- (ai, pli) => new { ArtikelImport = ai, PLInkoop = pli })
- .ToListAsync();
- SELECT
- ai.crArtNrLeverancier,
- pli.crartnr
- FROM [tblArtikelImport] ai
- LEFT JOIN tblPLInkoop pli on pli.crArtNr = ai.crArtNrLeverancier
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement