title: open DataReader error on Azure SQL but not SQL Server 2014
body: <p>I have found a few posts on this but can't seem to find one that relates to my code.</p>
  
  <p>The following line is highlighted with the error:</p>
  
  <pre><code>Line 74:         &lt;td&gt;
  Line 75:             @Html.DisplayFor(modelItem =&gt; item.Equipment.ModelName)
  Line 76:         &lt;/td&gt;
  </code></pre>
  
  <p>The part of the view rendering the data looks like this:</p>
  
  <pre><code>@foreach (var item in Model) {
      &lt;tr&gt;
          &lt;td&gt;
              @Html.DisplayFor(modelItem =&gt; item.Location)
          &lt;/td&gt;
          &lt;td&gt;
              @Html.DisplayFor(modelItem =&gt; item.Position)
          &lt;/td&gt;
          &lt;td&gt;
              @Html.DisplayFor(modelItem =&gt; item.Description)
          &lt;/td&gt;
          &lt;td&gt;
              @Html.DisplayFor(modelItem =&gt; item.SerialNo)
          &lt;/td&gt;
          &lt;td&gt;
              @Html.DisplayFor(modelItem =&gt; item.InstallDate)
          &lt;/td&gt;
          &lt;td&gt;
              @Html.DisplayFor(modelItem =&gt; item.ServiceFrequency) Months
          &lt;/td&gt;
          &lt;td&gt;
              @Html.DisplayFor(modelItem =&gt; item.NextServiceDate)
          &lt;/td&gt;
          &lt;td&gt;
              @Html.DisplayFor(modelItem =&gt; item.Equipment.ModelName)
          &lt;/td&gt;
          &lt;td&gt;
              @Html.DisplayFor(modelItem =&gt; item.Owner.OwnerName)
          &lt;/td&gt;
          &lt;td&gt;
              @Html.DisplayFor(modelItem =&gt; item.ServiceCompany.CompanyName)
          &lt;/td&gt;
          &lt;td&gt;
              @Html.DisplayFor(modelItem =&gt; item.Site.SiteName)
          &lt;/td&gt;
  
          &lt;td&gt;
              @Html.ActionLink("Edit", "Edit", new { id=item.AssetID })
              @Html.ActionLink("Details", "Details", new { id=item.AssetID })
              @Html.ActionLink("Delete", "Delete", new { id=item.AssetID })
          &lt;/td&gt;
      &lt;/tr&gt;
  </code></pre>
  
  <p>The controller look like this:</p>
  
  <pre><code>public ActionResult Index()
  {
      var userId = User.Identity.GetUserId();
      var asset = from a in db.Assets
                  join o in db.Owners on a.OwnerID equals o.OwnerID into oa
                  from asst in oa.DefaultIfEmpty()
                  join s in db.ServiceCompanies on a.ServiceCompanyID equals s.ServiceCompanyID into sa
                  from service in sa.DefaultIfEmpty()
                  where asst.RegUserID == userId || service.RegUserID == userId
                  select a;
  
      return View(asset);
  }
  </code></pre>
  
  <p>My understanding I have tried to connect to the database twice however I can't see where and also I don't get this error on my laptop. I feeling is it may be something that's not available in Azure SQL Databases that is fine in SQL Server 2014.</p>
  
  <p>Any thoughts? </p>
  
  <p>UPDATE::::</p>
  
  <p>I have stopped the issue by adding MultipleActiveResultSets=true to the connection string however I am not sure if this is masking an issue that needs to be resolved or maybe introducing other issues. </p>