Click here to Skip to main content
       

LINQ

 
AnswerRe: LINQ: Order by specific values (ID) first and Rest will follow [modified] PinmemberJacek Gajek4-Jun-13 22:59 
Questioninclude nested object's property? Pinmembermp4mcd1-May-13 17:51 
AnswerRe: include nested object's property? PinmemberMidwestLimey2-May-13 9:43 
GeneralRe: include nested object's property? Pinmemberjohnnys appleseed3-May-13 3:22 
AnswerRe: include nested object's property? Pinmemberewohlman4-Sep-13 4:39 
GeneralRe: include nested object's property? [modified] PinmemberGabriel Szabo29-Nov-13 0:58 
QuestionLinQ: sub items and root in DataTable Pinmembernmc_aptech24-Apr-13 23:23 
AnswerRe: LinQ: sub items and root in DataTable PinprofessionalSimon_Whale24-Apr-13 23:36 
GeneralRe: LinQ: sub items and root in DataTable Pinmembernmc_aptech25-Apr-13 17:04 
QuestionLINQ Query / "between" dates Pinmembermebjen18-Nov-12 7:17 
AnswerRe: LINQ Query / "between" dates PinmemberMatt T Heffron18-Nov-12 12:52 
QuestionComma separeted text file Pinmembermarca29212-Nov-12 19:59 
AnswerRe: Comma separeted text file Pinmembersavbace10-Jan-13 22:44 
QuestionThe type of one of the expressions in the join clause is incorrect. Type inference failed in the call to GroupJoin Pinmemberdotnet9516-Oct-12 14: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 PinmemberRichard Deeming22-Oct-12 2:19 
QuestionLINQ PinmemberJabbarJahambana3-Oct-12 22:04 
AnswerRe: LINQ PinprotectorPete O'Hanlon3-Oct-12 22:22 
AnswerRe: LINQ PinmemberProgramFOX5-Oct-12 5:33 
AnswerRe: LINQ Pinmemberemma926-Dec-12 6:23 
AnswerRe: LINQ Pinmembertunheo24-Dec-12 22:17 
GeneralMessage Automatically Removed PinmemberMahesh Sellamuthu12-Feb-13 20:09 
Suggestionlinq to sql obtain foreign key value Pinmembersc steinhayse24-Aug-12 19:40 
GeneralRe: linq to sql obtain foreign key value Pinmemberrs_engg5-Sep-12 3:43 
Questionminus returned value during executing a insert stored procedure PinmemberMember 870070423-Aug-12 5:37 
AnswerRe: minus returned value during executing a insert stored procedure PinmemberWes Aday23-Aug-12 6:00 
AnswerRe: minus returned value during executing a insert stored procedure PinmemberBobJanova23-Aug-12 6:14 
QuestionLINQ or ADO.NET ? Pinmemberpashmakjoon19-Aug-12 10:11 
AnswerRe: LINQ or ADO.NET ? PinmvpRichard MacCutchan19-Aug-12 23:03 
AnswerRe: LINQ or ADO.NET ? Pinmvpthatraja20-Aug-12 0:39 
GeneralRe: LINQ or ADO.NET ? Pinmembermanijasmine20-Aug-12 8:07 
AnswerRe: LINQ or ADO.NET ? PinmemberKolkata .NET8-Mar-13 5:45 
Questionhow to load and save an xml document using linq Pinmemberowobs15-Aug-12 1:57 
AnswerRe: how to load and save an xml document using linq PinmentorWayne Gaylard15-Aug-12 2:16 
QuestionCreating a dynamic where clause PinmemberSimon_Whale9-Aug-12 0:06 
AnswerRe: Creating a dynamic where clause PinprotectorPete O'Hanlon9-Aug-12 0:22 
GeneralRe: Creating a dynamic where clause PinmemberSimon_Whale9-Aug-12 0:26 
GeneralRe: Creating a dynamic where clause PinmemberBobJanova9-Aug-12 2:11 
GeneralRe: Creating a dynamic where clause PinmemberSimon_Whale9-Aug-12 3:10 
GeneralRe: Creating a dynamic where clause PinprotectorPete O'Hanlon9-Aug-12 3:40 
GeneralRe: Creating a dynamic where clause PinmemberSimon_Whale9-Aug-12 3:44 
QuestionLinq where dates question PinmemberMember 78188928-Jul-12 13:23 
AnswerRe: Linq where dates question PinprotectorPete O'Hanlon8-Jul-12 19:51 
AnswerRe: Linq where dates question PinmemberBobJanova9-Jul-12 1:41 
AnswerRe: Linq where dates question PinmemberMatt T Heffron11-Jul-12 8:41 
AnswerRe: Linq where dates question PinmemberMatt T Heffron27-Jul-12 14:35 
Questionlinq to sql connection string name Pinmemberrachel_m6-Jul-12 6:31 
AnswerRe: linq to sql connection string name PinmemberBobJanova9-Jul-12 1:42 
QuestionConvert SQL to LINQ Pinmemberdivesh123-Jul-12 9:47 
QuestionRe: Convert SQL to LINQ PinmemberNaerling12-Jul-12 6:01 
AnswerRe: Convert SQL to LINQ Pinmvpthatraja20-Aug-12 0:32 

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
Web03 | 2.8.140709.1 | Last Updated 27 Jun 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid