Dreamine.Database.MySql
1.0.1
dotnet add package Dreamine.Database.MySql --version 1.0.1
NuGet\Install-Package Dreamine.Database.MySql -Version 1.0.1
<PackageReference Include="Dreamine.Database.MySql" Version="1.0.1" />
<PackageVersion Include="Dreamine.Database.MySql" Version="1.0.1" />
<PackageReference Include="Dreamine.Database.MySql" />
paket add Dreamine.Database.MySql --version 1.0.1
#r "nuget: Dreamine.Database.MySql, 1.0.1"
#:package Dreamine.Database.MySql@1.0.1
#addin nuget:?package=Dreamine.Database.MySql&version=1.0.1
#tool nuget:?package=Dreamine.Database.MySql&version=1.0.1
Dreamine.Database.MySql
Dreamine.Database.MySql is the MySQL provider for the Dreamine Database package family.
Package Role
This package implements IDatabaseProvider for MySQL using MySqlConnector.
Dreamine.Database.Abstractions
↑
Dreamine.Database.Core
↑
Dreamine.Database.MySql
Features
- MySQL connection creation
- Backtick identifier quoting
- MySQL type mapping
CREATE DATABASE IF NOT EXISTSduringEnsureDatabaseExists()CREATE TABLE IF NOT EXISTStable creation- CRUD support through the shared
DatabaseProviderBase
Quick Start
using Dreamine.Database.MySql;
var provider = new MySqlDatabaseProvider(
"Server=localhost;Port=3306;Database=dreamine_sample;User ID=root;Password=1234;");
provider.EnsureDatabaseExists();
provider.CreateTable<SampleCustomer>();
provider.Insert(new SampleCustomer
{
Name = "Dreamine",
Role = "Operator",
CreatedAt = DateTime.Now
});
Database Creation Note
EnsureDatabaseExists() connects to the MySQL server without the selected database, creates the database when it is missing, and then later CRUD operations use the original connection string.
The configured account must have permission to create databases. If the account does not have that permission, create the database manually and then run the sample again.
Dependencies
Dreamine.Database.AbstractionsDreamine.Database.CoreMySqlConnector
Target Framework
net8.0
Samples and Tests
- Unit tests:
20_SOURCES/200. Tests/Dreamine.FullKit.Tests/Database - WPF sample:
20_SOURCES/998. DEMO/000. Sample/010. Wpfs/SampleSmart/Pages/PageSub/PageDatabase.xaml
License
MIT License
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | 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 was computed. 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 was computed. 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. |
-
net8.0
- Dreamine.Database.Abstractions (>= 1.0.1)
- Dreamine.Database.Core (>= 1.0.1)
- MySqlConnector (>= 2.4.0)
NuGet packages (1)
Showing the top 1 NuGet packages that depend on Dreamine.Database.MySql:
| Package | Downloads |
|---|---|
|
Dreamine.Database.FullKit
All-in-one meta package for Dreamine Database libraries. Includes Abstractions, Core, and providers for MySQL, Oracle, SQL Server, and SQLite. |
GitHub repositories
This package is not used by any popular GitHub repositories.