title: Executing custom sql including complex select joins using entity framework 4
body: <p>My application currently uses ado.net to access the database.</p>
  
  <p>It allows users to configure dashboards by passing custom sql. The custom sql includes joins on multiple tables and the columns of every table are included in the result.</p>
  
  <p>We are migrating from ado.net to entity framework 4. </p>
  
  <p>How do I execute the same queries using entity framework?</p>
  
  <p>Also other code in the application requires firing custom complex join queries on the database. This is done by developers.</p>