How to get the connection String from a database

by

The easiest way to get the connection string is using the “Server Explorer” window in Visual Studio (menu View, Server Explorer) and connect to the server from that window.

Then you can see the connection string in the properties of the connected server (choose the connection and press F4 or Alt+Enter or choose Properties on the right click menu).

Advanced connection string settings: when creating the connection, you can modify any of the advanced connection string options, like MARS, resiliency, timeot, pooling configuration, etc. by clicking on the “Advanced…” button on the bottom of the “Add connection” dialog. You can access this dialog later by right clicking the Data Connection, and choosing “Modify connection…”. The available advanced options vary by server type.

If you create the database using SQL Server Management Studio, the database will be created in a server instance, so that, to deploy your application you’ll have to make a backup of the database and deploy it in the deployment SQL Server. Alternatively, you can use a data file using SQL Server Express (localDB in SQL Server 2012), that will be easily distributed with your app.

I.e. if it’s an ASP.NET app, there’s an App_Datafolder. If you right click it you can add a new element, which can be a SQL Server Database. This file will be on that folder, will work with SQL Express, and will be easy to deploy. You need SQL Express / localDB installed on your machine for this to work.

More Related Contents:

  1. Visual Studio: ContextSwitchDeadlock
  2. How to use C# 7 with Visual Studio 2015?
  3. Using StringWriter for XML Serialization
  4. Configuration System Failed to Initialize
  5. What is the purpose of the vshost.exe file?
  6. How can I fix the Microsoft Visual Studio error: “package did not load correctly”?
  7. How to add a .dll reference to a project in Visual Studio
  8. How to trigger event when a variable’s value is changed?
  9. how to run visual studio without plugin and all third party feature
  10. Why does ReSharper want to use ‘var’ for everything? [duplicate]
  11. How to downgrade from Visual Studio 2012 project to Visual Studio 2008
  12. What is the best practice for “Copy Local” and with project references?
  13. Using msbuild to execute a File System Publish Profile
  14. Code to validate SQL Scripts
  15. Parsing JSON data with C#
  16. Creating a database programmatically in SQL Server
  17. How can I call a SQL Stored Procedure using EntityFramework 7 and Asp.Net 5
  18. How to save DLLs in a different folder when compiling in Visual Studio?
  19. Optimistic concurrency: IsConcurrencyToken and RowVersion
  20. ALTER TABLE DROP COLUMN failed because one or more objects access this column
  21. c# Visual Studio …adding references programmatically
  22. Can the Visual Studio Debugger display strings unquoted/unescaped?
  23. How can I dynamically switch web service addresses in .NET without a recompile?
  24. Uniquely Identifying Reference Types in the Debugger
  25. Cannot find JavaScriptSerializer in .Net 4.0
  26. How to pass a null variable to a SQL Stored Procedure from C#.net code
  27. Go To Definition: “Cannot navigate to the symbol under the caret.”
  28. Subset sum problem
  29. What is the equivalent of bigint in C#?
  30. How to create an installer for a .net Windows Service using Visual Studio

Leave a Comment