title: Linq query returning Less records than Sql Query
body: <p>I am facing a big problem with simple linq query.. I am using EF 4.0..
  I am trying to take all the records from a table using a linq query:</p>
  
  <pre><code>var result = context.tablename.select(x=&gt;x);
  </code></pre>
  
  <p>This results in less rows than the normal sql query which is <code>select * from tablename</code>;</p>
  
  <p>This table has more than 5 tables as child objects (foreign key relations: one to one and one to many etc)..</p>
  
  <p>This result variable after executing that linq statement returns records with all child object values without doing a include statement..</p>
  
  <p>I don't know is it a default behavior of EF 4.0 ..</p>
  
  <p>I tried this statement in linqpad also..but there is no use...</p>
  
  <p>But interesting thing is if I do a join on the same table with another one table is working same is sql inner join and count is same..but I don't know why is it acting differently with that table only.. </p>
  
  <p>Is it doing inner joins with all child tables before returning the all records of that parent table??</p>
  
  <p>please help me..</p>