Dapper Tutorial - Knowledge Base (KB)
57 results 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...
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...
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...
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?
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...
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...
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...
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....
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...
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 ...
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
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;" + ...
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 ...
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...
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...
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,...
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...
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...
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 ...
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 ...
asked by kpollock
Page 1 of 3