Click here to Skip to main content
11,416,572 members (69,437 online)
   

LINQ

 
AnswerRe: LinQ: sub items and root in DataTable Pin
Simon_Whale25-Apr-13 0:36
professionalSimon_Whale25-Apr-13 0:36 
GeneralRe: LinQ: sub items and root in DataTable Pin
nmc_aptech25-Apr-13 18:04
membernmc_aptech25-Apr-13 18:04 
AnswerRe: LinQ: sub items and root in DataTable Pin
Member 1153153721-Mar-15 22:47
memberMember 1153153721-Mar-15 22:47 
QuestionLINQ Query / "between" dates Pin
mebjen18-Nov-12 8:17
membermebjen18-Nov-12 8:17 
AnswerRe: LINQ Query / "between" dates Pin
Matt T Heffron18-Nov-12 13:52
memberMatt T Heffron18-Nov-12 13:52 
QuestionComma separeted text file Pin
marca29212-Nov-12 20:59
membermarca29212-Nov-12 20:59 
AnswerRe: Comma separeted text file Pin
savbace10-Jan-13 23:44
membersavbace10-Jan-13 23:44 
QuestionThe type of one of the expressions in the join clause is incorrect. Type inference failed in the call to GroupJoin Pin
dotnet9516-Oct-12 15:28
memberdotnet9516-Oct-12 15:28 
select a.LoanNum, PromiseAmt, isnull(SUM(PdAmt), 0) as PostedAmt
 from LoanPromises a with(nolock)
 left outer join LoanPayment lp with(nolock) on a.LoanNum = lp.LoanNum and a.PromiseDt < lp.PmtPostDt
 group by a.LoanNum, PromiseAmt
 having isnull(Sum(PdAmt),0) < PromiseAmt
 
Here is my linq query
 
var query = from pmts in oLoan.LoanPayments
     join promise in oLoan.LoanPromiseToPays
    on new { p1 = pmts.LoanNum, p2 = pmts.PmtPostDt} equals new {LoanNum = promise.LoanNum, PmtPostDt = promise.PromiseDt } into outer
 from defaulted in outer.DefaultIfEmpty()
 group defaulted by promise.LoanNum && promise.PromiseAmt into grouped
 select new
 {
    LoanNum = grouped.Key,
    Sum = grouped.Sum(t => t.PdAmt < t.PromiseAmt),
    PmtPostDt = promise.PromiseDt ?? default(DateTime)
 }
 

AnswerRe: The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to GroupJoin Pin
Richard Deeming22-Oct-12 3:19
memberRichard Deeming22-Oct-12 3:19 
QuestionLINQ Pin
JabbarJahambana3-Oct-12 23:04
memberJabbarJahambana3-Oct-12 23:04 
AnswerRe: LINQ Pin
Pete O'Hanlon3-Oct-12 23:22
protectorPete O'Hanlon3-Oct-12 23:22 
AnswerRe: LINQ Pin
ProgramFOX5-Oct-12 6:33
memberProgramFOX5-Oct-12 6:33 
AnswerRe: LINQ Pin
emma926-Dec-12 7:23
memberemma926-Dec-12 7:23 
AnswerRe: LINQ Pin
tunheo24-Dec-12 23:17
membertunheo24-Dec-12 23:17 
GeneralMessage Automatically Removed Pin
12-Feb-13 21:09
memberMahesh Sellamuthu12-Feb-13 21:09 
Suggestionlinq to sql obtain foreign key value Pin
sc steinhayse24-Aug-12 20:40
membersc steinhayse24-Aug-12 20:40 
GeneralRe: linq to sql obtain foreign key value Pin
rs_engg5-Sep-12 4:43
memberrs_engg5-Sep-12 4:43 
Questionminus returned value during executing a insert stored procedure Pin
Member 870070423-Aug-12 6:37
memberMember 870070423-Aug-12 6:37 
AnswerRe: minus returned value during executing a insert stored procedure Pin
Wes Aday23-Aug-12 7:00
memberWes Aday23-Aug-12 7:00 
AnswerRe: minus returned value during executing a insert stored procedure Pin
BobJanova23-Aug-12 7:14
memberBobJanova23-Aug-12 7:14 
QuestionLINQ or ADO.NET ? Pin
pashmakjoon19-Aug-12 11:11
memberpashmakjoon19-Aug-12 11:11 
AnswerRe: LINQ or ADO.NET ? Pin
Richard MacCutchan20-Aug-12 0:03
mvpRichard MacCutchan20-Aug-12 0:03 
AnswerRe: LINQ or ADO.NET ? Pin
thatraja20-Aug-12 1:39
mvpthatraja20-Aug-12 1:39 
GeneralRe: LINQ or ADO.NET ? Pin
manijasmine20-Aug-12 9:07
membermanijasmine20-Aug-12 9:07 
AnswerRe: LINQ or ADO.NET ? Pin
Kolkata .NET8-Mar-13 6:45
memberKolkata .NET8-Mar-13 6:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web01 | 2.8.150427.4 | Last Updated 22 Mar 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid