Endatix.Persistence.SqlServer 0.4.1

dotnet add package Endatix.Persistence.SqlServer --version 0.4.1
                    
NuGet\Install-Package Endatix.Persistence.SqlServer -Version 0.4.1
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Endatix.Persistence.SqlServer" Version="0.4.1" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Endatix.Persistence.SqlServer" Version="0.4.1" />
                    
Directory.Packages.props
<PackageReference Include="Endatix.Persistence.SqlServer" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Endatix.Persistence.SqlServer --version 0.4.1
                    
#r "nuget: Endatix.Persistence.SqlServer, 0.4.1"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#addin nuget:?package=Endatix.Persistence.SqlServer&version=0.4.1
                    
Install Endatix.Persistence.SqlServer as a Cake Addin
#tool nuget:?package=Endatix.Persistence.SqlServer&version=0.4.1
                    
Install Endatix.Persistence.SqlServer as a Cake Tool

Endatix.Persistence.SqlServer

Adds support for using Microsoft SQL Server database persistence with the Endatix Platform. This package is crucial for applications that require SQL Server as the primary database.

Endatix Platform is an open-source data collection and management library for .NET. It is designed for building secure, scalable, and integrated form-centric applications that work with SurveyJS. Endatix empowers business users with advanced workflows, automation, and meaningful insights.

Installation:

dotnet add package Endatix.Persistence.SqlServer

More Information:

For detailed installation instructions, please visit Endatix Installation Guide.

Generating Migrations

Please note to change the name of the migration for the respective context. This KB is WIP and is subject to change as the process evolves to simplify migrations tooling and process

For AppDbContext Entities

## For MS SQL Server
dotnet ef migrations add InitialEntities --startup-project src/Endatix.WebHost --project src/Endatix.Persistence.SqlServer  --context AppDbContext --output-dir Migrations/AppEntities

For AppIdentityDbContext Entities

## For MS SQL Server
dotnet ef migrations add InitialIdentity --startup-project src/Endatix.WebHost --project src/Endatix.Persistence.SqlServer  --context AppIdentity

Setup

  1. Create SQL Server in Docker - docker run --name sqlserver_db -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=admin@2admin" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2019-latest
  2. Update appSettings.Development.json by adding this connection string
"DefaultConnection": "Server=localhost;Initial Catalog=endatix-db; User ID=sa; Password=admin@2admin; TrustServerCertificate=True",
"DefaultConnection_DbProvider": "SqlServer" // Config first db provider setter. Not required if you configure the DB Provider via c# code.
Product Compatible and additional computed target framework versions.
.NET net9.0 is compatible.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (2)

Showing the top 2 NuGet packages that depend on Endatix.Persistence.SqlServer:

Package Downloads
Endatix.Extensions.Hosting

Provides useful extension methods and utilities for hosting the Endatix Platform. It simplifies the configuration and deployment. Endatix Platform is an open-source data collection and management library for .NET.

Endatix.Hosting

Package Description

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
0.4.1 114 5/9/2025
0.4.0 119 4/25/2025
0.3.0 144 3/27/2025
0.2.0 132 2/10/2025
0.1.0 1,477 8/23/2024