Getting values from ObjectConext

See more:

C#

ASP.NET

LINQ

lambda

, +

I m using EntityFramework to get the data from the DB.

consider I have a table

Buyer
{
   guid id,
   datetime date,
   guid userid references user(id)
}

user
{
  guid id,
  string name
}

consider the above class as table in DB.
I want to return user name in buyer list. The usual way is buyer.User.name.
but for this we need to use Include in objectcontext. But I want with out using the Include (because it makes the query to add a outer join. In my case this outer class adds me more cost)

I am actually trying to add username as a parameter in Buyer class and access the value.
How can i do this..

more like

this.objectcontext.Buyer.select(x=>new  Buyer(){x.username=x.Users.name}).ToList();

But here my other parameters (like date,id) has to be assigned itself.