RepoDb.MySql 1.16.0-beta1

Prefix Reserved
.NET 8.0 This package targets .NET 8.0. The package is compatible with this framework or higher. .NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher.
This is a prerelease version of RepoDb.MySql. 
dotnet add package RepoDb.MySql --version 1.16.0-beta1
                    


                    

                
NuGet\Install-Package RepoDb.MySql -Version 1.16.0-beta1
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.MySql" Version="1.16.0-beta1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="RepoDb.MySql" Version="1.16.0-beta1" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="RepoDb.MySql" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add RepoDb.MySql --version 1.16.0-beta1
                    


                    

                
#r "nuget: RepoDb.MySql, 1.16.0-beta1"
#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. 
#:package RepoDb.MySql@1.16.0-beta1
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=RepoDb.MySql&version=1.16.0-beta1&prerelease
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=RepoDb.MySql&version=1.16.0-beta1&prerelease
                    


                            Install as a Cake Tool

MySqlBuild MySqlHome MySqlVersion

RepoDb.MySql — RepoDB for MySQL (MySql.Data)

The MySQL provider for RepoDB — a fast, lightweight .NET ORM that lets you use raw SQL and fluent operations side by side on the same connection. Built on top of RepoDb and MySql.Data.

Important Pages

  • GitHub Home — core library and source code.
  • Website — full documentation, API reference, and blog.

Community

Dependencies

License

Apache-2.0 — Copyright © 2019 Michael Camara Pendon

Installation

Install-Package RepoDb.MySql

Or visit the installation page for more options.

Get Started

Initialize the bootstrapper once at application startup:

RepoDb.MySqlBootstrap.Initialize();

Then use any RepoDB operation directly on your MySqlConnection:

Query

using (var connection = new MySqlConnection(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 MySqlConnection(ConnectionString))
{
	var id = connection.Insert<Customer>(customer);
}

Update

using (var connection = new MySqlConnection(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 MySqlConnection(ConnectionString))
{
	var customer = connection.Query<Customer>(10045);
	var deletedCount = connection.Delete<Customer>(customer);
}

ExecuteQuery

using (var connection = new MySqlConnection(ConnectionString))
{
	var customer = connection.ExecuteQuery<Customer>("SELECT * FROM `Customer` WHERE (Id = @Id);", new { Id = 10045 }).FirstOrDefault();
}

ExecuteNonQuery

using (var connection = new MySqlConnection(ConnectionString))
{
	var affectedRows = connection.ExecuteNonQuery("UPDATE `Customer` SET FirstName = @FirstName WHERE (Id = @Id);", new { FirstName = "John", Id = 10045 });
}

ExecuteScalar

using (var connection = new MySqlConnection(ConnectionString))
{
	var count = connection.ExecuteScalar<int>("SELECT COUNT(*) FROM `Customer`;");
}

Visit the get-started page for the full MySQL guide.

Product 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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (2)

Showing the top 2 NuGet packages that depend on RepoDb.MySql:

Package Downloads
Fx.Data.SQL

Package Description
RepoDb.MySql.BulkOperations

An extension library that contains the official Bulk Operations of RepoDB for MySQL (using MySql.Data).

GitHub repositories (1)

Showing the top 1 popular GitHub repositories that depend on RepoDb.MySql:

Repository Stars
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.
Version Downloads Last Updated
1.16.0-beta1 39 8/15/2026
1.16.0-alpha1 89 8/8/2026
1.15.0 1,251 7/18/2026
1.15.0-telemetry 96 7/18/2026
1.14.0 2,810 6/28/2026
1.13.2-alpha1 475 2/26/2024
1.13.1 52,507 3/16/2023
1.13.0 7,643 11/2/2022
1.13.0-beta1 384 10/25/2022
1.13.0-alpha2 364 10/6/2022
1.13.0-alpha1 365 9/17/2022
1.3.2-alpha1 210 2/26/2024
1.1.6 61,568 2/18/2022
1.1.5 11,291 9/23/2021
1.1.5-beta1 436 9/17/2021
1.1.4 33,674 2/6/2021
1.1.3 1,909 12/30/2020
1.1.2 3,690 10/4/2020
1.1.1 986 10/3/2020
Loading failed

http://repodb.net/release/mysql