Cannot convert object of type 'Devart.Data.Oracle.OracleDate' to object of type 'System.Decimal'."

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
creaseypaul
Posts: 11
Joined: Mon 14 Feb 2011 15:56

Cannot convert object of type 'Devart.Data.Oracle.OracleDate' to object of type 'System.Decimal'."

Post by creaseypaul » Fri 14 Sep 2012 17:55

I upgraded my project from linqconnect250pro.exe to linqconnect40pro.exe, which means going from:

Devart.Data from Version=5.0.272.0 to Version=5.0.476.0
Devart.Data.Oracle from Version=6.30.172.0 to Version=7.0.17.0
Most other assemblies from Version=2.50.25.0 to Version=4.0.21.0

I have an ExecuteQuery<T> that was previous working, that is now throwing the following:

System.InvalidOperationException was unhandled by user code
Message="Cannot convert object of type 'Devart.Data.Oracle.OracleDate' to object of type 'System.Decimal'."
Source="Devart.Data.Oracle"
StackTrace:
at Devart.Common.e.g(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.cc.g(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.ck.g(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.OracleDataReader.GetDecimal(Int32 i)
at Devart.Data.Linq.Engine.an.d.a(IDataReader A_0)
at Devart.Data.Linq.Engine.an.EntityComplexKeyReader`2.d(IDataReader A_0)
at Devart.Data.Linq.Engine.EntityReader`3.a()
at Devart.Data.Linq.Engine.ObjectReader`1.a(T& A_0)
at Devart.Data.Linq.Engine.ObjectReader`1.g()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

No change was made to the database, the DataContext was just rebuilt.

I have scoured Designer.cs file comparing the DbType and the property Type, all db types match the db and all the property types are suitable. There are no date columns being loaded into decimal fields of this i am certain.

Any help would be appreciated, particularly as to how i can find out which column maybe causing this and why?

If you want more code, can you provide an email address where i can send it?

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Cannot convert object of type 'Devart.Data.Oracle.OracleDate' to object of type 'System.Decimal'."

Post by MariiaI » Mon 17 Sep 2012 13:52

We couldn't reproduce this issue.
Please send us the sample project, so that we are able to reproduce the issue.

Post Reply