Scaffold problem

Radzen Blazor Studio
1

I am working on database first project and have some changes in a database so I tried to scaffold database objects but have an error that looks like this:

Format of the initialization string does not conform to specification starting at index 0.

This error is received through a window that has the label "Inferring data source" with a lot of following text that describe in a .NET manner what was going wrong.

As I did it several times before the same process I need to know what I have done wrong. Compiled application works with no problem and compilation is with no errors.

2

Probably the connection string to the database is wrong. Did you change anything in it? Password maybe?

3

That connection string is the very same string that application run with.

4

In that case we are not sure what went wrong. This message indicates a bad connection string.

5

Can you help me where can I find records that are in the section "Choose an existing data source" maybe I could solve the problem when I delete or edit them.

6

Those "records" are parsed from your source code. You can't delete them. You can try recreating the data source as a new one. Make sure to use the exact same name as before. I still think there is a problem with the connection string (which is stored in appsetings.json/appsettings.Development.json).

7

I am running into the same error message. Up until recently, I was able to work around this by recreating the data source as you mentioned above (with the same exact name). My development database was hosted on Azure with SQL Authentication. Company Policy now dictates that SQL Authentication is no longer permitted and we must use Entra ID Authentication. I switched the connection string in appsettings.Development.json to use Authentication='Active Directory Default' and the application now works in Radzen Blazor Studio and Visual Studio 2022. Unfortunately, I cannot use the Radzen scaffolding capabilities because of the error message. I cannot use the workaround by recreating the data source because the only Authentication types in the Authentication Type dropdown (on the MSSQL connection page) are "SQL Login" and "Windows". Is there some other workaround?

8

Hi @mherman,

I am not sure I understand what the problem is. When do you get this error message? What steps should we perform in order to reproduce the error in a test project?

9

Here is how I got the error message:

  1. Open existing application in Radzen Blazor Studio
  2. On the main Radzen Blazor Studio page, click on the Data button
  3. On the "Create or Update a data source" page, click on the existing data source
  4. Press Next
  5. On "Inferring data source" page, received this message: Format of the initialization string does not conform to specification starting at index 0.

To recreate this issue, you may need to use an Azure SQL Server database. I realize that this is beyond the scope of normal support. Performing a google search for the error, I see that this is not a Radzen error message, but it is a Microsoft error message. Therefore it is probably not something that you can fix or debug. Unfortunately, that Microsoft error message does not tell me what it can't understand in the connection string. When I run the app in Visual Studio, it works fine.

I may need to copy the database schema to a local SQL server in order to use the Radzen scaffolding.

10

Can you please share the connection string? You can set it via email to info@radzen.com. Perhaps this would allow us to find the cause of the exception.

The strange thing is that the app runs with the same connection string (or does it)? Is the connection string in appsettings.json and appsettings.Development.json the same?