Last post Nov 16, 2010 06:46 AM by Wencui Qian - MSFT
Nov 10, 2010 07:03 PM|dm34175|LINK
As I said I am little new with ASP.net...so I am sure my mistake is probably painfully simple and obvious but...
So here is my code:
return from c in db.TBLcharacters
join o in db.TBLjobs on c.char_job equals o.job_title
orderby c.char_lastname descending
The goal is to print out the job title from the seperate table when I list the names of the Employees. So in the final formatting on the view it would be John Doe [Janitor] (or something similiar)
But when I make the build I get the following error:
The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to 'Join'.
What I find wierd is cjar_job and job_title are both varchars so the type is the same. So I'm a little confused with that.
Anyone have any ideas?
Nov 10, 2010 08:49 PM|macpak|LINK
What are the types of c.char_job and o.job_title ?
Nov 16, 2010 06:46 AM|Wencui Qian - MSFT|LINK
Do they have the same length in database? Please check it first. Thanks.