MgSoftDev.KnowledgeHub.Storage.SqlServer
0.19.3-preview.1
dotnet add package MgSoftDev.KnowledgeHub.Storage.SqlServer --version 0.19.3-preview.1
NuGet\Install-Package MgSoftDev.KnowledgeHub.Storage.SqlServer -Version 0.19.3-preview.1
<PackageReference Include="MgSoftDev.KnowledgeHub.Storage.SqlServer" Version="0.19.3-preview.1" />
<PackageVersion Include="MgSoftDev.KnowledgeHub.Storage.SqlServer" Version="0.19.3-preview.1" />
<PackageReference Include="MgSoftDev.KnowledgeHub.Storage.SqlServer" />
paket add MgSoftDev.KnowledgeHub.Storage.SqlServer --version 0.19.3-preview.1
#r "nuget: MgSoftDev.KnowledgeHub.Storage.SqlServer, 0.19.3-preview.1"
#:package MgSoftDev.KnowledgeHub.Storage.SqlServer@0.19.3-preview.1
#addin nuget:?package=MgSoftDev.KnowledgeHub.Storage.SqlServer&version=0.19.3-preview.1&prerelease
#tool nuget:?package=MgSoftDev.KnowledgeHub.Storage.SqlServer&version=0.19.3-preview.1&prerelease
MgSoftDev.KnowledgeHub.Storage.SqlServer
Storage provider SQL Server para KnowledgeHub. Las tablas del módulo viven dentro de la
base de datos anfitriona, en un esquema propio (default kh) y/o con prefijo de tabla.
services.AddKnowledgeHubSqlServerStore(connectionString,
o => { o.Schema = "kh"; o.TablePrefix = ""; });
Instalación de las tablas
El DDL es un script idempotente embebido (UTF-8 con BOM), parametrizado por schema/prefijo:
// Opción A: aplicarlo al arrancar (la BD debe existir)
await KnowledgeHubSqlSchema.EnsureDatabaseObjectsAsync(connectionString, options);
// Opción B: obtener el script y ejecutarlo en tu pipeline de migraciones/DBA
var script = KnowledgeHubSqlSchema.GetCreateScript(options).Value;
Las PKs se generan en cliente (Guid.CreateVersion7()); el DDL conserva
DEFAULT NEWSEQUENTIALID()/GETDATE() solo como red de seguridad para INSERTs manuales.
Soporta edición concurrente multi-equipo (la publicación es transaccional con detección de
conflicto optimista).
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
-
net10.0
- MgSoftDev.KnowledgeHub.Storage.EntityFramework (>= 0.19.3-preview.1)
- Microsoft.EntityFrameworkCore.SqlServer (>= 10.0.10)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last Updated |
|---|---|---|
| 0.19.3-preview.1 | 34 | 8/15/2026 |
| 0.19.2-preview.1 | 33 | 8/15/2026 |
| 0.19.1-preview.1 | 28 | 8/15/2026 |
| 0.19.0-preview.1 | 32 | 8/15/2026 |
| 0.18.0-preview.1 | 43 | 8/14/2026 |
| 0.17.0-preview.1 | 40 | 8/14/2026 |
| 0.16.0-preview.1 | 32 | 8/13/2026 |
| 0.15.0-preview.1 | 37 | 8/13/2026 |
| 0.14.0-preview.1 | 44 | 8/13/2026 |
| 0.13.0-preview.1 | 42 | 8/13/2026 |
| 0.12.0-preview.1 | 50 | 8/12/2026 |
| 0.11.0-preview.1 | 45 | 8/11/2026 |
| 0.10.0-preview.1 | 36 | 8/11/2026 |
| 0.9.1-preview.1 | 39 | 8/11/2026 |
| 0.9.0-preview.1 | 34 | 8/11/2026 |
| 0.8.0-preview.1 | 60 | 8/7/2026 |
| 0.7.1-preview.1 | 61 | 8/4/2026 |
| 0.7.0-preview.1 | 53 | 8/4/2026 |
| 0.6.0-preview.1 | 58 | 7/26/2026 |
| 0.5.0-preview.1 | 58 | 7/26/2026 |