SQLite Connector does not work in Radzen Blazor for Visual Studio Extension

When i right-click a (blazor server) project created with Radzen Blazor for Visual Studio and i next choose Add > Radzen Blazor > Data Source > SQLite > and i click "Next" button i see a screen with SQlite connections where i can select a database, i select a database from my C:\temp path, e.g. C:\Temp\RadzenBlazorInteractiveServerApp\Bands.db (it has no Password so i leave this field blank), finally i click "Next" button (below right on the form wizard) but nothing happens (normally database tables to choose to create CRUD pages from should appear). This works using MS SQLServer but not using SQLite, how comes ?

Thx for any response,

Emmanuel.

Your database most probably don't have any tatbles, it works normally when you have:


Hi enchev,

Thx for your response, yes strange because my SQLite db has a table as next:

But when i click the "next" button i don't see the "Code generation settings" screen that you showed, can i maybe check something in radzen specific logging of the scaffolding component ?

Thx
Emmanuel.

Hello again,

Apparently, on the other hand when using Radze Blazor Studio is seems to work fine:



Any clue why it doesn't work on Visual Studio 2022 with the extension activated ?

Kr,
Emmanuel.

There is indeed an issue with the VS extension and SQLite databases. We will address it with the next release.