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

c# dapper oracle

Question

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 decimal and I get a parser error. And NO, I can't change the Int32 Id to decimal Id in POCO class.

Accepted Answer

Thanks to Alex I installed ODP.net and it worked.




Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why