I have a web app on Azure that I am trying to connect to a mysql db hosted on aiven.io. The connection works if I hard code the connection string in appsettings.json. When I enter the exact same connection string…
I have the following connection string in my web.config: <add name="ConvMapping.Properties.Settings.ifl" connectionString="Data Source=serverInfo;Initial Catalog=database;Persist Security Info=True;User ID=userid;Password=password" providerName="System.Data.SqlClient" />` The issue is now we have to use the database based on a selection. So, example I want to do something…
I am trying to retrieve a connection string stored in Application Settings, Connection strings in Azure for my web application. The application works fine run locally, but when I publish to Azure the call to AddAzureAppConfiguration throws saying that the…
This problem is occurring with a Web API project developed with Visual Studio 2022 in C# and.NET6. The database is PostgreSQL hosted in Azure and I'm using EF Core. Specifically: Microsoft.EntityFrameworkCore v7.0.2 Npgsql.EntityFrameworkCore.PostgreSQL v7.0.1 I followed the code-first approach to…
I have a C# web app with a database connection string saved in the web.config file. This file is also part of a git repository. How can I save the connection string to prevent it from being compromised in case…
I'm working on a Docker related application, written in C#, based on Entity Framework. One of the Docker containers, is the ms-sql-server, which is used for database access. In order to access the SQL-server, following connectionString is created: Server=ms-sql-server;Initial Catalog=Ownobjects;User…
Is there a special way to define a Key Value setting for ConnectionStrings in Azure App Configuration? I have tried using: ConnectionStrings:DatabaseKeyName ConnectionStringsDatabaseKeyName Using the standard builder.Configuration.GetConnectionString("DatabaseKeyName") always results in a null value. Using builder.Configuration["ConnectionStrings:DatabaseKeyName"] also results in null, however…
I try to connect FROM my ON-PREMISE SQL Server SSRS 2019 TO an Online Microsoft Azure SQL DB. It works fine, when I connect locally from my DBMS to the online DB. Yet everything is secured with MFA though. Unfortunately…
I've set up my website (app service) and database (Sql Server) in Azure. Right now it works like this: prod website -> prod database The prod website has connection strings to the prod database and all is good! What I…
I'm working on a .NET Framework 4.5.2 legacy application. I need the plain ConnectionString of my application, but I don't know how to read it. Unfortunately the Web.config file of the app, does not have a section "connectionStrings". Instead, in…