SQL Server chat storage for Vermilion (Dapper-based). Automatically initializes/updates the required table schema.
$ dotnet add package DioRed.Vermilion.ChatStorage.SqlServerSQL Server based chat storage for Vermilion.
{
"Vermilion": {
"SqlServer": {
"ConnectionString": "Server=...;Database=...;Trusted_Connection=True;",
"Schema": "dbo",
"TableName": "VermilionChats"
}
}
}
v.ConfigureChatStorage(s => s.UseSqlServer());
Or explicit connection string:
v.ConfigureChatStorage(s => s.UseSqlServer("<CONN_STRING>", o =>
{
o.TableName = "VermilionChats";
o.Schema = "dbo";
}));