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.
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
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();