judithSampathwa -2 Posting Pro in Training

i have a employee class and a userlogin class in the mdf file. there is an foreign key between the employee and the userlogin tables. the EID in the Employee class is in the uesrlogin class which is a foreign key in the userlogin.

but when i try to access the EID in the userlogin class it dosen't have that option....

i wrote the query below,
this is not working

var a = from b in po.Employees
                where b.UserLogins.[B]EID[/B](here the EID dosn't show up)
                select b;

please can some one help this out


but this is working

var a = from b in po.Employees
                where b.EID == 1
                select b;

thanxxxxxxxxxxxxxx

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.