CoddLoom.Sqlite 0.1.0

CoddLoom

CoddLoom is a lightweight, explicit ORM that weaves entity mapping, schema definitions, and portable SQL directly over ADO.NET.

It keeps SQL visible and the data-access model small: there is no LINQ provider, change tracker, or hidden unit of work. CoddLoom provides explicit table and entity mapping, parameterized CRUD, conditions and joins, pagination, transactions, batch inserts, and additive column initialization.

Packages

Stable versions are published to NuGet.org from vX.Y.Z tags. Every successful push to main also publishes a uniquely versioned 0.0.0-edge.* build to GitHub Packages for pre-release validation. GitHub Packages requires a GitHub token even for public packages; see Working with the NuGet registry for source and authentication setup.

Compatibility

CoddLoom, MariaDB, MySQL, PostgreSQL, SQLite, and SQL Server target netstandard2.0. The Oracle provider targets netstandard2.1.

CI verifies that clean downstream projects targeting net8.0 and net10.0 can restore and build all seven locally packed packages. The .NET 10 check also loads a public type from every package and exercises SQLite by opening a database and writing and reading a row. This establishes package and framework compatibility; it does not mean that every provider connects to a live database on both target frameworks. The real-database integration matrix remains the one documented in Build and test.

Example

using CoddLoom;
using CoddLoom.Condition;
using CoddLoom.Sqlite;
using CoddLoom.Table;

var executor = new SqliteExecutor("data", "app.db");
var engine = new DbEngine(executor, new[]
{
    new TableDefine(typeof(UserTable))
});

var users = engine.Select<User>(
    new WhereConditions(UserTable.Name, "Ada"),
    new OrderByCondition(UserTable.Id));

For PostgreSQL, install CoddLoom.PostgreSql and construct the engine with a PostgreSqlExecutor using an Npgsql-compatible connection string.

Tables and entities are defined independently: table constants describe schema and reusable SQL identifiers, while mapping attributes connect entity members to those columns.

ID generation and concurrency

GenerateId, GenerateMaxId, GenerateTimeId, and GenerateUtcTimeId return a candidate that was unused at the moment their existence query ran. They do not reserve it, and they do not guarantee that a later insert will succeed.

When these are enough. A single writer generating IDs for the table, or an insert backed by a unique constraint with a retry on duplicate key.

Deprecated. All four emit a compiler warning. They remain source-compatible, and the deprecation itself does not change their behavior; existing callers can keep using them while migrating to one of the alternatives below. One behavior did change separately: GenerateId now throws ArgumentOutOfRangeException when tryCount is zero or less, instead of reporting candidate exhaustion.

Concurrency. Otherwise, two callers can receive the same candidate in the window between the existence query and either caller's insert. Supplying con or tran does not by itself close that window — the query and the insert must be covered by one isolation level or lock. A serializable transaction spanning both does close it; read committed does not. On PostgreSQL that surfaces as a serialization failure for one of the two, which the caller retries.

Time-based candidates format their 12-digit yyMMddHHmmss timestamp prefix with the invariant culture's Gregorian calendar. The same DateTime therefore has the same prefix regardless of the process's current culture. They keep second-level timestamp precision and append a random three-digit suffix from 000 through 999. One local random generator supplies all retries in a GenerateTimeId call, but retries can still choose the same suffix and concurrent calls still are not guaranteed to return different candidates.

Connections and transactions. These methods query through tran when supplied, otherwise con, otherwise a connection of their own; when both are given, tran takes precedence and con is unused. This matters with no concurrency at all: a caller inside an open transaction that does not forward it through tran runs the query on a different connection, where its own uncommitted rows are invisible, so two consecutive calls can return the same ID.

Alternatives. Prefer an ID the database generates atomically — an identity column or a sequence. Client-generated UUIDs are the other standard choice. If IDs must follow an application-specific scheme, enforce a unique constraint and retry the insert after a duplicate-key failure.

Build and test

dotnet build CoddLoom.sln --configuration Release
dotnet test CoddLoom.sln --configuration Release --no-build

The default test run uses an isolated SQLite database and includes the complete unit and integration suite. CI also runs the database integration category against PostgreSQL 16, MySQL 8.4, MariaDB 11.4, and SQL Server 2022. Provider SQL contract tests run for all six database providers, including Oracle, on every build.

To run the integration category against a local server, set the provider and its connection string before invoking the filtered suite. Oracle is intentionally an opt-in real-server test because its image and licensing requirements do not fit the public CI runner; its SQL dialect remains covered by the provider contract suite.

TEST_DATABASE_TYPE=Oracle \
TEST_DB_CONNECTION_ORACLE="Data Source=localhost:1521/FREEPDB1;User Id=test;Password=password;" \
dotnet test tests/CoddLoom.Tests/CoddLoom.Tests.csproj --filter "TestCategory=Database"

Releasing

Repository maintainers configure a NuGet.org Trusted Publishing policy for .github/workflows/release.yml, then push a semantic-version tag. The release workflow verifies the repository, publishes all seven packages and their symbol packages, and creates a GitHub Release containing the same artifacts.

git tag v1.2.3
git push origin v1.2.3

Pre-release tags such as v1.2.3-rc.1 create a pre-release and publish a NuGet pre-release version.

License

CoddLoom is licensed under the MIT License. Database drivers remain under their respective licenses; see Third-party notices.