SfGrid - DBfirst reverse engineering CRUD scaffolding tool

[Volker]

Hi there,

is there a syncfusion tool available to fully scaffold an existing SQL-Server DB using EF Core, and connect it to a Syncfusion grid with fully CRUD functionality without writing a lot of code (out of the box, no need for customizing, dbcontext goes to a seperate project, that acts as a data-layer)?

e.g. Radzen Ltd. has brought out such a tool, that is able to fully reverse engineer a complete SQL-Server DB with some clicks only and connect it to their grid, but unfortunately the generated code (dbcontext, dbservice) is not compatible with SFGrid CRUD operations.

Cheers,
Volker

[Renjith Singh Rajendran]

Hi Volker, 

Greetings from Syncfusion support. 

To auto generate component codes, we have Blazor template studio and scaffolding. Please refer the below documentation links which will be helpful for you to know above these support in detail. 

Template studio - https://blazor.syncfusion.com/documentation/visual-studio-integration/visual-studio-extensions/template-studio/ 

Scaffolding - https://blazor.syncfusion.com/documentation/visual-studio-integration/visual-studio-extensions/scaffolding/ 

If we have misunderstood your query, or if you need further assistance, kindly get back to us with the following details, 

1. Share the detailed description of your requirement.

Please get back to us if you need further assistance. 

Regards, 

Renjith Singh Rajendran 

[Volker]

Hi Renjith,

that's funny: I totally missed that feature :-))))

Will check it and let you know, if i need further assistance.

Chers,
Volker

[Renjith Singh Rajendran]

Hi Volker, 

Thanks for your update. 

Please try the suggested solution and get back to us if you need further assistance. 

Regards, 

Renjith R 

[Volker]

Hi Renjith,

the solution of Radzen Lmt. gets one step further.

There you can scaffold the full DB with a view mouse clicks (tables, views, stored procedures as model classes) and you get all DBSets and the DBContext, but in addition all CRUD-logic methodes (DBService controller) of all selected tables. The auto-generated DBService-class includes all CRUD methodes out of the box, no need to tie it up to a grid.

Press button "Data" -> Choose Database -> Press button "Infer Schema" -> Press button "Finish"

When I use the Syncfusion Scaffolding tool, I only can select one table a time, and must pass it to e.g. dummy grid to get the CRUD routines of that table as ready-to-use DbService.

And now imagine a project in development with hundrets of existing tables (DB first approach). Possibly you can check the Radzen solution to enhance your tool.

Thank you!

Cheers,
Volker

[Ganesan Rengasamy]

Hi Volker, 

 

We have created the feature report for this requirement from our side. We will analyze the Radzen tool and check the possibilities to enhance our Syncfusion scaffolding tool. You can track the status of this requirement from the below link.

https://www.syncfusion.com/feedback/18871/syncfusion-blazor-scaffolding-crud-operation 

 

Regards, 

Ganesan Rengasamy. 

[Volker]

Hi Ganesan,

great news, hope you can implement it, too

Cheers,
Volker

[Ganesan Rengasamy]

Hi Volker, 

 

Yes, we will check the possibilities and implement the feature in any of our upcoming releases. 

 

Regards, 

Ganesan Rengasamy.