Platz.SqlForms

Created by Pro Coders team. Please visit our web site https://www.procoders.com.au

Framework for generating dynamic UI for master-details CRUD operations

CodeProject Blog:

Wiki:

Programming reference:

Please submit bugs or feature requests here:

NuGet packages available:

Demo run:

Download or clone repository https://github.com/euklad/BlogCode/tree/main/DemoSqlForms-story6
Open DemoSqlForms.sln
Set DemoSqlForms.App as Stratup Project and run

Another demo with inline edit:

Clone or download this repository https://github.com/ProCodersPtyLtd/MasterDetailsDataEntry
Open MasterDetailsDataEntry.sln
Goto https://docs.microsoft.com/en-us/ef/ef6/resources/school-database and create the School database
Change connection string in MasterDetailsDataEntry.Demo.Database\School\SchoolContext.cs if needed
Set SqlForms.Demo as StartUp Project
Run (F5)
Click on [Department Details] menu

Official roadmap

Support data services that returns business objects that may differ from EF entities
UI component to show a list of business objects and context menu
UI form to entry/edit EF entities
Platz.ObjectBuilder library to define data services using visual interface
ObjectBuilder T4 template to generate data services C# code

UI form to entry/edit business objects
ObjectBuilder definition of business object - entity mappings and CRUD operations
ObjectBuilder T4 tempalte to generate business object CRUD operations' C# code
ObjectBuiler Select functions
ObjectBuilder Group By queries
ObjectBuilder Subqueries
SqlForms custom rules to change field properties (hidden, required, read-only, etc.)