PulseTrade.Comm.Login.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.Login.SqlServer.
There is a newer prerelease version of this package available.
See the version list below for details. 
dotnet add package PulseTrade.Comm.Login.SqlServer --version 0.1.0-alpha2
                    


                    

                
NuGet\Install-Package PulseTrade.Comm.Login.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.Login.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.Login.SqlServer" Version="0.1.0-alpha2" />
                    


                            Directory.Packages.props
                        

                    

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


                    

                
#r "nuget: PulseTrade.Comm.Login.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.Login.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.Login.SqlServer&version=0.1.0-alpha2&prerelease
                    


                            Install as a Cake Addin
                        

                    

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


                            Install as a Cake Tool

PulseTrade.Comm.Login.SqlServer

PulseTrade.Comm.Login.SqlServer is the SQL Server durable session-store provider for PulseTrade.Comm.Login.Core.

Journal / Snapshot / DB

This package does not use Akka.Persistence journal or snapshot-store tables. It owns one SQL Server table in the caller-selected database.

Current database selection:

  • LoginSqlServerProviderConfig.create connectionString uses the database in the supplied connection string.
  • LoginSqlServerProviderConfig.fromEnvironment envName reads the connection string from an environment variable.
  • EnsureDatabase=false by default; set withEnsureDatabase true only when the host wants this package to create the database from Initial Catalog.
  • Schema="dbo" by default; override with withSchema.

Current DDL:

CREATE TABLE [dbo].[LoginSession](
    SessionId NVARCHAR(256) NOT NULL CONSTRAINT PK_LoginSession PRIMARY KEY,
    AccessTokenHash CHAR(64) NOT NULL,
    RefreshTokenHash CHAR(64) NOT NULL,
    PrincipalId NVARCHAR(256) NOT NULL,
    Provider NVARCHAR(128) NOT NULL,
    ExpiresAtUtc DATETIMEOFFSET(7) NOT NULL,
    RefreshExpiresAtUtc DATETIMEOFFSET(7) NOT NULL,
    Revoked BIT NOT NULL,
    RecordJson NVARCHAR(MAX) NOT NULL,
    UpdatedAtUtc DATETIMEOFFSET(7) NOT NULL,
    InsertedAtUtc DATETIMEOFFSET(7) NOT NULL
);

CREATE INDEX IX_LoginSession_AccessTokenHash ON [dbo].[LoginSession](AccessTokenHash);
CREATE INDEX IX_LoginSession_RefreshTokenHash ON [dbo].[LoginSession](RefreshTokenHash);
CREATE INDEX IX_LoginSession_Principal ON [dbo].[LoginSession](PrincipalId, Provider);

RecordJson uses ptc.login.session-store.snapshot.v1 row JSON from PulseTrade.Comm.Login.Core.LoginSessionRecordJson. Token hashes are indexed for lookup; the full opaque tokens remain inside RecordJson, so the database is sensitive runtime state. Runtime DDL quotes schema identifiers and SQL string literals before generating OBJECT_ID / CREATE TABLE statements.

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-alpha3 61 7/2/2026
0.1.0-alpha2 58 6/30/2026
0.1.0-alpha1 54 6/30/2026