connection-string – Page 6

Get ConnectionString from appsettings.json instead of being hardcoded in .NET Core 2.0 App

January 13, 2023 by Tarik

STEP 1: Include the following in OnConfiguring() protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { IConfigurationRoot configuration = new ConfigurationBuilder() .SetBasePath(AppDomain.CurrentDomain.BaseDirectory) .AddJsonFile(“appsettings.json”) .Build(); optionsBuilder.UseSqlServer(configuration.GetConnectionString(“DefaultConnection”)); } STEP 2: Create appsettings.json: { “ConnectionStrings”: { “DefaultConnection”: “Server=YOURSERVERNAME; Database=YOURDATABASENAME; Trusted_Connection=True; MultipleActiveResultSets=true” } } STEP 3: Hard copy appsettings.json to the correct directory Hard copy appsettings.json.config to the directory specified in the … Read more

What is the point of “Initial Catalog” in a SQL Server connection string?

January 8, 2023 by Tarik

If the user name that is in the connection string has access to more then one database you have to specify the database you want the connection string to connect to. If your user has only one database available then you are correct that it doesn’t matter. But it is good practice to put this … Read more

Setting up connection string in ASP.NET to SQL SERVER

January 7, 2023 by Tarik

You can also use this, it’s simpler. The only thing you need to set is “YourDataBaseName”. <connectionStrings> <add name=”ConnStringDb1″ connectionString=”Data Source=localhost;Initial Catalog=YourDataBaseName;Integrated Security=True;” providerName=”System.Data.SqlClient” /> </connectionStrings> Where to place the connection string <?xml version=’1.0′ encoding=’utf-8′?> <configuration> <connectionStrings> <clear /> <add name=”Name” providerName=”System.Data.ProviderName” connectionString=”Valid Connection String;” /> </connectionStrings> </configuration>

How to use pg_dump with a connection uri / url?

January 5, 2023 by Tarik

pg_dump postgres://username:password@my_postgres_server:5432/databasename I just downloaded a dump using this format. Optionally you can add -f filename to specify a local filename.

How to find SQL Server running port?

December 29, 2022 by Tarik

Try this: USE master GO xp_readerrorlog 0, 1, N’Server is listening on’ GO http://www.mssqltips.com/sqlservertip/2495/identify-sql-server-tcp-ip-port-being-used/

How can I set an SQL Server connection string?

December 21, 2022 by Tarik

.NET DataProvider — Standard Connection with username and password using System.Data.SqlClient; SqlConnection conn = new SqlConnection(); conn.ConnectionString = “Data Source=ServerName;” + “Initial Catalog=DataBaseName;” + “User id=UserName;” + “Password=Secret;”; conn.Open(); .NET DataProvider — Trusted Connection SqlConnection conn = new SqlConnection(); conn.ConnectionString = “Data Source=ServerName;” + “Initial Catalog=DataBaseName;” + “Integrated Security=SSPI;”; conn.Open(); Refer to the documentation.

What is the MySQL JDBC driver connection string?

December 17, 2022 by Tarik

Assuming your driver is in path, String url = “jdbc:mysql://localhost/test”; Class.forName (“com.mysql.jdbc.Driver”).newInstance (); Connection conn = DriverManager.getConnection (url, “username”, “password”);

How should I edit an Entity Framework connection string?

December 16, 2022 by Tarik

If you remove the connection string from the app.config file, re-running the entity Data Model wizard will guide you to build a new connection.

“Server” vs “Data Source” in connection string

November 29, 2022 by Tarik

For the full list of all of the connection string keywords, including those that are entirely synonymous, please refer to the SqlConnection.ConnectionString documentation: These are all entirely equivalent: Data Source Server Address Addr Network Address

How to read connection string in .NET Core?

November 14, 2022 by Tarik

The posted answer is fine but didn’t directly answer the same question I had about reading in a connection string. Through much searching I found a slightly simpler way of doing this. In Startup.cs public void ConfigureServices(IServiceCollection services) { … // Add the whole configuration object here. services.AddSingleton<IConfiguration>(Configuration); } In your controller add a field … Read more