Providers

Supported Providers

One programming model across different data technologies.

Each data provider is its own package that translates the common ARX.SDK programming model into the operations its database supports. Below are the providers, in the order they are being worked on, and how far along each one is. The five built ones are on nuget.org as 1.0.0-rc.1; SQLite is planned.

PostgreSQLPreviewThe reference provider. Create, Retrieve, Update, Delete and Execute are built on the shared ARX.SDK model, covered by automated tests, and documented with samples that were built and run against PostgreSQL.PostgreSQLARX.SDK.PostgreSqlSQL ServerPreviewCreate, Retrieve, Update, Delete and Execute are built on the shared ARX.SDK model, covered by automated tests, and documented with samples that were built and run against SQL Server 2022.Microsoft SQL ServerARX.SDK.SQLMySQLPreviewCreate, Retrieve, Update, Delete and Execute are built on the shared ARX.SDK model and MySqlConnector, covered by automated tests, and documented with samples that were built and run against MySQL 8.4.MySQLARX.SDK.MySQLMongoDBPreviewCreate, Retrieve, Update and Delete are built on the shared ARX.SDK model and the MongoDB C# driver, covered by automated tests, and documented with samples that were built and run against MongoDB 7.0 (a replica set). MongoDB has no stored procedures, so there is no Execute.MongoDBARX.SDK.MongoDbDynamoDBPreviewCreate, Retrieve, Update and Delete are built on the shared ARX.SDK model and the AWS SDK for .NET, in both designs (a table per entity, and the single-table design with key templates, secondary indexes and write sharding), covered by automated tests, and documented with samples that were built and run against DynamoDB Local. DynamoDB has no stored procedures, so there is no Execute.Amazon DynamoDBARX.SDK.DynamoDbSQLitePlannedOn the roadmap: a sixth provider, built like the others on the shared ARX.SDK model, tested against the shared conformance suite, benchmarked, and documented with verified samples.SQLiteARX.SDK.Sqlite

What the statuses mean

Preview
On nuget.org as a preview (1.0.0-rc.1): implemented on the shared model, tested against its database, and documented with samples verified against the published package. The API may still change before 1.0.
Port pending
Code exists from earlier work, but it still has to be moved onto the shared model and tested.
Planned
On the roadmap; no ARX.SDK implementation yet.

What each provider's documentation covers

As each provider is completed, its section explains:

  • Provider-specific installation
  • Configuration
  • Supported operations
  • Provider-specific capabilities
  • Limitations and considerations
  • Runnable examples

Every provider has its setup instructions, runnable samples for its operations, its data types and its error codes: PostgreSQL, SQL Server, MySQL, MongoDB and DynamoDB. What each one can do is on the Capabilities page.