[Firebird-net-provider] Unique Constraint Exception thrown when it shouldn't

2014-03-19 Thread David De Smet
Good day, I'm using version 4.1.0.0 for .NET 4.5/4.0 with Entity Framework support of the Firebird ADO.NET Data Provider. And I'm getting this exception when it shouldn't. Let me further explain: I have a table *Product*, with *Code* field which is unique and with DB type as VarChar. When I sav

[Firebird-net-provider] DB Type decimal is not returning as decimal

2014-03-19 Thread David De Smet
Good day, I'm using version 4.1.0.0 for .NET 4.5/4.0 with Entity Framework support of the Firebird ADO.NET Data Provider. I'm experiencing an InvalidCastException when trying to get a value of a field which I assigned the DB type as decimal. Looking further into the problem I'm seeing that the r

Re: [Firebird-net-provider] DB Type decimal is not returning as decimal

2014-03-20 Thread David De Smet
or long if coding in C#. I'm using Firebird Embedded. David De Smet Message sent from my iPhone > On 20/03/2014, at 02:00, Jiri Cincura wrote: > > What's the datatype in DB and what's in your model? Very likely you > have a mismatch there. > > > -- >

Re: [Firebird-net-provider] DB Type decimal is not returning as decimal

2014-03-23 Thread David De Smet
0 Mar 2014 03:51:23 -0600, David De Smet > wrote: > > I'm using LLBLGen for creating the script and model. > > > > The script for creating the DB is DECIMAL, so is the DB end result. I > > verified with Flamerobin. > > What is the precision and scale of the DECIM

Re: [Firebird-net-provider] Unique Constraint Exception thrown when it shouldn't

2014-03-23 Thread David De Smet
Hi Jiri, It was indeed a violation of unique constraint. However, specifying Dialect 3 worked without any problem. Thank you, David On Thu, Mar 20, 2014 at 1:59 AM, Jiri Cincura wrote: > What's the complete message? Isn't it a violation on PK? > > > -- > Jiri {x2} Cincura (x2develop.com found