PulseTrade.Comm.ACL.SqlServer 0.1.0-alpha2

.NET 10.0 This package targets .NET 10.0. The package is compatible with this framework or higher.
This is a prerelease version of PulseTrade.Comm.ACL.SqlServer. 
dotnet add package PulseTrade.Comm.ACL.SqlServer --version 0.1.0-alpha2
                    


                    

                
NuGet\Install-Package PulseTrade.Comm.ACL.SqlServer -Version 0.1.0-alpha2
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="PulseTrade.Comm.ACL.SqlServer" Version="0.1.0-alpha2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="PulseTrade.Comm.ACL.SqlServer" Version="0.1.0-alpha2" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="PulseTrade.Comm.ACL.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 PulseTrade.Comm.ACL.SqlServer --version 0.1.0-alpha2
                    


                    

                
#r "nuget: PulseTrade.Comm.ACL.SqlServer, 0.1.0-alpha2"
#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. 
#:package PulseTrade.Comm.ACL.SqlServer@0.1.0-alpha2
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=PulseTrade.Comm.ACL.SqlServer&version=0.1.0-alpha2&prerelease
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=PulseTrade.Comm.ACL.SqlServer&version=0.1.0-alpha2&prerelease
                    


                            Install as a Cake Tool

PulseTrade.Comm.ACL.SqlServer

PulseTrade.Comm.ACL.SqlServer is the SQL Server active ACL policy snapshot provider for PulseTrade.Comm.ACL.Core.

It keeps PulseTrade.Comm.ACL.Core free of SQL dependencies. Hosts save an AclPolicyConfig as a text-profile JSON document and load it back before strict decoding through AclFCell2.decodePolicySnapshot.

Production Rule

Production hosts must not fallback to AclPolicyConfig.demo() when this provider is selected. Missing or invalid active policy is a startup/configuration failure.

Connection strings or SQL passwords must be resolved from encrypted files before calling AclSqlServerProviderConfig.create; do not pass production secrets via environment variables.

DDL

Default schema is dbo; default table is AclPolicySnapshot. Since 0.1.0-alpha2, primary-key and index names are scoped by schema/table plus a stable hash so multiple ACL policy tables can coexist in the same schema for live verification and staged rollout.

CREATE TABLE [dbo].[AclPolicySnapshot](
    Revision NVARCHAR(256) NOT NULL CONSTRAINT PK_dbo_AclPolicySnapshot_<scopeHash>_Revision PRIMARY KEY,
    DeploymentProfile NVARCHAR(64) NOT NULL,
    IsActive BIT NOT NULL,
    PolicyJson NVARCHAR(MAX) NOT NULL,
    CreatedAtUtc DATETIMEOFFSET(7) NOT NULL,
    UpdatedAtUtc DATETIMEOFFSET(7) NOT NULL
);

CREATE INDEX IX_dbo_AclPolicySnapshot_<scopeHash>_Active
ON [dbo].[AclPolicySnapshot](IsActive, UpdatedAtUtc DESC);

PolicyJson uses ptc.acl.config.v1 with deploymentProfile serialized as text: LocalDev, PrivateLan, or Public.

Product 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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

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.1.0-alpha2 40 7/1/2026