RepoDb 1.1.3

The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org. Prefix Reserved
There is a newer version of this package available.
See the version list below for details.
The owner has unlisted this package. This could mean that the package is deprecated, has security vulnerabilities or shouldn't be used anymore.
dotnet add package RepoDb --version 1.1.3
NuGet\Install-Package RepoDb -Version 1.1.3
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="RepoDb" Version="1.1.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add RepoDb --version 1.1.3
#r "nuget: RepoDb, 1.1.3"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install RepoDb as a Cake Addin
#addin nuget:?package=RepoDb&version=1.1.3

// Install RepoDb as a Cake Tool
#tool nuget:?package=RepoDb&version=1.1.3

Why RepoDb

  • Only 30 seconds to Setup.
  • Massive ORM Operation supports.
  • Seriously fast because of IL.
  • Less Code and Fluent.
  • Unique and Developer Friendly Expression Tree.

Documentation

Click here for the complete documentation.

Snippets

Write less optimal codes.

Query Operation:

var repository = new DbRepository<SqlConnection>(@"Server=.;Database=Northwind;Integrated Security=SSPI;");
var customer = repository.Query<Customer>(new { Id = 10045 });

Or

var repository = new DbRepository<SqlConnection>(@"Server=.;Database=Northwind;Integrated Security=SSPI;");
var customer = repository.Query<Customer>(new
{
	LastName = { Operation = Operation.Like, Value = "Ander%" },
	top: 100,
	orderBy: OrderField.Parse(new { FirstName = Order.Ascending, BirtDate = Order.Descending })
});

Insert Operation:

var repository = new DbRepository<SqlConnection>(@"Server=.;Database=Northwind;Integrated Security=SSPI;");
var customerId = repository.Insert(new Customer { Name = "Anna Fullerton", CreatedDate = DateTime.UtcNow });

Update Operation:

var repository = new DbRepository<SqlConnection>(@"Server=.;Database=Northwind;Integrated Security=SSPI;");
var customer = repository.Query<Customer>(new { Id = 10045 });
customer.Name = "Anna Fullerton";
customer.UpdateDate = DateTime.UtcNow;
var affectedRows = repository.Update(customer);

Inline Operation:

var repository = new DbRepository<SqlConnection>(@"Server=.;Database=Northwind;Integrated Security=SSPI;");
var affectedRows = repository.InlineUpdate<Customer>(new
{
	Name = "Anna Fullerton", UpdatedDate = DateTime.UtcNow
},
new { Id = 10045 };

Delete Operation:

var repository = new DbRepository<SqlConnection>(@"Server=.;Database=Northwind;Integrated Security=SSPI;");
var affectedRows = repository.Update<Customer>(new { Id = 10045 };

Merge Operation:

var repository = new DbRepository<SqlConnection>(@"Server=.;Database=Northwind;Integrated Security=SSPI;");
var customer = repository.Query<Customer>(new { Id = 10045 });
customer.Name = "Anna Albert Fullerton";
var affectedRows = repository.Merge(customer, Field.Parse(new { customer.Id } ));
There are no supported framework assets in this package.

Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

NuGet packages (17)

Showing the top 5 NuGet packages that depend on RepoDb:

Package Downloads
RepoDb.SqlServer The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

A hybrid .NET ORM library for SQL Server.

RepoDb.SqlServer.BulkOperations The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

An extension library that contains the official Bulk Operations of RepoDb for SQL Server.

RepoDb.PostgreSql The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

A hybrid .NET ORM library for PostgreSQL.

RepoDb.MySql The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

A hybrid .NET ORM library for MySQL (using MySql.Data).

RepoDb.PostgreSql.BulkOperations The ID prefix of this package has been reserved for one of the owners of this package by NuGet.org.

An extension library that contains the official Bulk Operations of RepoDb for PostgreSQL.

GitHub repositories (6)

Showing the top 5 popular GitHub repositories that depend on RepoDb:

Repository Stars
mikependon/RepoDB
A hybrid ORM library for .NET.
itlibrium/DDD-starter-dotnet
Sample implementation and comparison of various approaches to building DDD applications. Useful as a baseline to quickly start a DDD dot net project.
TortugaResearch/DotNet-ORM-Cookbook
This repository is meant to show how to perform common tasks using C# with variety of ORMs.
bcssov/IronyModManager
Mod Manager for Paradox Games. Official Discord: https://discord.gg/t9JmY8KFrV
FransBouma/RawDataAccessBencher
Bench code which tests entity materialization speed of various .NET data access / ORM implementations
Version Downloads Last updated
1.13.2-alpha1 485 2/26/2024
1.13.1 123,315 3/16/2023
1.13.0 70,123 11/2/2022
1.12.10 300,494 2/18/2022
1.12.9 30,401 9/27/2021
1.12.8 80,931 9/23/2021
1.12.7 167,853 2/6/2021
1.12.6 4,523 1/13/2021
1.12.5 9,598 12/30/2020
1.12.4 67,552 10/3/2020
1.12.3 3,036 9/29/2020
1.12.2 1,279 9/28/2020
1.12.1 1,346 9/25/2020
1.12.0 4,362 9/24/2020
1.3.2-alpha1 252 2/26/2024

- Built on a target framework 4.0 for earlier compatibility
     - Renamed CacheItem.Timestamp to CacheItem.CreatedDate
     - Added CacheItem.IsExpired method
     - Added CacheItem.Expiration property
     - Removed ICacheItem
     - Removed ITraceLog
     - Removed ICancellableTraceLog
     - Removed ITypeMap
     - Removed IStatementBuilderMap
     - Removed IQueryGroup
     - Removed IQueryField
     - Removed IParameter
     - Removed IField
     - Removed IOrderField
     - Removed IDataEntityMap
     - Removed IQueryBuilder
     - Removed IDbRepository
     - Removed IBaseRepository