Dapper: Simple INSERT with Dapper on Oracle
Hi.
I would like to use Dapper to have db agnostic code used for e.g. PostgreSQL and Oracle with as little db flavored code as possible. This INSERT code is running without problems for SQL-server and PostgreSQL:
var item = new Item { Name = "Test Name", Number = "Test Number" };
await Connection.ExecuteAsync(@"INSERT INTO Table (Name, Number) VALUES (@Name, @Number);", item);
On Oracle (version 11 xe), I get an ORA-00936: missing expression.
Do I need tailoring using DynamicParameters or the likes?
unipeg
All 3 comments
Hello @unipeg.
Since this is using a OracleCommand of CommandType.Text, you should precede the parameter name with a colon (:).
That would look like:
c#
var item = new Item { Name = "Test Name", Number = "Test Number" };
await Connection.ExecuteAsync(@"INSERT INTO Table (Name, Number) VALUES (:Name, :Number)", item)
Please refer to the docs for greater details.
kelvindules
on 15 Nov 2018
my DapperExtensions can reslove your problem
https://github.com/znyet/DapperExtensions
znyet
on 7 Jan 2019
Answered above, closing out to cleanup!
NickCraver
on 4 May 2020
Related issues
silkfire
路
4Comments
fishjimi
路
5Comments
rafakwolf
路
5Comments
huobazi
路
4Comments
cpx86
路
4Comments
Most helpful comment
Hello @unipeg.
Since this is using a OracleCommand of
CommandType.Text, you should precede the parameter name with a colon (:).That would look like:
c# var item = new Item { Name = "Test Name", Number = "Test Number" }; await Connection.ExecuteAsync(@"INSERT INTO Table (Name, Number) VALUES (:Name, :Number)", item)Please refer to the docs for greater details.