How to join table

Question

How to join 2 tables with entity framework and then retrieve one data from column among joined table and bind to textbox.   Can anybody help me in this problem.   Thanks a lot :-)

Sibeesh Venu · Answer

Hi,
You mean you need to return only one field from the query? If yes you can select only one (Which field you need to bind to text box) from the query as follows.
select new { UID.Yourfield }

Asp.Net Hein · Answer

Cannot do like this.I want to bind to text box and the data will be unique one

Sibeesh Venu · Answer

Hi,
You can do something like this,
var entryPoint = ( from ep in dbContext . tbl_EntryPoint join e in dbContext . tbl_Entry on ep . EID equals e . EID join t in dbContext . tbl_Title on e . TID equals t . TID where e . OwnerID == user . UID select new { UID = e . OwnerID , TID = e . TID , Title = t . Title , EID = e . EID }). Take ( 10 );
See here for more info:  http://stackoverflow.com/questions/21051612/entity-framwork-join-3-tables
Please accept as answer if it helps you. Kindest Regards Sibeesh Venu www.sibeeshpassion.com