linq join query problem with city table

Question

0.00/5 (No votes)

See more:

Hi!

I have a problem with linq join query.
I have admin table with foreign key of city table.

When i write following linq query it throw error at databind time.

C#

MyEntityDataContext MyEntity = new MyEntityDataContext();
 return (from a in MyEntity.tblAdmins
         join c in MyEntity.tblCities
         on a.city equals c.cityid
         select new { a, c.cityname }).ToList();

I get this error
=====================
DataBinding: '<>f__AnonymousType0`2[[tblAdmin, App_Code.xexoenga, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null],[System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]' does not contain a property with the name 'id'.

table admin
=================

id	int	not null pk
firstname	varchar(50)	null
lastname	varchar(50)	null
username	varchar(50)	null
password	varchar(50)	null
emailid 	varchar(50)	null
hobbies 	varchar(50)	null
gender  	bit	        null
city           	int	null
isactive	bit	null

tblCities
=========================================

cityid	int	not null pk
cityname	varchar(50)	null

I am getting correct answer when write following query, but in some table i have over 40 column,
so i want to get query like select a.*,b.cityname etc in linq

C#

return (from a in MyEntity.tblAdmins
                join c in MyEntity.tblCities
                on a.city equals c.cityid
                select new { a.firstname,a.lastname, c.cityname }).ToList();

Posted 9-Sep-12 19:26pm

ravi sharma11

Updated 9-Sep-12 21:04pm

Mohamed Mitwalli

v4

Add a Solution

Comments

sanwar_mal_jat 10-Sep-12 2:27am

tell me what u bind in your databind control

CodeHawkz 10-Sep-12 2:30am

It is nearly impossible for people to answer you without seeing the table or the class structure of the 'tblAdmins' and 'tblCities', don't you think? Most probably, you would have got an answer by now, if you did :)

Menon Santosh 10-Sep-12 2:34am

post your table structure

Mohamed Mitwalli 10-Sep-12 3:07am

Hi ,
Make sure you update your DBML file

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Amy · Answer 1 · 2012-09-09T21:31:00

Here you go with this query:

C#

var query = from TableA in MyEntity.tblAdmins
            join TableB in MyEntity.tblCities on TableA.city 
            equals TableB.cityid into tblTemp
            from sub in tblTemp.DefaultIfEmpty()
            select new { MyRow = TableA, sub.cityname  };

All the best.
--Amit

Manikanthchitturi · Answer 2 · 2012-09-09T21:39:00

Every thing is ok with this but select id also then error will be gone

MyEntityDataContext MyEntity = new MyEntityDataContext();
return (from a in MyEntity.tblAdmins
join c in MyEntity.tblCities
on a.city equals c.cityid
select new { a.id, c.cityname }).ToList()

linq join query problem with city table

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0