magic.lambda.mysql 17.2.0

dotnet add package magic.lambda.mysql --version 17.2.0
NuGet\Install-Package magic.lambda.mysql -Version 17.2.0
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="magic.lambda.mysql" Version="17.2.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add magic.lambda.mysql --version 17.2.0
#r "nuget: magic.lambda.mysql, 17.2.0"
#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 magic.lambda.mysql as a Cake Addin
#addin nuget:?package=magic.lambda.mysql&version=17.2.0

// Install magic.lambda.mysql as a Cake Tool
#tool nuget:?package=magic.lambda.mysql&version=17.2.0

magic.lambda.mysql - Using MySQL and MariaDB from Hyperlambda

The magic.lambda.mysql project is Hyperlambda's MySQL data adapter. 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. If you need for instance documentation about the [mysql.connect] slot you should look for the documentation for [data.connect], since it's more or less the exact same documentation.

Magic's GitHub project page

Magic is 100% Open Source and you can find the primary project GitHub page here.

Project website for magic.lambda.mysql

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.

  • Build status
  • Quality Gate Status
  • Bugs
  • Code Smells
  • Coverage
  • Duplicated Lines (%)
  • Lines of Code
  • Maintainability Rating
  • Reliability Rating
  • Security Rating
  • Technical Debt
  • Vulnerabilities

The projects is copyright Thomas Hansen 2023 - 2024, and professionally maintained by AINIRO.IO.

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 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 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 (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
17.2.0 264 1/22/2024
17.1.7 156 1/12/2024
17.1.6 128 1/11/2024
17.1.5 137 1/5/2024
17.0.1 172 1/1/2024
17.0.0 304 12/14/2023
16.11.5 287 11/12/2023
16.9.0 287 10/9/2023
16.7.0 489 7/11/2023
16.4.1 315 7/2/2023
16.4.0 349 6/22/2023
16.3.1 315 6/7/2023
16.3.0 280 5/28/2023
16.1.9 569 4/30/2023
15.10.11 448 4/13/2023
15.9.1 536 3/27/2023
15.9.0 446 3/24/2023
15.8.2 484 3/20/2023
15.7.0 355 3/6/2023
15.5.0 1,511 1/28/2023
15.2.0 627 1/18/2023
15.1.0 1,118 12/28/2022
14.5.7 667 12/13/2022
14.5.5 767 12/6/2022
14.5.1 638 11/23/2022
14.5.0 568 11/18/2022
14.4.5 669 10/22/2022
14.4.1 694 10/22/2022
14.4.0 630 10/17/2022
14.3.2 972 9/18/2022
14.3.1 734 9/12/2022
14.3.0 607 9/10/2022
14.1.3 878 8/7/2022
14.1.2 643 8/7/2022
14.1.1 624 8/7/2022
14.0.14 660 7/26/2022
14.0.12 626 7/24/2022
14.0.11 586 7/23/2022
14.0.10 629 7/23/2022
14.0.9 624 7/23/2022
14.0.8 713 7/17/2022
14.0.5 760 7/11/2022
14.0.4 788 7/6/2022
14.0.3 676 7/2/2022
14.0.2 627 7/2/2022
14.0.0 834 6/25/2022
13.4.0 2,024 5/31/2022
13.3.4 1,385 5/9/2022
13.3.0 939 5/1/2022
13.2.1 944 4/25/2022
13.2.0 736 4/21/2022
13.1.0 997 4/7/2022
13.0.0 704 4/5/2022
11.0.5 1,341 3/2/2022
11.0.4 737 2/22/2022
11.0.3 779 2/9/2022
11.0.2 794 2/6/2022
11.0.1 752 2/5/2022
10.0.21 739 1/28/2022
10.0.20 727 1/27/2022
10.0.19 746 1/23/2022
10.0.18 711 1/17/2022
10.0.16 735 1/14/2022
10.0.15 696 12/31/2021
10.0.14 550 12/28/2021
10.0.7 1,434 12/22/2021
10.0.5 720 12/18/2021
10.0.1 758 12/13/2021
9.9.9 1,231 11/29/2021
9.9.3 922 11/9/2021
9.9.2 599 11/4/2021
9.9.0 705 10/30/2021
9.8.9 675 10/29/2021
9.8.7 610 10/27/2021
9.8.6 577 10/27/2021
9.8.5 652 10/26/2021
9.8.0 1,376 10/20/2021
9.7.9 617 10/19/2021
9.7.5 1,448 10/14/2021
9.7.0 825 10/9/2021
9.6.7 636 8/30/2021
9.6.6 947 8/14/2021
9.4.0 3,625 6/24/2021
9.2.0 3,028 5/26/2021
9.1.4 1,243 4/21/2021
9.1.1 795 4/15/2021
9.1.0 637 4/14/2021
9.0.1 652 4/12/2021
9.0.0 539 4/5/2021
8.9.9 1,094 3/30/2021
8.9.3 1,563 3/19/2021
8.9.2 1,063 1/29/2021
8.9.1 1,040 1/24/2021
8.9.0 1,119 1/22/2021
8.7.0 2,418 11/15/2020
8.6.9 1,321 11/8/2020
8.6.6 2,029 11/2/2020
8.6.0 3,957 10/28/2020
8.5.0 1,902 10/23/2020
8.4.0 5,615 10/13/2020
8.3.1 2,666 10/5/2020
8.3.0 1,256 10/3/2020
8.2.2 2,070 9/26/2020
8.2.1 1,365 9/25/2020
8.2.0 1,351 9/25/2020
8.1.18 6,012 9/13/2020
8.1.17 1,362 9/13/2020
8.1.16 664 9/13/2020
8.1.15 1,939 9/12/2020
8.1.11 2,568 9/11/2020
8.1.10 1,335 9/6/2020
8.1.9 1,329 9/3/2020
8.1.8 1,334 9/2/2020
8.1.7 1,195 8/28/2020
8.1.4 1,231 8/25/2020
8.1.3 1,257 8/18/2020
8.1.2 1,234 8/16/2020
8.1.1 1,338 8/15/2020
8.1.0 658 8/15/2020
8.0.1 2,761 8/7/2020
8.0.0 1,262 8/7/2020
7.0.1 1,369 6/28/2020
7.0.0 1,244 6/28/2020
5.0.2 4,123 2/27/2020
5.0.1 3,247 2/25/2020
5.0.0 1,376 2/25/2020
4.0.4 7,819 1/27/2020
4.0.3 1,257 1/27/2020
4.0.2 1,422 1/16/2020
4.0.1 1,352 1/11/2020
4.0.0 1,382 1/5/2020
3.1.1 4,157 12/4/2019
3.1.0 2,727 11/10/2019
3.0.1 2,709 10/28/2019
3.0.0 1,896 10/23/2019
2.0.5 1,043 10/21/2019
2.0.4 3,396 10/19/2019
2.0.2 1,841 10/18/2019
2.0.1 3,845 10/15/2019
2.0.0 1,646 10/13/2019
1.1.9 1,386 10/11/2019
1.1.8 1,412 10/10/2019
1.1.7 588 10/9/2019
1.1.6 618 10/6/2019
1.1.5 618 10/6/2019
1.1.4 622 10/6/2019
1.1.3 644 10/5/2019
1.1.2 626 10/5/2019