Skip to content

[Question]: Would opt-in automatic schema setup for ADO.NET providers be considered? #9851

@cholexa

Description

@cholexa

Context

When using ADO.NET clustering/persistence providers, setting up the database schema requires manually executing SQL scripts. While this is straightforward, it adds friction in CI/CD pipelines and containerized deployments where automation is preferred.

A couple of approaches that could work:

Option 1
Embed existing SQL scripts as assembly resources and execute them automatically based on configuration:

siloBuilder.UseAdoNetClustering(options =>
{
    options.ConnectionString = "...";
    options.Invariant = "Npgsql";
    options.AutoApplySchema = true;
});

Option 2
Ship pre-built migration bundles per database provider instead of raw SQL scripts. Users would run the bundle against their database before starting the silo — no SDK required, just a self-contained executable

  • Has this been discussed or rejected previously?
  • Are there technical or philosophical concerns with this approach?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions