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?
Cannot convert object of type 'Devart.Data.Oracle.OracleDate' to object of type 'System.Decimal'."
-
- Posts: 11
- Joined: Mon 14 Feb 2011 15:56
Re: Cannot convert object of type 'Devart.Data.Oracle.OracleDate' to object of type 'System.Decimal'."
We couldn't reproduce this issue.
Please send us the sample project, so that we are able to reproduce the issue.
Please send us the sample project, so that we are able to reproduce the issue.