How to point all connection string in generated strongly typed datasets to use appsettings default connectionstring in ASP.NET Core Razor pages

Question

How to point all connection string in generated strongly typed datasets to use appsettings default connectionstring in ASP.NET Core Razor pages

Olumuyiwa Afolabi 1

How can I point all generated dataset schema connection string to use appsettings default connection string in ASP.NET Core Razor pages?

Note: this works perfectly in ASP.NET Webforms and ASP.NET MVC, but not in ASP.NET Core with Razor pages.

Generated code from dataset Xsd Schema:

private void InitConnection()
{
this._connection = new global::System.Data.SqlClient.SqlConnection();
this._connection.ConnectionString = "Data Source=(localdb)\mssqllocaldb;Initial Catalog=mylocaldb;Integrated Security=True";
}

I want the connection string to point to the appsettings.json default connection.

Thanks

Anonymous

Hi @Olumuyiwa Afolabi ,

Which version of Asp.net core you are using?
If you are using Asp.net 6, you can check the program,cs file, when register the DbContext, you could get the connections string via Configuration, code like this:

builder.Services.AddDbContext<SchoolContext>(options =>  
  options.UseSqlServer(builder.Configuration.GetConnectionString("SchoolContext")));

The appsettings.json file is like this:

{  
  "Logging": {  
    "LogLevel": {  
      "Default": "Information",  
      "Microsoft.AspNetCore": "Warning"  
    }  
  },  
  "AllowedHosts": "*",  
  "ConnectionStrings": {  
    "SchoolContext": "Server=(localdb)\\mssqllocaldb;Database=SchoolContext-0e9;Trusted_Connection=True;MultipleActiveResultSets=true"  
  }  
}

If you are using Asp.net 5 or lower version, you can check it in the Startup.cs file. Refer to this link.

Best regards,
Dillion

Your answer

Anonymous

2021-12-27T07:07:14.45+00:00

Hi @Olumuyiwa Afolabi ,

Which version of Asp.net core you are using?
If you are using Asp.net 6, you can check the program,cs file, when register the DbContext, you could get the connections string via Configuration, code like this:

builder.Services.AddDbContext<SchoolContext>(options => options.UseSqlServer(builder.Configuration.GetConnectionString("SchoolContext")));

The appsettings.json file is like this:

{ "Logging": { "LogLevel": { "Default": "Information", "Microsoft.AspNetCore": "Warning" } }, "AllowedHosts": "*", "ConnectionStrings": { "SchoolContext": "Server=(localdb)\\mssqllocaldb;Database=SchoolContext-0e9;Trusted_Connection=True;MultipleActiveResultSets=true" } }

If you are using Asp.net 5 or lower version, you can check it in the Startup.cs file. Refer to this link.

Best regards,
Dillion

Share via

How to point all connection string in generated strongly typed datasets to use appsettings default connectionstring in ASP.NET Core Razor pages

Your answer