Connection strings format

[Marcel]

It seems that the report viewer only supports this connection string format in the appsettings.json file for Asp.Net Core applications

"ConnectionStrings": [
  {
    "name": "Reports",
    "connectionString": "Data Source=.;Initial Catalog=DatabaseName;Integrated Security=True",
    "providerName": "System.Data.SqlClient"
  }
]

 

But now a days this format for connection strings is used:

"ConnectionStrings":  {
"Reports": "Data Source=.;Initial Catalog=DatabaseName;Integrated Security=True"
}

 

It should be nice if the newer format also is supported.

 

 

 

[Neli]

Hi Marcel,

We need the providerName along with the rest of the information in the connection string. Our current approach for registering the connection string is also consistent with the approach in the .NET Framework. If we use the proposed approach, we will not be able to determine the data provider.

Regards,
Neli
Progress Telerik

[Borja]

Hi Neli,

And how can we mix this way to set up the connection string with the one that Marcel posted?

If is not posible, how can we reference the connection string in the startup with that format?

I mean:

services.AddDbContext<MyContext>
                (options => options.UseSqlServer(Configuration.GetConnectionString("MyContext")));

Cant find the way to make startup work in the format that telerik reporting needs.....

Regards,

 

[Marcel]

@Carlos: I created two *settings.json files. One regular appsettings.json and another one with the name reportsettings.json. Both have different formats of connectionstrings. Add the startup of the application I also add the reportsettings as a config file.

[Borja]

Thank you Marcel,

Just trying it right now!

 

Regards

[Borja]

Worked like a charm Marcel, 

Still thinking how i missed it. 

Have a nice day