title: How to use INCLUDE in Linq for selected columns only?
body: <p>I am having the scenario with multiple linq include methods with table object associations.
  Suppose the scenario is:</p>
  
  <pre><code>User has Groups
  User has Permissions
  User has Vehicles
  
  var _users=
  (from u in dbconetxt.Users
  join g in dbconetxt.Gropus on u.userId equals g.userId
  join p in dbconetxt.Permissions on u.userId equals p.userId
  join v in dbconetxt.Vehicles on u.userId equals v.userId
  Where u.Status=true
  select u).Include(u.Groups)
           .Include(u.Permissions)
           .Include(u.Vehicles)
           .ToList()
  </code></pre>
  
  <p>After joining all these tables within a single query, I select the User Object. Certainly, I would get List, but I want each User Object should Include its respective Groups, Permissions, Vehicles, but from Vehicles and Permissions, I want to load only few Columns/Properties, not all. So, how do I specify which Columns to load in this scenario?</p>
  
  <p>I am using Entity Framework 4.1 + C# + SQL Server.</p>