QuickDBS.MySQL
1.0.0
See the version list below for details.
dotnet add package QuickDBS.MySQL --version 1.0.0
NuGet\Install-Package QuickDBS.MySQL -Version 1.0.0
<PackageReference Include="QuickDBS.MySQL" Version="1.0.0" />
paket add QuickDBS.MySQL --version 1.0.0
#r "nuget: QuickDBS.MySQL, 1.0.0"
// Install QuickDBS.MySQL as a Cake Addin
#addin nuget:?package=QuickDBS.MySQL&version=1.0.0
// Install QuickDBS.MySQL as a Cake Tool
#tool nuget:?package=QuickDBS.MySQL&version=1.0.0
QuickDBS.MySQL
Note: .NET Standard 2.1 Library
Open or Create and Open MySql connection to the database. You can pass a direct connection string or provide a database name, root password and a flag to either create database if it isn't exists.
var db = new QuickDBS.MySQL("your connection string here");
or
var db = new QuickDBS.MySQL("databasename", "rootpassword", true);
Create a table from a Person class. The result will be true if created and false if failed or not-created.
public class Person
{
public Int64 Id { get; set; }
public string Name { get; set; }
public double Income { get; set; }
public DateTime DateOfBirth { get; set; }
}
var result = db.CreateTable<Person>();
Create a Person record in the Person table create above. The result will be the last insert Id of the table which will be unique.
var id = db.Create<Person>(new Person {
Name = "Rahul",
Income = 5000,
DateOfBirth = new DateTime(2000, 01, 01)
});
Get the person record having Id = 1 from the Person table.
var person = db.GetById<Person>(1);
person.Name = "Rahul Hadgal";
person.Income = 10000;
Update the income for person selected in the above example, from 5000 to 10000 and change name to Full Name.
var result = db.UpdateById<Person>(person);
Get all records from Person table
var people = db.GetAll<Person>();
Custom Query with conditions
var people = db.Query<dynamic>("SELECT Id, Name, Income FROM Person WHERE
Income >= @MinIncome AND Income <= @MaxIncome",
new { MinIncome = 6000, MaxIncome = 12000 });
Delete a person by Id = 1 from the Person table
var result = db.DeleteById<Person>(1);
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 was computed. 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. |
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. |
-
.NETStandard 2.1
- MySql.Data (>= 8.0.27)
- QuickDBS.Core (>= 1.0.1.2)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.