Radzen database infer creates C# Task function parameters with illegal characters

Radzen Studio Blazor Server
1

Hi! I started a new project from scratch, and did a database infer.

Am using v2.62.1.

The database has some columns with names like "tr_60_90DayReview".

When Radzen's infer completes. I go to run the app. Instead of the start page, I get a ton of CS1003 and other errors.

I loaded Visual Studio - that's when I saw the newly created functions, which created parameters such as "6090Day" .

I deleted the app and recreated to start clean and from scratch. Same thing.

I deleted the app again, went into the database, renamed the columns (e.g. "tr_75DayReview" or "tr_SeventyFiveDayReview", 80DayReview, 6090Review, etc, with text-only options. I then created a new Radzen app completely from scratch and inferred the database. The underscored prefix still gets dropped and the words "SeventyFive" is turned into "75", "eighty" to "80", and so on.) .

Here’s an example of code Radzen produced:

public async Task PRecordDeletes(int? psID, int? WGID, int? rsID, int? sccID, int? wccID, int? ptID, int? lsID, string prDate, string pdate, string csdDate, string 75Due, string 80Due, string rfFlag, string ppsScreen, string sordate, string pdRDate, string oeDate, string 6090DayReview, string edAssign, string erDue14, string edDue21, string rcFlag)
{
...
}

I went into Visual Studio to refactor any variable starting with a number and added a letter. These changes got written over. Adding the master context.cs class file to the "Code generation ignore list". This didn't work and I had to remove the file from the list.

Is there a better way to infer the database? Or app generated by Radzen?

Thanks!

2

Hi @david.cole,

Such problems were never reported before, thanks! We will do our best to provide fix in our next update next week.

3

I've just tested a SQL table with the following definition and everything worked as expected in auto-generated app with CRUD pages:

image
image3840×2160 354 KB

image
image3840×2160 380 KB

image
image3840×2160 430 KB

image
image3840×2160 308 KB

4

Thanks for looking into this and ruling out Radzen! The problem's definitely on my end somewhere, will keep looking...

5

A coworker who I emailed last week but was on holiday got back to me. It looks like Radzen inferring the stored procedure is where the variable is being created with the number. He's on a different project so I'll be replacing "@75Due" and other parameters with proper text. It's an older application we're upgrading, but it's interesting how SQL allowed variable declarations with a number.

Thanks again for your time and effort put into this!