Binding data to multiple dropdowns using entity framework in one database connection
<p>Lets say we have a stored procedure with 10 <code>select</code> statements to bind data to 10 drop downs in a form:</p>

<pre><code>CREATE PROC GetMasterData
AS
BEGIN

  SELECT ID,Value FROM Table1
  SELECT ID,Value FROM Table2
  SELECT ID,Value FROM Table3
  SELECT ID,Value FROM Table4.../* other select statements */      

END
</code></pre>

<p>To write the same <code>SQL</code> statements using <code>LINQ</code> using <code>EntityFramework</code>, the database will be connected 10 times like:</p>

<pre><code>var t1Data = from t1 in context.Table1 select t1;
var t2Data = from t2 in context.Table2 select t2;
var t3Data = from t3 in context.Table3 select t3;
var t4Data = from t4 in context.Table4 select t4;
etc....
</code></pre>

<p>Can we combine the above <code>LINQ</code> statements or just execute the <code>LINQ</code> statements in a way that we get all the data in one connection?</p>

<p><strong>EDIT:</strong></p>

<p>I am aware that this can be done by calling the stored procedure through EF and binding the results to the relevant class objects and passing them to the <code>view</code> but I really want to know if this can be done without calling the stored procedure i.e., through LINQ statements without multiple calls to database.</p>