Database-Agnostic Data Access Framework for .NET
Syrx is a .NET database abstraction framework that decouples your repository code from underlying data stores while emphasizing:
- 🎮 Control - Full developer control over data and execution
- ⚡ Speed - Built on Dapper for maximum performance
- 🔄 Flexibility - Easily switch between database technologies
- 🧪 Testability - Fully testable at all levels
- 🔧 Extensibility - Granular, componentized architecture
- 📖 Readability - Clear, concise code intent
# Choose your database provider
dotnet add package Syrx.SqlServer.Extensions # SQL Server
dotnet add package Syrx.MySql.Extensions # MySQL
dotnet add package Syrx.Npgsql.Extensions # PostgreSQL
dotnet add package Syrx.Oracle.Extensions # Oracle// Program.cs
services.UseSyrx(syrx => syrx
.UseSqlServer(sqlServer => sqlServer
.AddConnectionString("default", connectionString)
.AddCommand<ProductRepository>(commands => commands
.ForMethod(nameof(ProductRepository.GetAllAsync), cmd => cmd
.UseConnectionAlias("default")
.UseCommandText("SELECT * FROM Products")))));public class ProductRepository(ICommander<ProductRepository> commander)
{
private readonly ICommander<ProductRepository> _commander = commander;
public async Task<IEnumerable<Product>> GetAllAsync()
=> await _commander.QueryAsync<Product>();
}Syrx provides a clean separation between your application logic and data access:
┌─────────────────┐ ┌─────────────────┐ ┌─────────────────┐
│ Repository │───▶│ ICommander │───▶│ DatabaseProvider │
│ │ │ │ │ │
│ Business Logic │ │ Query/Execute │ │ SQL Server │
│ │ │ Operations │ │ MySQL/Postgres │
└─────────────────┘ └─────────────────┘ │ Oracle │
└─────────────────┘
| Package | Description | NuGet |
|---|---|---|
| Syrx | Core abstractions and interfaces | |
| Syrx.Settings | Configuration settings and abstractions |  |
| Provider | Package | NuGet |
|---|---|---|
| SQL Server | Syrx.SqlServer.Extensions |  |
| MySQL | Syrx.MySql.Extensions |  |
| PostgreSQL | Syrx.Npgsql.Extensions |  |
| Oracle | Syrx.Oracle.Extensions |  |
Switch between SQL Server, MySQL, PostgreSQL, and Oracle with configuration changes only.
Inherit all of Dapper's performance benefits while gaining additional abstraction layers.
Automatic mapping from method names to SQL commands using [CallerMemberName] attribute.
Handle complex object composition with support for up to 16 input parameters.
Full test coverage with unit and integration tests for all database providers.
- 📖 Wiki - Complete documentation and guides
- 🚀 Getting Started - Installation and setup
- ⚙️ Configuration - Configuration examples
- 🗄️ Database Providers - Provider-specific guides
- 🔄 Migration Guides - Migration from other frameworks
- 💬 Discussions - Ask questions and share ideas
- 🐛 Issues - Report bugs and request features
- 📋 Projects - View roadmap and progress
services.UseSyrx(syrx => syrx
.UseSqlServer(sql => sql.AddConnectionString("primary", sqlConnection))
.UseNpgsql(pg => pg.AddConnectionString("analytics", pgConnection)));public async Task<IEnumerable<Order>> GetOrdersWithCustomersAsync()
=> await _commander.QueryAsync<Order, Customer, Order>(
(order, customer) => { order.Customer = customer; return order; });public async Task<bool> TransferInventoryAsync(int fromId, int toId, int quantity)
=> await _commander.ExecuteAsync(new { fromId, toId, quantity });We welcome contributions! Please see our Contributing Guide for details.
- Clone the repository
- Install .NET 8.0+ SDK
- Run
dotnet restore - Run
dotnet testto verify setup
This project is licensed under the MIT License - see the LICENSE file for details.
- Built on top of the excellent Dapper micro-ORM
- Inspired by the need for flexible, testable data access patterns
- Community feedback and contributions that make this framework better
Get Started • View Examples • Browse Packages
Made with ❤️ by the Syrx community