MySQL generated code error

Radzen Studio Blazor Server
1

v2.87.12 of Radzen, inferred on a mysql database and I'm getting this error from the Radzen generated code: "Argument 2: cannot convert from 'string' to 'Microsoft.EntityFrameworkCore.ServerVersion'"

Here's the code radzen generated in startup.cs:

services.AddDbContext<FmuDeviceUi2.Data.FmuContext>(options =>
{
options.UseMySql(Configuration.GetConnectionString("FMUConnection"));
});

If I replace the above code with the following, everything compiles and runs ok:

var cs = Configuration.GetConnectionString("FMUConnection");
services.AddDbContext<FmuDeviceUi2.Data.FmuContext>(options =>
{
options.UseMySql(cs, ServerVersion.AutoDetect(cs));
});

I am targeting dotnet 8. Is there some setting for mysql that I need to change in order to get good code generation from Radzen?? Thanks!

2

Here are the versions:

MS Data SqlClient 6.0.1
EF Core 6.0.0
EF Core Design 6.0.0
Pomelo EF Core MySql 6.0.0
dotNet 8

3

Hi @terryfryar,

The latest version of Radzen Studio supports .NET 7 only. It cannot generate .NET 8 compatible code. We recommend using Radzen Blazor Studio which supports .NET 7, .NET 8 and .NET 9.

4

Sorry....I don't understand? Is there a new version of Radzen that I am currently subscribed for? Is my product locked to dotnet 7 permanently then? Is my product being removed at some point then?

Also, oddly....I created a brand new empty project for dotnet 7 and inferred a MySQL table and here is the code generated:

services.AddDbContext<MySqlTest.Data.TestContext>(options =>
{
options.UseMySql(Configuration.GetConnectionString("TestConnection"), ServerVersion.AutoDetect(Configuration.GetConnectionString("TestConnection")));
});

which is actually correct?

5

Hi @terryfryar,

There has been a newer product for a few years - Radzen Blazor Studio.

Yes. Radzen Studio is no longer receiving new features. The latest .NET framework version that it supports is 7. We strongly recommend migrating to Radzen Blazor Studio.

We will not remove Radzen Studio however we won't be adding new features to it.

That is correct however you said your application is using .NET 8 which is the unsupported case. I am even not quite sure how you've managed to get Radzen to work with .NET 8.