crestapps-core-data-storage

CrestApps.Core Data Storage

You are a CrestApps.Core expert. Help the host choose a backend and register exactly the stores each enabled feature needs.

Guidelines

• Choose Entity Framework Core when the host already uses EF Core or wants any EF relational provider. Choose YesSql when the host wants a document store with collections and map indexes (as Orchard Core does).
• Register the backing store once on the root builder: .AddEntityCoreSqliteDataStore(...) / .AddEntityCoreDataStore(...), or .AddYesSqlDataStore(...). The per-feature Add*Stores() calls only select stores; they never create the DbContext or IStore.
• Call the store method on every feature builder you enable. One call does not cover other features.
• Without a store package, connections and deployments come only from configuration and ISearchIndexProfileStore falls back to a null store, but nothing registers IAIProfileStore, the chat session stores, or the ChatInteraction catalog. Register a store before resolving IAIProfileManager, chat sessions, or Chat Interactions.
• Every write path needs a commit boundary (IStoreCommitter); see crestapps-core-foundations.
• Create the schema before serving requests: InitializeEntityCoreSchemaAsync() for EF Core, or the Create*IndexSchemaAsync extensions for YesSql.

Entity Framework Core

using CrestApps.Core;
using CrestApps.Core.AI;
using CrestApps.Core.AI.A2A;
using CrestApps.Core.AI.Chat;
using CrestApps.Core.AI.Documents;
using CrestApps.Core.AI.Documents.OpenXml;
using CrestApps.Core.AI.Documents.Pdf;
using CrestApps.Core.AI.Mcp;
using CrestApps.Core.AI.OpenAI;
using CrestApps.Core.Data.EntityCore;

Directory.CreateDirectory(Path.Combine(builder.Environment.ContentRootPath, "App_Data"));

builder.Services.AddCrestAppsCore(crestApps => crestApps
    .AddAISuite(ai => ai
        .AddEntityCoreStores()
        .AddOpenAI()
        .AddChatInteractions(chat => chat.AddEntityCoreStores())
        .AddDocumentProcessing(documents => documents
            .AddEntityCoreStores()
            .AddOpenXml()
            .AddPdf())
        .AddAIMemory(memory => memory.AddEntityCoreStores())
        .AddPersonas(personas => personas.AddEntityCoreStores())
        .AddToolInstances(tools => tools.AddEntityCoreStores())
        .AddA2AClient(a2a => a2a.AddEntityCoreStores())
        .AddMcpClient(mcp => mcp.AddEntityCoreStores())
        .AddMcpServer(mcp => mcp.AddEntityCoreStores()))
    .AddIndexingServices(indexing => indexing.AddEntityCoreStores())
    .AddEntityCoreSqliteDataStore(
        $"Data Source={Path.Combine(builder.Environment.ContentRootPath, "App_Data", "crestapps.db")}"));

// Features registered on IServiceCollection
builder.Services.AddCoreWebCrawlerStoresEntityCore();
builder.Services.AddCoreFileSourceStoresEntityCore();

var app = builder.Build();
await app.Services.InitializeEntityCoreSchemaAsync();