title: Entity Framework opens new connection for each request
body: <p>When I make multiple requests to SQL using single context, EF opens new connection for each request. For example, this code grabbing several lists from database:</p>
  <pre><code>using(MyContext nctx = new MyContext())
  {
      var dictAllSelects = new Dictionary&lt;string, SelectList&gt;(){
          {&quot;sl_task_id&quot;, new SelectList(nctx.Tasks.ToArray(), &quot;id&quot;, &quot;name&quot;)},
          {&quot;sl_task_item_id&quot;, new SelectList(nctx.TaskItems.ToArray(), &quot;id&quot;, &quot;name&quot;)},
          {&quot;sl_unit_id&quot;, new SelectList(nctx.Units.ToArray(), &quot;id&quot;, &quot;name&quot;)},
          {&quot;sl_unit_type_id&quot;, new SelectList(nctx.UnitTypes.ToArray(), &quot;id&quot;, &quot;name&quot;)}
      };
  }
  </code></pre>
  <p>EF creates a new connection to the database for this queries apiece, that is four times in this case:</p>
  <blockquote>
  <p>27.09.2014 16:27:54 [SQL]: Opened connection at 27.09.2014 16:27:54 +04:00</p>
  <p>27.09.2014 16:27:54 [SQL]: SELECT [Extent1].[id] AS [id], [Extent1].[name] AS [name],  [Extent1].[task_id] AS [task_id] FROM [dbo].[TaskItems] AS [Extent1]</p>
  <p>27.09.2014 16:27:54 [SQL]: -- Executing at 27.09.2014 16:27:54 +04:00</p>
  <p>27.09.2014 16:27:54 [SQL]: -- Completed in 0 ms with result: SqlDataReader</p>
  <p>27.09.2014 16:27:54 [SQL]: Closed connection at 27.09.2014 16:27:54 +04:00</p>
  <p>27.09.2014 16:27:54 [SQL]: Opened connection at 27.09.2014 16:27:54 +04:00</p>
  <p>27.09.2014 16:27:54 [SQL]: SELECT [Extent1].[id] AS [id], [Extent1].[name] AS [name], [Extent1].[city] AS [city], [Extent1].[unit_type_id] AS [unit_type_id] FROM [dbo].[Units] AS [Extent1]</p>
  <p>27.09.2014 16:27:54 [SQL]: -- Executing at 27.09.2014 16:27:54 +04:00</p>
  <p>27.09.2014 16:27:54 [SQL]: -- Completed in 0 ms with result: SqlDataReader</p>
  <p>27.09.2014 16:27:54 [SQL]:  Closed connection at 27.09.2014 16:27:54 +04:00</p>
  <p>etc...</p>
  </blockquote>
  <p>Is there any way to control EF dbcontext connections and/or force it open single connection until disposed or until is told to close it?</p>