title: The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid
body: <p>I have two projects in a solution.</p>
  
  <ol>
  <li>PizzaSoftware.Data</li>
  <li>PizzaSoftware.UI</li>
  </ol>
  
  <p>In the Data project, I have my Entity Framework model which connects to my database.</p>
  
  <p>My UI project has a project reference to Data and here's how it looks like:</p>
  
  <p><img src="https://i.stack.imgur.com/vWRAS.jpg" alt="enter image description here"></p>
  
  <p>I've created a user control in the UserControls folder.</p>
  
  <pre><code>using System;
  using System.Collections.Generic;
  using System.ComponentModel;
  using System.Drawing;
  using System.Data;
  using System.Linq;
  using System.Text;
  using System.Windows.Forms;
  using PizzaSoftware.Data;
  
  namespace PizzaSoftware.UI.UserControls
  {
      public partial class AutoCompleteTextBox : UserControl
      {
          AutoCompleteStringCollection completeCollection = new AutoCompleteStringCollection();
  
          public AutoCompleteTextBox()
          {
              InitializeComponent();
          }
  
          private void AutoCompleteTextBox_Load(object sender, EventArgs e)
          {
              CustomerRepository repo = new CustomerRepository();
              var customers = repo.FindAllCustomers().ToList();
  
              foreach (var customer in customers)
              {
                  completeCollection.Add(customer.Name);
              }
  
              txtSearchBox.AutoCompleteMode = AutoCompleteMode.Suggest;
              txtSearchBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
              txtSearchBox.AutoCompleteCustomSource = completeCollection;
          }
      }
  }
  </code></pre>
  
  <p>When I try to drag this user control into the design pane, I receive the error in the question title.</p>
  
  <p>Here's what my connection string looks like:</p>
  
  <pre><code>&lt;connectionStrings&gt;
     &lt;add 
        name="SaharaPizzaEntities"
        connectionString="
           metadata=res://*/PizzaSoftwareEntityModel.csdl|res://*/PizzaSoftwareEntityModel.ssdl|res://*/PizzaSoftwareEntityModel.msl;
           provider=System.Data.SqlClient;
           provider connection string=&amp;quot;
              Data Source=.\SQLEXPRESS;
              Initial Catalog=SaharaPizza;
              Integrated Security=True;
              MultipleActiveResultSets=True
           &amp;quot;"
        providerName="System.Data.EntityClient"
  /&gt;
  </code></pre>
  
  <p>What could be causing this error?</p>