Tauseef Khan

Tauseef Khan

  • NA
  • 13
  • 15.3k

linq issue

Nov 17 2009 8:59 AM
hi guys
i have two tables tablea(PK) and tableb(FK)

now i just want to load only data from tablea not from tableb
but when i do

var qry = from result in con.tablea
select result;

return qry.tolist()

but it gives me also the data from tableb , althoug when i see
the sql query from con.log i just see it getting data from table a , why is that?
if the query is pointing to just tablea so why there are records from tableb?

thanks.

Answers (7)