BlazorChat.Server.SqlServer 1.0.3

BlazorChat.Server.SqlServer

SQL Server persistence provider for BlazorChat.Server.

✨ 30-Day Free Trial — covered by your BlazorChat.Server trial. No additional license needed.

Replaces in-memory storage with SQL Server persistence for messages and reactions. BlazorChat.Server is installed automatically as a dependency.

🚀 Quick Start

dotnet add package BlazorChat.Server.SqlServer

1. Export & Run SQL Scripts

// Export embedded scripts for DBA review
BlazorChatSqlServerScripts.ExportToFolder(@"C:\temp\BlazorChatScripts");

Execute the exported .sql files against your database using SSMS, Azure Data Studio, or sqlcmd.

2. Add Connection String

appsettings.json:

{ "ConnectionStrings": { "BlazorChatDb": "Server=.;Database=BlazorChatDb;Trusted_Connection=true;TrustServerCertificate=true;" } }

3. Update Program.cs

builder.Services.AddPleromaPersistence(options =>
{
    options.UseSqlServer(builder.Configuration.GetConnectionString("BlazorChatDb"));
});

using BlazorChat.Server.SqlServer.Extensions; 
using DatabaseLibraryMDS; 
using DatabaseLibraryMDS.Interfaces;

var dbConnectionString = builder.Configuration.GetConnectionString("BlazorChatDb") ?? throw new InvalidOperationException("ConnectionStrings:BlazorChatDb is missing.");

// Register DatabaseLibraryMDS 
builder.Services.AddScoped<ISqlServer, SqlServer>( provider => new SqlServer(dbConnectionString));

// Add BlazorChat with SQL Server persistence 
builder.Services.AddBlazorChatSqlServer(builder.Configuration);

// Map the SignalR hub 
app.MapBlazorChatHub();

// Or, if using authentication: // 
// The hub runs anonymously by default. To require auth, map the hub directly:
 app.MapHub<BlazorChat.Server.Hubs.ChatHub>("/chathub").RequireAuthorization();`

 
## 🎯 Features

- **Persistent Messages** — survive server restarts
- **Emoji Reactions** — per-message reactions with summary aggregation
- **Message Editing & Deletion** — soft-delete with restore
- **Exportable SQL Scripts** — review and customize before deployment
- **Azure SQL Compatible** — works with SQL Server 2016+ and Azure SQL Database

## 📋 Database Schema

All objects live in the `chat` schema:

| Object | Type | Purpose |
|--------|------|---------|
| `chat.Messages` | Table | Message storage with thread, sender, edit/delete tracking |
| `chat.Reactions` | Table | Emoji reactions per message (Latin1_General_100_CI_AS_SC collation) |
| `chat.p_AddMessage` | Stored Proc | Insert a message |
| `chat.p_GetMessages` | Stored Proc | Retrieve messages by thread |
| `chat.p_EditMessage` | Stored Proc | Update message text |
| `chat.p_DeleteMessage` | Stored Proc | Soft-delete a message |
| `chat.p_RestoreMessage` | Stored Proc | Undo a soft-delete |
| `chat.p_ToggleReaction` | Stored Proc | Add/remove an emoji reaction |
| `chat.p_GetReactionSummary` | Stored Proc | Reaction summary by timestamp |
| `chat.p_GetReactionSummaryByMessageId` | Stored Proc | Reaction summary by message ID |
| `chat.p_GetReactionSummaries` | Stored Proc | Batch reaction summaries |

## 📦 Prerequisites

- SQL Server 2016+ or Azure SQL Database
- BlazorChat.Server license (30-day trial included)

## 📜 License

Same commercial license as BlazorChat.Server.

- [Purchase](https://loneworx.com/blazor-chat/pricing)

---

**Copyright (C) 2024-2026 LoneWorx LLC** — [loneworx.com](https://loneworx.com)