.NET Framework connection string needed for SQL 2008R2

Hi,

I am trying to create an Entity Data Model project in Visual Studio 2010 that uses a .mdf file as it's database and am experiencing some difficulty.

On this particular computer MS SQL Server 2008 R2 Developer's Edition was installed first. When VS2010 was installed it was installed without the SQL Express portion because 2008 R2 was already on the machine. On this computer in VS2010, in Tools --> Options --> Database Tools --> Data Connections --> SQL Server Instance Name (blank for default), the box is blank. The behavior it's exhibiting is the combo boxes don't display the database field contents it's coded in the form to display.

In the App.Config file this is what the connection string says:
connectionString="metadata=res:///Model1.csdl|res:///Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\2742ex2hSchool.mdf;Integrated Security=True;MultipleActiveResultSets=True""

Does anyone know what needs to be changed to get the data to appear in the combo boxes?

Thanks in advance,
knot22

0 answers