RepoDb.SqlServer
1.15.0
Prefix Reserved
dotnet add package RepoDb.SqlServer --version 1.15.0
NuGet\Install-Package RepoDb.SqlServer -Version 1.15.0
<PackageReference Include="RepoDb.SqlServer" Version="1.15.0" />
<PackageVersion Include="RepoDb.SqlServer" Version="1.15.0" />
<PackageReference Include="RepoDb.SqlServer" />
paket add RepoDb.SqlServer --version 1.15.0
#r "nuget: RepoDb.SqlServer, 1.15.0"
#:package RepoDb.SqlServer@1.15.0
#addin nuget:?package=RepoDb.SqlServer&version=1.15.0
#tool nuget:?package=RepoDb.SqlServer&version=1.15.0
RepoDb.SqlServer — RepoDB for SQL Server
The SQL Server provider for RepoDB — a fast, lightweight .NET ORM that lets you use raw SQL and fluent operations side by side on the same connection.
Important Pages
- GitHub Home — core library and source code.
- Website — full documentation, API reference, and blog.
Community
- GitHub Issues — bug reports and feature requests.
- StackOverflow — technical questions.
- Microsoft Teams — live Q&A.
- X / Twitter — news and updates.
Dependencies
- Microsoft.Data.SqlClient — SQL Server data provider.
- RepoDb — the RepoDB core library.
License
Apache-2.0 — Copyright © 2020 Michael Camara Pendon
Installation
Install-Package RepoDb.SqlServer
Or visit the installation page for more options.
Get Started
Initialize the bootstrapper once at application startup:
RepoDb.SqlServerBootstrap.Initialize();
Then use any RepoDB operation directly on your SqlConnection:
Query
using (var connection = new SqlConnection(ConnectionString))
{
var customer = connection.Query<Customer>(c => c.Id == 10045);
}
Insert
var customer = new Customer
{
FirstName = "John",
LastName = "Doe",
IsActive = true
};
using (var connection = new SqlConnection(ConnectionString))
{
var id = connection.Insert<Customer>(customer);
}
Update
using (var connection = new SqlConnection(ConnectionString))
{
var customer = connection.Query<Customer>(10045);
customer.FirstName = "John";
customer.LastUpdatedUtc = DateTime.UtcNow;
var affectedRows = connection.Update<Customer>(customer);
}
Delete
using (var connection = new SqlConnection(ConnectionString))
{
var customer = connection.Query<Customer>(10045);
var deletedCount = connection.Delete<Customer>(customer);
}
Visit the get-started page for the full SQL Server guide.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 is compatible. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
| .NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
| .NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
| MonoAndroid | monoandroid was computed. |
| MonoMac | monomac was computed. |
| MonoTouch | monotouch was computed. |
| Tizen | tizen40 was computed. tizen60 was computed. |
| Xamarin.iOS | xamarinios was computed. |
| Xamarin.Mac | xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.0
- Microsoft.Data.SqlClient (>= 7.0.2)
- RepoDb (>= 1.15.0)
-
net10.0
- Microsoft.Data.SqlClient (>= 7.0.2)
- RepoDb (>= 1.15.0)
-
net8.0
- Microsoft.Data.SqlClient (>= 7.0.2)
- RepoDb (>= 1.15.0)
-
net9.0
- Microsoft.Data.SqlClient (>= 7.0.2)
- RepoDb (>= 1.15.0)
NuGet packages (16)
Showing the top 5 NuGet packages that depend on RepoDb.SqlServer:
| Package | Downloads |
|---|---|
|
RepoDb.SqlServer.BulkOperations
An extension library that contains the official Bulk Operations of RepoDB for SQL Server. |
|
|
Dominisoft.Nokates.Common
Common Library to create a microservice to run on a nokates management system |
|
|
GraphQL.RepoDb.SqlServer
A set of extensions for working with HotChocolate GraphQL and RepoDb as the data access micro-orm without dependency on IQueryable. This enables fully encapsulated control over SQL queries in every way within a Service or Repository layer of your application. This extension pack provides a significantly simplified facade to access critial elements such as Selections/Projections, Sort arguments, & Paging arguments with support for mapping them to Models using built in RepoDb functionality. It also leverages RepoDb to provide a generic, Relay spec compatible, cursor pagination/slice query api for Sql Server. |
|
|
2doit.NopCommerce.Services
2doit NopCommerce API Services/Libraries |
|
|
OSU2Helper
A library for OSU2 Microservices Architect Solution |
GitHub repositories (4)
Showing the top 4 popular GitHub repositories that depend on RepoDb.SqlServer:
| Repository | Stars |
|---|---|
|
DapperLib/Dapper
Dapper - a simple object mapper for .Net
|
|
|
mixcore/mix.core
🚀 A future-proof enterprise web CMS supporting both headless and decoupled approaches. Build any type of app with customizable APIs on ASP.NET Core/.NET Core. Completely open-source and designed for flexibility. Since 2018.
|
|
|
TortugaResearch/DotNet-ORM-Cookbook
This repository is meant to show how to perform common tasks using C# with variety of ORMs.
|
|
|
FransBouma/RawDataAccessBencher
Bench code which tests entity materialization speed of various .NET data access / ORM implementations
|
| Version | Downloads | Last Updated |
|---|---|---|
| 1.15.0 | 61 | 7/18/2026 |
| 1.15.0-telemetry | 32 | 7/18/2026 |
| 1.14.0 | 3,595 | 6/28/2026 |
| 1.13.2-alpha1 | 6,049 | 2/26/2024 |
| 1.13.1 | 611,823 | 3/16/2023 |
| 1.13.0 | 54,714 | 11/2/2022 |
| 1.13.0-beta1 | 955 | 10/25/2022 |
| 1.13.0-alpha3 | 893 | 10/24/2022 |
| 1.13.0-alpha2 | 864 | 10/6/2022 |
| 1.13.0-alpha1 | 898 | 9/17/2022 |
| 1.1.5 | 180,773 | 2/18/2022 |
| 1.1.4 | 80,120 | 9/23/2021 |
| 1.1.3 | 141,383 | 2/6/2021 |
| 1.1.2 | 7,573 | 12/30/2020 |