Click here to Skip to main content
11,415,301 members (85,078 online)
   

LINQ

 
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 

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