Install-Package Dapper.Oracle.StrongName -Version 2.0.3
dotnet add package Dapper.Oracle.StrongName --version 2.0.3
<PackageReference Include="Dapper.Oracle.StrongName" Version="2.0.3" />
paket add Dapper.Oracle.StrongName --version 2.0.3
#r "nuget: Dapper.Oracle.StrongName, 2.0.3"
// Install Dapper.Oracle.StrongName as a Cake Addin #addin nuget:?package=Dapper.Oracle.StrongName&version=2.0.3 // Install Dapper.Oracle.StrongName as a Cake Tool #tool nuget:?package=Dapper.Oracle.StrongName&version=2.0.3
Dapper is a great tool if you want to write database-agnostic code.
However, sometimes you need to access functionality that is provider-specific.
This assembly adds support for writing Oracle-specific SQL, that supports all dbtypes used by the Oracle managed provider on a parameter,
supports setting various properties on the command(LOBFetchSize, ArrayBindCount, BindByName), as well as setting CollectionType on the parameter.
Using this package, you can now run stored procedures that returns RefCursor, or use array bind count to execute a sql statements with a array of parameters.
This package is not used by any NuGet packages.
This package is not used by any popular GitHub repositories.
- Enabling using Dapper.Oracle when running under a profiled DbCommand.
Basically, any database profiler will decorate an oracle connection, so Dapper.Oracle now looks for a public property of type DbCommand when it detects that it is not working against a OracleCommand, and will recursively search for the actual DbCommand in order to set the Oracle-specific properties.