Using ODBC from Hyperlambda
This is the ODBC data adapter for Magic. This project provides slots to open an ODBC database connection, and allows you to execute your own SQL statements towards an open ODBC connection. Slots this project contains are as follows.
- [odbc.connect] - Connects to a database
- [odbc.select] - Executes an arbitrary SQL statement, and returns results of reader as lambda objects to caller
- [odbc.scalar] - Executes an arbitrary SQL statement, and returns the result as a scalar value to caller
- [odbc.execute] - Executes an aribitrary SQL statement
- [odbc.transaction.create] - Creates a new transaction
- [odbc.transaction.commit] - Explicitly commits an open transaction
- [odbc.transaction.rollback] - Explicitly rolls back an open transaction
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 [odbc.xxx], you will use the ODBC 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.
ODBS data adapter drivers
Notice, Magic does not install any ODBC drivers for your specific database type during installation. Hence, depending upon which database type you want to use, you’re going to have to manually make sure you install the driver for it yourself, by adding the NuGet package for your particular database type and manually building the “backend.csproj” file yourself, using for instance the DotNet CLI. The reasons for this is because there exists literally hundreds of different databases out there having specific ODBC data adapter drivers, and installing all of these would be impossible for us to do.
The source code for this repository can be found at github.com/polterguy/magic.lambda.odbc, and you can provide feedback, provide bug reports, etc at the same place.