Yinyang.Utilities.MySql
1.0.1
dotnet add package Yinyang.Utilities.MySql --version 1.0.1
NuGet\Install-Package Yinyang.Utilities.MySql -Version 1.0.1
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="Yinyang.Utilities.MySql" Version="1.0.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Yinyang.Utilities.MySql --version 1.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Yinyang.Utilities.MySql, 1.0.1"
#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 Yinyang.Utilities.MySql as a Cake Addin
#addin nuget:?package=Yinyang.Utilities.MySql&version=1.0.1
// Install Yinyang.Utilities.MySql as a Cake Tool
#tool nuget:?package=Yinyang.Utilities.MySql&version=1.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Yinyang Utilities MySql
MySql, MariaDB Connection Utility for C#.
C#用MySql,MariaDB接続ユーティリティです。
Getting started
Install Yinyang Utilities MySql nuget package.
NuGet パッケージ マネージャーからインストールしてください。
Install-Package Yinyang.Utilities.MySql
Basic Usage
// Init
using var db = new MySqlConnect(ConnectionString);
// Database Open
db.Open();
// Transaction Start
db.BeginTransaction();
// SQL
db.CommandText = "INSERT INTO test VALUES(@id, @value)";
// Add Parameter
db.AddParameter("@id", 1);
db.AddParameter("@value", "abcdefg");
// Execute
if (1 != db.ExecuteNonQuery())
{
// Transaction Rollback
db.Rollback();
return;
}
// Command and Parameter Reset
db.Refresh();
// SQL
db.CommandText = "select * from test where id = @id;";
// Add Parameter
db.AddParameter("@id", 1);
// Execute
var result = db.ExecuteReaderFirst<Entity>();
if (null == result)
{
db.Rollback();
return;
}
// Transaction Commit
db.Commit();
// Database Close
db.Close();
Samples
See Sample project.
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 is compatible. 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 is compatible. 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. |
.NET Core | netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.1 is compatible. |
.NET Framework | net472 is compatible. net48 is compatible. net481 is compatible. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | 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.
-
.NETFramework 4.7.2
- MySql.Data (>= 8.3.0)
-
.NETFramework 4.8
- MySql.Data (>= 8.3.0)
-
.NETFramework 4.8.1
- MySql.Data (>= 8.3.0)
-
.NETStandard 2.1
- MySql.Data (>= 8.3.0)
-
net6.0
- MySql.Data (>= 8.3.0)
-
net7.0
- MySql.Data (>= 8.3.0)
-
net8.0
- MySql.Data (>= 8.3.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.