Platz.SqlForms

If this project helps you reduce time to develop, you can give me a cup of coffee :)

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:

https://www.codeproject.com/Articles/5291832/Microsoft-Blazor-Rapid-Development-with-SQL-Forms

Wiki:

https://github.com/ProCodersPtyLtd/MasterDetailsDataEntry/wiki

Programming reference:

https://github.com/ProCodersPtyLtd/MasterDetailsDataEntry/wiki/Platz.SqlForms-programming-reference

Please submit bugs or feature requests here:

https://github.com/ProCodersPtyLtd/MasterDetailsDataEntry/issues

NuGet packages available:

https://www.nuget.org/packages/Platz.SqlForms

https://www.nuget.org/packages/Platz.ObjectBuilder

Demo run:

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

Another demo with inline edit:

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

This is another good database to try: https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms

Official roadmap

Release 0.2.0 - done

• 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

Release 0.3.0 - done

• SqlForms custom rules to change field properties (hidden, required, read-only, etc.)
• SchemaDesigner prototype, that allows to design database entities and save the schema to json
• T4 template to geneate SchemaDesigner entities and data access layer
• Upgrade ObjectBuilder to support SchemaDesigner entities

Release 0.4.0 - done

• ObjectBuilder Group By queries
• ObjectBuilder Subqueries
• Grid Sorting, Pagination and Filtering
• ObjectBuilder usability
• Seed projects for easy start

Release 0.5.0 - Sep'21 - In progress

• Date, Decimal and Dropdown filters
• T4 templates for SchemaDesigner entities to support Queries with Group By and Subqueries
• Usability and error data recovery for builders and designers
• Bug fixes

Release 1.0.0 - Oct'21

• Support documentation
• Tutorials
• Bug fixes

Release 2.0.0 - 2022

• Forms designer
• No-code full support
• No-code to Low-code converter

Backlog

• Improve page navigation (links {0}{1}) dev experience
• ObjectBuiler Select functions (not Group By)
• ObjectBuilder T4 template to generate business object CRUD operations' C# code
• ObjectBuilder definition of business object - entity mappings and CRUD operations
• UI SQL forms to entry/edit business objects
• Support of Postgres

Ideas

• Form designer
• Work Flow engine
• Work Flow designer
• Full no-code infrastructure
• No-code cloud solution