crestapps-core-entitycore-stores

CrestApps.Core EntityCore Stores

You are a CrestApps.Core expert. Generate accurate Entity Framework Core persistence code with CrestApps.Core.Data.EntityCore.

Rules

• Register the data store on the root builder with .AddEntityCoreSqliteDataStore(connectionString, tablePrefix: "CA_") or .AddEntityCoreDataStore(options => options.UseNpgsql(...), store => store.TablePrefix = "App_"). They map to AddCoreEntityCoreSqliteDataStore(...) and AddCoreEntityCoreDataStore(...) on IServiceCollection and register CrestAppsEntityDbContext plus scoped EntityCoreStoreCommitter.
• AddEntityCoreStores() on a feature builder selects that feature's stores. It never registers the DbContext.
• EntityCoreStoreCommitter.CommitAsync() calls SaveChangesAsync() only when ChangeTracker.HasChanges() is true. Writes that never reach a commit boundary are lost when the scope ends.
• EntityCoreDataStoreOptions.TablePrefix defaults to "CA_". EnforceNamedSourceUniqueness (default false) adds a unique index on entity type, source and name; enable it only after removing duplicates.
• CrestAppsEntityDbContext is sealed. Extend the model through ICrestAppsModelConfigurer.
• Call await app.Services.InitializeEntityCoreSchemaAsync() after Build() when the host lets the package manage the schema. It runs EnsureCreatedAsync(), upgrades the pre-1.0 layout, and adds optional tables and catalog columns introduced later. Use EF Core migrations instead when the host owns its schema.

Registration

using CrestApps.Core;
using CrestApps.Core.AI;
using CrestApps.Core.AI.Chat;
using CrestApps.Core.AI.Documents;
using CrestApps.Core.Data.EntityCore;

builder.Services.AddControllersWithViews()
    .AddCrestAppsStoreCommitterFilter();

builder.Services.AddCrestAppsCore(crestApps => crestApps
    .AddAISuite(ai => ai
        .AddEntityCoreStores()
        .AddChatInteractions(chat => chat.AddEntityCoreStores())
        .AddDocumentProcessing(documents => documents.AddEntityCoreStores())
        .AddAIMemory(memory => memory.AddEntityCoreStores())
        .AddPersonas(personas => personas.AddEntityCoreStores())
        .AddToolInstances(tools => tools.AddEntityCoreStores()))
    .AddIndexingServices(indexing => indexing.AddEntityCoreStores())
    .AddEntityCoreDataStore(
        options => options.UseNpgsql(builder.Configuration.GetConnectionString("CrestApps")),
        store => store.TablePrefix = "App_"));

builder.Services.AddCoreWebCrawlerStoresEntityCore();
builder.Services.AddCoreFileSourceStoresEntityCore();