JDBC.NET

It is a wrapper that allows you to use JDBC drivers in ADO.NET

Getting Started

1. Install NuGet package

Install the latest version of the JDBC.NET.Data package from NuGet.

2. Add J2NET Runtime package reference

Paste the following XML into your Project(.csproj / .vbproj / .fsproj) file.

<PropertyGroup>
<RuntimeVersion>1.3.2</RuntimeVersion>
<OSPlatformCondition="'$([System.Runtime.InteropServices.RuntimeInformation]::IsOSPlatform($([System.Runtime.InteropServices.OSPlatform]::OSX)))' == 'true'">OSX</OSPlatform>
<OSPlatformCondition="'$([System.Runtime.InteropServices.RuntimeInformation]::IsOSPlatform($([System.Runtime.InteropServices.OSPlatform]::Linux)))' == 'true'">Linux</OSPlatform>
<OSPlatformCondition="'$([System.Runtime.InteropServices.RuntimeInformation]::IsOSPlatform($([System.Runtime.InteropServices.OSPlatform]::Windows)))' == 'true'">Windows</OSPlatform>
<OSArchitecture>$([System.Runtime.InteropServices.RuntimeInformation]::ProcessArchitecture)</OSArchitecture>
</PropertyGroup>
<ItemGroup>
<PackageReferenceCondition=" '$(OSPlatform)' == 'OSX' And '$(OSArchitecture)' == 'X64' "Include="J2NET.Runtime.Mac"Version="$(RuntimeVersion)" />
<PackageReferenceCondition=" '$(OSPlatform)' == 'Linux' And '$(OSArchitecture)' == 'X64' "Include="J2NET.Runtime.Linux"Version="$(RuntimeVersion)" />
<PackageReferenceCondition=" '$(OSPlatform)' == 'Windows' And '$(OSArchitecture)' == 'X64' "Include="J2NET.Runtime.Win64"Version="$(RuntimeVersion)" />
<PackageReferenceCondition=" '$(OSPlatform)' == 'Windows' And '$(OSArchitecture)' == 'X86' "Include="J2NET.Runtime.Win32"Version="$(RuntimeVersion)" />
</ItemGroup>

3. Connect to Database!

varbuilder=newJdbcConnectionStringBuilder{DriverPath="mysql-connector-java-8.0.21.jar",DriverClass="com.mysql.cj.jdbc.Driver",JdbcUrl="jdbc:mysql://127.0.0.1/sakila?user=root&password=12345"};usingvarconnection=newJdbcConnection(builder);connection.Open();