How to Get the Connection String from a Database

How to get the connection String from a database

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.

How to access connection string & connect to database

Using what Mason recommended below you can simply hard code your connection string instead of pulling it from the app.config if it is giving you issues.. Here is an example:

var connectionString = "Hard code connection string";
//Make sure your DataContext has a constructor that takes in a connection string
using (var context = new DataContext(connectionString)) 
  {
    context.Macros.Add(new Macro { Name = "test" });                    
    context.SaveChanges();
    //Output to the screen if the savechanges was successful
    new Decider().Decide(EnumDecisionType.eOkDecision, "Save Changes Called ", "", EnumDecisionReturn.eOK, EnumDecisionReturn.eOK);
  }

How to get Database Name from Connection String using SqlConnectionStringBuilder

See MSDN documentation for InitialCatalog Property:

Gets or sets the name of the database associated with the connection...

This property corresponds to the "Initial Catalog" and "database" keys within the connection string...

How to access database connection string from appsettings.json file in Program.cs file

You can get the connection string by using Configuration property of HostBuilderContext class. So you need to use the overload of ConfigureServices that helps you inject an instance of HostBuilderContext like below:

serviceHost.ConfigureServices((hc, sc) =>
{
    sc.AddDbContext<DiagnosticDbContext>(db => 
        db.UseSqlServer(hc.Configuration.GetConnectionString("DbContext"), 
        options => options.EnableRetryOnFailure(5))
    );
});

Find connection string for DB in Rider/Azure Data Studio. SQL

I am also using M1 Mac and SQL Edge coming from this tutorial.
In the ASP.NET WebApp the connection string looks something like this:

      "ConnectionStrings": {
          "Default": "Server=localhost; Database=<insert db name>; User Id=sa; Password=your_password123"
      }

Connection string for local database not working

Replace TrustServerCertificate = true; with Integrated Security = true

how to programmatically get connection string from local database at run time? c# winforms

You can get and edit the connection string using SqlConnectionStringBuilder Class.

Here the connection string is local to the method but any place in scope of the method below.

public static void ChangeConnectionStringFromExisting()
{

    var connectionString = "Server=localhost;Integrated security=SSPI;database=master";

    var builder = new SqlConnectionStringBuilder(connectionString);

    builder.DataSource = "(LocalDB)\\MSSQLLocalDB";
    builder.InitialCatalog = "MyAppDatabase.mdf";

    connectionString = builder.ConnectionString;

    using (var cn = new SqlConnection(connectionString))
    {
        // . . .
    }

}

---

Related Topics