magic.lambda.mysql 14.0.4

.NET Standard 2.0
Install-Package magic.lambda.mysql -Version 14.0.4
dotnet add package magic.lambda.mysql --version 14.0.4
<PackageReference Include="magic.lambda.mysql" Version="14.0.4" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add magic.lambda.mysql --version 14.0.4
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: magic.lambda.mysql, 14.0.4"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install magic.lambda.mysql as a Cake Addin
#addin nuget:?package=magic.lambda.mysql&version=14.0.4

// Install magic.lambda.mysql as a Cake Tool
#tool nuget:?package=magic.lambda.mysql&version=14.0.4
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Using MySQL from Hyperlambda

This is the MySQL data adapter for Magic. This project allows you to provide a semantic lambda structure to its slots, which in turn will dynamically create a MySQL dialect SQL statement for you, for all basic types of CRUD SQL statements. In addition, it provides slots to open a MySQL database connection, and such allows you to declare your own SQL statements to be executed towards a MySQL database. Slots this project contains are as follows.

  • [mysql.connect] - Connects to a database
  • [mysql.create] - Creates a single record in the specified table
  • [mysql.read] - Reads multiple records from the specified table
  • [mysql.update] - Updates a single record in the specified table
  • [mysql.delete] - Deletes a single record in the specified table
  • [mysql.select] - Executes an arbitrary SQL statement, and returns results of reader as lambda objects to caller
  • [mysql.scalar] - Executes an arbitrary SQL statement, and returns the result as a scalar value to caller
  • [mysql.execute] - Executes an aribitrary SQL statement
  • [mysql.transaction.create] - Creates a new transaction
  • [mysql.transaction.commit] - Explicitly commits an open transaction
  • [mysql.transaction.rollback] - Explicitly rolls back an open transaction

Notice - If you use any of the CRUD slots from above, the whole idea is that you can polymorphistically use the same lambda object, towards any of the underlaying database types, and the correct specific syntax for your particular database vendor's SQL syntax will be automatically generated. This allows you to transparently use the same lambda object, towards any of the database types Magic supports, without having to change it in any ways.

All of the slots in this project are documented in the documentation for the "magic.data.common" project. If you replace the [data.xxx] or [sql.xxx] slots with [mysql.xxx], you will use the MySQL specific slots, instead of the generic, and/or polymorphistic slots. Hence, please refer to the documentation for "magic.data.common" to see the complete documentation for this project.

Project website

The source code for this repository can be found at github.com/polterguy/magic.lambda.mysql, and you can provide feedback, provide bug reports, etc at the same place.

Quality gates

  • Build status
  • Quality Gate Status
  • Bugs
  • Code Smells
  • Coverage
  • Duplicated Lines (%)
  • Lines of Code
  • Maintainability Rating
  • Reliability Rating
  • Security Rating
  • Technical Debt
  • Vulnerabilities
Product Versions
.NET net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows
.NET Core netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1
.NET Standard netstandard2.0 netstandard2.1
.NET Framework net461 net462 net463 net47 net471 net472 net48
MonoAndroid monoandroid
MonoMac monomac
MonoTouch monotouch
Tizen tizen40 tizen60
Xamarin.iOS xamarinios
Xamarin.Mac xamarinmac
Xamarin.TVOS xamarintvos
Xamarin.WatchOS xamarinwatchos
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on magic.lambda.mysql:

Package Downloads
magic.library

Helper project for Magic to wire up everything easily by simply adding one package, and invoking two simple methods. When using Magic, this is (probably) the only package you should actually add, since this package pulls in everything else you'll need automatically, and wires up everything sanely by default. To use package go to https://polterguy.github.io

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
14.0.4 18 7/6/2022
14.0.3 84 7/2/2022
14.0.2 49 7/2/2022
14.0.0 75 6/25/2022
13.4.0 496 5/31/2022
13.3.4 373 5/9/2022
13.3.0 201 5/1/2022
13.2.1 186 4/25/2022
13.2.0 142 4/21/2022
13.1.0 250 4/7/2022
13.0.0 127 4/5/2022
11.0.5 433 3/2/2022
11.0.4 172 2/22/2022
11.0.3 174 2/9/2022
11.0.2 198 2/6/2022
11.0.1 160 2/5/2022
10.0.21 162 1/28/2022
10.0.20 163 1/27/2022
10.0.19 164 1/23/2022
10.0.18 135 1/17/2022
10.0.16 148 1/14/2022
10.0.15 275 12/31/2021
10.0.14 219 12/28/2021
10.0.7 640 12/22/2021
10.0.5 313 12/18/2021
10.0.1 275 12/13/2021
9.9.9 837 11/29/2021
9.9.3 339 11/9/2021
9.9.2 258 11/4/2021
9.9.0 380 10/30/2021
9.8.9 316 10/29/2021
9.8.7 279 10/27/2021
9.8.6 269 10/27/2021
9.8.5 273 10/26/2021
9.8.0 673 10/20/2021
9.7.9 301 10/19/2021
9.7.5 779 10/14/2021
9.7.0 407 10/9/2021
9.6.7 301 8/30/2021
9.6.6 468 8/14/2021
9.4.0 2,038 6/24/2021
9.2.0 1,720 5/26/2021
9.1.4 600 4/21/2021
9.1.1 332 4/15/2021
9.1.0 293 4/14/2021
9.0.1 320 4/12/2021
9.0.0 256 4/5/2021
8.9.9 592 3/30/2021
8.9.3 827 3/19/2021
8.9.2 560 1/29/2021
8.9.1 552 1/24/2021
8.9.0 619 1/22/2021
8.7.0 1,519 11/15/2020
8.6.9 708 11/8/2020
8.6.6 1,143 11/2/2020
8.6.0 2,168 10/28/2020
8.5.0 1,043 10/23/2020
8.4.0 3,177 10/13/2020
8.3.1 1,525 10/5/2020
8.3.0 742 10/3/2020
8.2.2 1,177 9/26/2020
8.2.1 744 9/25/2020
8.2.0 791 9/25/2020
8.1.18 3,400 9/13/2020
8.1.17 755 9/13/2020
8.1.16 407 9/13/2020
8.1.15 1,065 9/12/2020
8.1.11 1,395 9/11/2020
8.1.10 764 9/6/2020
8.1.9 724 9/3/2020
8.1.8 732 9/2/2020
8.1.7 636 8/28/2020
8.1.4 669 8/25/2020
8.1.3 678 8/18/2020
8.1.2 674 8/16/2020
8.1.1 784 8/15/2020
8.1.0 400 8/15/2020
8.0.1 1,535 8/7/2020
8.0.0 675 8/7/2020
7.0.1 796 6/28/2020
7.0.0 683 6/28/2020
5.0.2 2,402 2/27/2020
5.0.1 1,804 2/25/2020
5.0.0 795 2/25/2020
4.0.4 4,416 1/27/2020
4.0.3 734 1/27/2020
4.0.2 873 1/16/2020
4.0.1 820 1/11/2020
4.0.0 813 1/5/2020
3.1.1 2,437 12/4/2019
3.1.0 1,622 11/10/2019
3.0.1 1,584 10/28/2019
3.0.0 1,092 10/23/2019
2.0.5 668 10/21/2019
2.0.4 1,928 10/19/2019
2.0.2 1,143 10/18/2019
2.0.1 2,444 10/15/2019
2.0.0 936 10/13/2019
1.1.9 774 10/11/2019
1.1.8 786 10/10/2019
1.1.7 349 10/9/2019
1.1.6 370 10/6/2019
1.1.5 381 10/6/2019
1.1.4 368 10/6/2019
1.1.3 387 10/5/2019
1.1.2 390 10/5/2019