Akka.Persistence.Sql 1.5.2-beta1

• .NETStandard 2.0

  • Akka.Persistence.Query (>= 1.5.2)
  • Akka.Streams (>= 1.5.2)
  • LanguageExt.Core (>= 4.4.2)
  • linq2db (>= 5.1.1)
  • Microsoft.Bcl.HashCode (>= 1.1.1)
  • System.Linq.Async (>= 6.0.1)
  • System.Reactive.Linq (>= 5.0.0)

> **NOTE: This beta release is intended for greenfield projects only.**
>
> Until backward compatibility is properly tested and documented, it is recommended to use this plugin only on new greenfield projects that does not rely on existing persisted data.
Akka.Persistence.Sql is a successor of Akka.Persistence.Linq2Db. It is being retooled to provide a better inter-compatibility with other SQL based Akka.Persistence plugin family.
Currently supported database family:
Microsoft SQL Server
MS SQLite
System.Data.SQLite
PostgreSQL using binary payload
Akka.Hosting Extension Setup**
Assuming a MS SQL Server 2019 setup:
```csharp
var host = new HostBuilder()
.ConfigureServices((context, services) => {
services.AddAkka("my-system-name", (builder, provider) =>
{
builder.WithSqlPersistence(
connectionString: _myConnectionString,
providerName: ProviderName.SqlServer2019)
});
})
```
ProviderName is a string constant defining the database type to connect to, valid values are defined inside `LinqToDB.ProviderName` static class. Refer to the Members of [`LinqToDb.ProviderName`](https://linq2db.github.io/api/LinqToDB.ProviderName.html) for included providers.
HOCON Configuration Setup**
```hocon
akka.persistence {
journal {
plugin = "akka.persistence.journal.sql"
sql {
connection-string = "{database-connection-string}"
provider-name = "{provider-name}"
}
}
snapshot-store {
plugin = "akka.persistence.snapshot-store.sql"
sql {
connection-string = "{database-connection-string}"
provider-name = "{provider-name}"
}
}
}
```
database-connection-string**: The proper connection string to your database of choice.
provider-name**: A string constant defining the database type to connect to, valid values are defined inside `LinqToDB.ProviderName` static class. Refer to the Members of [`LinqToDb.ProviderName`](https://linq2db.github.io/api/LinqToDB.ProviderName.html) for included providers.