We have an existing database that we need an editing UI for. For 70% of the tables we just need a simple editable data grid. The other 30% have one-to-many relationships that require a more sophisticated view, so the app builder must either support that or produce customizable code. If the database schema changes, we need to be to easily update/regenerate the app to reflect the changes.

Ideally, it would be self-hosted rather than cloud-based, so it can access internal databases without going through a firewall.

Lightswitch did this brilliantly. I've spent a week evaluating other options and am coming up short. Radzen seems like it could maybe do it, but their trial (Community Edition) has this feature disabled.

There are a few similar questions, but they don't address the core requirement that it must be easy to generate CRUD view (preferable inline-editable data grids, for editing speed) from an existing database and easily update the app when the database changes.

  • what type of database (sql)?
    – depperm
    Apr 15, 2022 at 0:40
  • Microsoft SQL Server
    – Mud
    Apr 15, 2022 at 0:53


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.