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
select c;
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.
dm34175
Member
1 Points
3 Posts
The type of one of the expressions in the join clause is incorrect. Type inference failed in the...
Nov 10, 2010 07:03 PM|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
select c;
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?
macpak
Member
408 Points
132 Posts
Re: The type of one of the expressions in the join clause is incorrect. Type inference failed in...
Nov 10, 2010 08:49 PM|LINK
What are the types of c.char_job and o.job_title ?
Wencui Qian ...
All-Star
56784 Points
5796 Posts
Microsoft
Re: The type of one of the expressions in the join clause is incorrect. Type inference failed in...
Nov 16, 2010 06:46 AM|LINK
Do they have the same length in database? Please check it first. Thanks.
If you have any feedback about my replies, please contact msdnmg@microsoft.com
Microsoft One Code Framework