Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
65 Points
187 Posts
Feb 29, 2012 04:57 PM|LINK
I tried that too. I got an error saying "Cannot convert type 'string' to 'double' " . Here is the statement i tried
s in Study
join ds in DMIDStudy on SqlFunctions.StringConvert((double)s.SourceStudyID) equals ds.StudyID
Regards,
Vishnu
Setty
Member
65 Points
187 Posts
Re: Comparing integer with string with linqtoEntitites
Feb 29, 2012 04:57 PM|LINK
I tried that too. I got an error saying "Cannot convert type 'string' to 'double' " . Here is the statement i tried
s in Study
join ds in DMIDStudy on SqlFunctions.StringConvert((double) s.SourceStudyID) equals ds.StudyID
Regards,
Vishnu