CODEWITHSUNDEEP
visual-studio-2010
Darren
Darren

Reputation: 345

VS2010 and local databases

Is it possible to connect to a local database (in the app_data folder) using the Data -> Transact SQL Editor in Visual Studio 2010?

When I launch the Transact SQL Editor from VS2010 I get the "Microsoft SQL Server 2008 RC" connect to server dialog. The options I have for Server type are "Database Engine" and "SQL Server Compact"

Upvotes: 1

Views: 5516

Answers (2)

Sergii Volchkov
Sergii Volchkov

Reputation: 1166

I was able to connect to a local database by using the AttachDbFilename connection string option (as it is done e.g. in Web.config).

In "Connect to Database Engine" dialog, click "Options >>", go to "Additional Connection Parameters" tab and enter something like the following:

Data Source=.\SQLEXPRESS;AttachDbFilename=<your_path_to_app>\App_Data\YourDatabase.mdf;Integrated Security=True;User Instance=true;Initial Catalog=YourDatabase

The only problem with this method is that the options are not saved in the dialog, and the connection string has to be entered with every connection.

Upvotes: 1

S P
S P

Reputation: 4643

What you can do is:

  • CTRL + ALT + S (show up Server Explorer)

  • Add Connection.

  • Click "Change" right from Data Source and select Microsoft SQL Server Data File

Now youshould be able to select any SQL Server file now for your connection.

  • Click on Data -> Transact SQL Editor > New Connection. SQL Server Connection Dialog will appear.
  • In the list, choose SQL Server Compact and browse for SDF-file.
  • Click Connect and you should be connected now.

Upvotes: 0

Related Questions