zzz projects Dapper Tutorial
Getting Started Documentation 3rd Party Libraries Knowledge Base Online Examples
English (en) Français (fr) Español (es) Italiano (it) Deutsch (de) русский (ru) 한국어 (ko) 日本語 (ja) 中文简体 (zh-CN) 中文繁體 (zh-TW)
  • Getting Started
  • Documentation
  • 3rd Party Libraries
  • Knowledge Base
  • Online Examples
English (en) Français (fr) Español (es) Italiano (it) Deutsch (de) русский (ru) 한국어 (ko) 日本語 (ja) 中文简体 (zh-CN) 中文繁體 (zh-TW)

Dapper Tutorial - Knowledge Base (KB)

English (en) Français (fr) Español (es) Italiano (it) Deutsch (de) русский (ru) 한국어 (ko) 日本語 (ja) 中文简体 (zh-CN) 中文繁體 (zh-TW)

51 results for: in tag: oracle

Using Dapper with Oracle

We use Oracle as our database provider and have looked into replacing some of our data access layer (hard to maintain, harder to merge XSD's) with a saner repository based pattern using Dapper at the bottom layer. However, we have hit a number of issues w...
c# dapper oracle
asked by Wolfwyrd

Why does Dapper throw an OracleException when i run a query or command with parameters?

I am evaluation dapper but i already running into some problems....I am trying to do this...using (IDbConnection connection = GetConnection()) { connection.Open(); var result = connection.Query( "select * from myTable where ID_PK = @a;", n...
dapper exception oracle oracle11g orm
asked by mrt181

Using Dapper with Oracle stored procedures which return cursors

How would one go about using ...Dapper... with Oracle stored procedures which return cursors?...var p = new DynamicParameters(); p.Add("foo", "bar"); p.Add("baz_cursor", dbType: DbType.? , direction: ParameterDirection.Output); ...Here, the DbType is Syst...
.net c# dapper oracle
asked by hark

Using Dapper.net with MySql & Oracle

All the samples online show that Dapper.net works with SQL Server. What about other Databases like mySQl or Oracle? Is there a guideline or sample on how to do so?
asp.net-mvc-3 c# dapper mysql oracle
asked by Bill

Dapper Oracle Number(10,0) is returned as Decimal Parser error

I have a POCO:...public class Role { public Int32 Id { get; set; } public string Name { set; get; } } ...The Oracle table is ...Id NUMBER(10,0)... and ...Name VARCHAR2(100 CHAR)...Dapper inserts fine but when I read the records it bring the Id as de...
c# dapper oracle
asked by Shuaib

Dapper, Oracle and Command Parameter

I have a table in Oracle named MESSAGE and it has a column TERMINALID (VARCHAR2 8 NOT NULL); and there is an index for this column. There are about 300,000,000 records in this table....Now, ...this works fine (0.0 seconds)...:...using (var con = new Oracl...
c# dapper oracle orm parameters
asked by Kaveh Shahbazian

Dapper and OrmLite IDBConnectionFactory in ServiceStack

I am impressed with the speed that I can create services using ServiceStack, but for a while now I have not been able to grasp the concept of using OrmLite and Dapper simultaneously in my project. I am registering a IDbConnectionFactory like this in my G...
dapper oracle ormlite-servicestack servicestack
asked by Nick H

Using Dapper with Oracle User-Defined Types

Is there a way to use Dapper with Oracle User-Defined Types returned by stored procedures? Dapper seems to work with stored procedures (see ...Using Dapper with Oracle stored procedures which return cursors...)....var p = new OracleDynamicParameters(); p....
.net c# dapper oracle orm
asked by Marco Mayer

Dapper with Oracle passing in DbParameter

I'm trying out Dapper with Oracle and I was trying to run a multi-resultset query but Oracle requires a dbtype of refcursor....StringBuilder query = new StringBuilder("BEGIN "); query.Append("OPEN :rs1 FOR SELECT * FROM Table1 where key=:KEY; "); query.Ap...
dapper oracle parameter-passing
asked by user2429012

Dapper & Oracle Clob type

I am using dapper to do some oracle access. I have a scenario where I have to have an output parameter with a type of OracleDbType.Clob. As I am using dapper and thus using the base DbType enumeration I am using the DbType.Object enum as suggested here ...
ado.net dapper oracle
asked by Jon

Dapper,decimal to double? Error parsing column X

My database is Oracle. I user Dapper 1.13, which throws an exception saying ...Error parsing column 3 (LATITUDE=39.2330 - Decimal).... LATITUDE is a ...double?... type in my entity. ...Please help me....Thanks
dapper oracle parsing
asked by yulh

Using Dapper QueryMultiple in Oracle

I´m trying to use dapper with Oracle (ODP.NET) and I would like to use the "QueryMultiple" functionality....Passing this string to the QueryMultiple method:... var query = "Select CUST_ID CustId from Customer_info WHERE CUST_ID=:custId;" + ...
dapper oracle
asked by Kamolas81

Dapper.net Oracle parameter

I am trying to use Dapper.net with Oracle....From this ...post... i understood that we could use parameters with no prefixes and dapper would then work for both ...sql server...and ...oracle...I'm having a hard time making it to work without the explicit ...
dapper oracle
asked by Luis Filipe

How can I use Dapper in a multi database environment?

I'm trying to implement simple queries like ...SELECT * FROM TABLE_X WHERE XID = @id..., but the problem that I'm having is that these queries would run on different databases (SQL Server and Oracle) for different application instances....How to do it wit...
dapper oracle sql sql-server
asked by Adriano Machado

Unable to get Long type of data using Dapper

The problem:... I am unable to retrieve a column of type Long in an Oracle DB source and set it to a string property in a class in .Net...Details:... While trying to use dapper to fire SQL queries and get back results, I came across a rather weird situati...
.net c# dapper oracle sql
asked by Hari

Get value of Oracle OUT parameter from a stored procedure call using Dapper.NET

Edit: Using the ...Execute... method instead of the ...Query.../...QueryMultiple... methods, my ...OUT_SUCCESS... parameter now has an ...AttachedParam... with with an ...OracleParameter... that has the returned value. So this would work if, for instance,...
ado.net c# dapper odac oracle
asked by tacos_tacos_tacos

Dynamic Parameterized query with dapper

I want to write a query with a dynamic list of parameters (depending on parameter is set or not). I want to execute the query on an oracle database using dapper....Sample code:... var sqlParams = new List<object>(); var sqlBuilder = new Str...
c# dapper oracle sql
asked by road242

How to insert string into oracle clob type with Dapper?

I have a simple question about dapper with Oracle database, when I was trying to insert a large size of string into oracle clob, it throws exception says: ...Specified argument was out of the range of valid values. ...then I was trying to modify this part...
dapper oracle
asked by Timeless

Dapper and Oracle parametrized query - ORA-01036: illegal variable name/number

I'm currently trying my hand on Dapper. The following code works flawlessly:...using (var conn = new OracleConnection( "Uid=dbusr;Pwd=dbusrpwd;Server=oraserver;")) { var col = conn.Query<User>( "SELECT * FROM Users WHERE ...
c# dapper oracle
asked by OnoSendai

ORA-12154: TNS:could not resolve the connect identifier specified (Oracle, ASP,Net, Dapper)

I can't find the exact issue I have on here or anywhere....I have an ASP.Net MVC WebApi (MVC 5.1.0, Framework 4.5.1) project that uses ...Oracle.DataAccess.... It runs on the local IIS server via a URL that's in my hosts file. It has a connection string ...
asp.net-mvc dapper oracle
asked by kpollock

Page 1 of 3
  • 1
  • 2
  • 3
  • »

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...