Skip to content

v1.0.0

Choose a tag to compare

@github-actions github-actions released this 13 Sep 17:38
· 11 commits to main since this release

The CodeComplete data-class generator, rebuilt as a cross-platform Avalonia app — and no longer tied to SQL Server.

Point it at a table or view and it writes the same data-abstraction class the original did: a property per column, then Initialize, CopyFields, RecExists, Add, Update, Delete, Read, ReadAsDataTable, GetAll, and a GetListBy… for every column you pick. That class has the same members, names and signatures whatever database it came from.

Four engines

Engine Browsing Generated code uses
Microsoft SQL Server sys.objects, sys.columns Microsoft.Data.SqlClient
PostgreSQL information_schema, pg_database Npgsql
MySQL / MariaDB information_schema MySqlConnector
SQLite sqlite_master, PRAGMA table_xinfo Microsoft.Data.Sqlite

Four things adapt per engine and nothing else: the client library, the parameter DbType enum, identifier quoting, and how a generated key comes back — SCOPE_IDENTITY(), RETURNING, LAST_INSERT_ID(), last_insert_rowid().

Browsing and emitting are independent choices, so a SQL Server schema can produce an Npgsql class. That is what porting a table between engines needs.

Downloads

Self-contained single executables. No .NET runtime to install.

x64 arm64
Linux CCReimagined-1.0.0-linux-x64.tar.gz CCReimagined-1.0.0-linux-arm64.tar.gz
Windows CCReimagined-1.0.0-win-x64.zip CCReimagined-1.0.0-win-arm64.zip
macOS CCReimagined-1.0.0-osx-x64.tar.gz CCReimagined-1.0.0-osx-arm64.tar.gz

Extract and run. On macOS, Gatekeeper will need xattr -d com.apple.quarantine CCReimagined.App — the binaries are not signed or notarised.

Start here

docs/CCReimagined-Developer-Guide.pdf — seven pages, with the generated output for the same table set side by side across all four engines.

dev/sample-databases has a Docker Compose stack and a schema built to exercise the awkward cases, if you want something to point it at.

Moving from the old generated classes

Some behaviours were corrected rather than carried across:

  • Nullable columns are nullable properties. The old classes used sentinels ("", a minimum date), so "not set" and "legitimately empty" were indistinguishable. Binding an empty string as NULL is still available as an opt-in.
  • Reserved words match exactly. The original tested whether a name contained a keyword, so INTERVIEWER was renamed because it contains int.
  • Columns follow the table's declared order, not alphabetical.
  • Identity detection covers serial, AUTO_INCREMENT and SQLite's rowid alias, not just IDENTITY.
  • A table with no auto-numbering key still generates — the assumption is shown and the key is a checkbox you can move. The original stopped at a modal dialog.
  • ReadAsDataSet became ReadAsDataTableAsync, because not every provider ships a DataAdapter.
  • Async throughout, with blocking wrappers kept for callers that cannot await.

How far it is verified

For each engine the suite creates a table, discovers it, generates the class, compiles that class with Roslyn, and drives insert, key read-back, read, update, exists, both list getters and delete against a real server. Generated code that does not build, or does not round-trip a row, fails the build.

Not carried over yet

The XAML, WinForms, HTML/CSS, JavaScript and TypeScript generators, the LM Studio integration and the subnet scanner. This release is the database orchestration.


Requires the .NET 10 SDK only if you build from source. Pinned to Avalonia 11.3 because the generated-code editor uses SyntaxColorizer.