Untitled

The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid

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;

        }

    }

}

       

<?xml version="1.0" encoding="utf-8"?>

<configuration>

  <connectionStrings>

    <add name="SaharaPizzaEntities" connectionString="metadata=res://*/PizzaSoftwareEntityModel.csdl|res://*/PizzaSoftwareEntityModel.ssdl|res://*/PizzaSoftwareEntityModel.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.SQLEXPRESS;Initial Catalog=SaharaPizza;Integrated Security=True;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" />

  </connectionStrings>

</configuration>

       

connection string="Data Source=.SQLEXPRESS;Initial Catalog=SaharaPizza;Integrated Security=True;MultipleActiveResultSets=True"

       

public EntityModelContainer() : base("name=EntityModelContainer",

    "EntityModelContainer")

       

public EntityModelContainer(string connectionString) : base(connectionString,

    "EntityModelContainer")