Skip to content

uzbekdev1/UzEx.ORM.Dapper.Oracle

Repository files navigation

Uzex.ORM.Dapper.Oracle

Oracle support for Dapper Micro ORM.

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.

Supported Oracle-specific properties

OracleParameter:

OracleDbType enum (all members used by the managed provider) CollectionType enum ParameterStatus (return type when executing stored procedure) ArrayBindSize

OracleCommand:

ArrayBindCount property BindByName property InitialLOBFetchSize (LOB = Large Object Binary)