Adding Data Source Naming

Radzen Blazor for Visual Studio
1

I received compiler errors associated with naming when adding a data source and scaffolding to a new project. Repro info:

Project Type: Blazor Web App (Auto)
.NET Version: .NET 9

Steps:

  1. Create a brand new project
  2. Create a DB with a hyphenated db name. e.g. myapp-dev
  3. Add a Radzen data source
  4. Continue to add DB tables
  5. Continue to add scaffolding to all tables
  6. On the settings page, set the name to MyAppDB
  7. Generate

Here are the errors I saw and how I resolved them.

  1. Radzen used "myapp-dev" as a class name for services. Looking at the types, I figured out they were meant to be the Radzen generated type MyAppDBService. Refactored and it worked.
  2. Fully qualified type names for Models were MyBlazorApp.Server...myapp-dev... So I factored that out and added global usings for the namespace since it was being used everywhere - for both the Client and Server.
  3. I had selected a stored procedure for performing a custom deletion action, DeleteMyModelProc(int id). Radzen seemed to create a CRUD abstraction around that. However, the generated code dotted into methods that were not generated. I commented those out and everything compiled.

I'm supposing that Some of this wouldn't have happened if I had named my DB MyAppDB. However, we often don't get that choice for legacy DBs or those in large orgs where the Databases and other infrastructure are managed outside of the software development business function. On the stored proc, I guessing that there's a pattern to follow, but again, we often don't have those choices available.

Once I got it working, it was very nice to work with and use. I can see how useful this can be.

2

Hi @Joe_Mayo,

Indeed there has to be a validation that the database name is a valid C# identifier. We will add it with the next release.