Click here to Skip to main content
11,435,106 members (48,827 online)
   

LINQ

 
AnswerRe: include nested object's property? Pin
MidwestLimey2-May-13 10:43
memberMidwestLimey2-May-13 10:43 
GeneralRe: include nested object's property? Pin
johnnys appleseed3-May-13 4:22
memberjohnnys appleseed3-May-13 4:22 
AnswerRe: include nested object's property? Pin
ewohlman4-Sep-13 5:39
memberewohlman4-Sep-13 5:39 
GeneralRe: include nested object's property? [modified] Pin
Gabriel Szabo29-Nov-13 1:58
memberGabriel Szabo29-Nov-13 1:58 
QuestionLinQ: sub items and root in DataTable Pin
nmc_aptech25-Apr-13 0:23
membernmc_aptech25-Apr-13 0:23 
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 
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 
Try taking out the p1 = and p2 = from the LHS of your join.

At the moment, you have:
on new { p1 = ..., p2 = ...} equals new { LoanNum = ..., PmtPostDt = ... }
The compiler has no way to map one key to the other, since the property names are different.

Also, your LINQ join won't match your SQL join. The SQL has promise.PromiseDate < payment.PmtPostDt, but your LINQ query has promise.PromiseDate = payment.PmtPostDt instead.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


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 
Questionhow to load and save an xml document using linq Pin
owobs15-Aug-12 2:57
memberowobs15-Aug-12 2:57 
AnswerRe: how to load and save an xml document using linq Pin
Wayne Gaylard15-Aug-12 3:16
mentorWayne Gaylard15-Aug-12 3:16 
QuestionCreating a dynamic where clause Pin
Simon_Whale9-Aug-12 1:06
memberSimon_Whale9-Aug-12 1:06 
AnswerRe: Creating a dynamic where clause Pin
Pete O'Hanlon9-Aug-12 1:22
protectorPete O'Hanlon9-Aug-12 1:22 
GeneralRe: Creating a dynamic where clause Pin
Simon_Whale9-Aug-12 1:26
memberSimon_Whale9-Aug-12 1:26 
GeneralRe: Creating a dynamic where clause Pin
BobJanova9-Aug-12 3:11
memberBobJanova9-Aug-12 3:11 
GeneralRe: Creating a dynamic where clause Pin
Simon_Whale9-Aug-12 4:10
memberSimon_Whale9-Aug-12 4:10 
GeneralRe: Creating a dynamic where clause Pin
Pete O'Hanlon9-Aug-12 4:40
protectorPete O'Hanlon9-Aug-12 4:40 
GeneralRe: Creating a dynamic where clause Pin
Simon_Whale9-Aug-12 4:44
memberSimon_Whale9-Aug-12 4:44 
QuestionLinq where dates question Pin
Member 78188928-Jul-12 14:23
memberMember 78188928-Jul-12 14:23 
AnswerRe: Linq where dates question Pin
Pete O'Hanlon8-Jul-12 20:51
protectorPete O'Hanlon8-Jul-12 20:51 
AnswerRe: Linq where dates question Pin
BobJanova9-Jul-12 2:41
memberBobJanova9-Jul-12 2:41 
AnswerRe: Linq where dates question Pin
Matt T Heffron11-Jul-12 9:41
memberMatt T Heffron11-Jul-12 9:41 
AnswerRe: Linq where dates question Pin
Matt T Heffron27-Jul-12 15:35
memberMatt T Heffron27-Jul-12 15:35 
Questionlinq to sql connection string name Pin
rachel_m6-Jul-12 7:31
memberrachel_m6-Jul-12 7:31 
AnswerRe: linq to sql connection string name Pin
BobJanova9-Jul-12 2:42
memberBobJanova9-Jul-12 2:42 
QuestionConvert SQL to LINQ Pin
divesh123-Jul-12 10:47
memberdivesh123-Jul-12 10:47 
QuestionRe: Convert SQL to LINQ Pin
Naerling12-Jul-12 7:01
memberNaerling12-Jul-12 7:01 
AnswerRe: Convert SQL to LINQ Pin
thatraja20-Aug-12 1:32
mvpthatraja20-Aug-12 1:32 
AnswerRe: Convert SQL to LINQ Pin
Emmanuel Medina Lopez18-Sep-12 9:40
memberEmmanuel Medina Lopez18-Sep-12 9:40 

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.150428.2 | Last Updated 22 Mar 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid