1. Roland Mühlberger
  2. SnapObjects
  3. Friday, 19 July 2019

Hi,

we are in the process of building a Web API with SnapObjects. In PowerBuilder, we support either Sql Server or Oracle with the same table structure.

For number columns we use "int" in Sql Server and "number(38)" in Oracle. Unfortunately that leads to the following error when using SnapDevelop:

System.InvalidOperationException: Data type of mapped property on model is not compatiable, property: MZE
   at SnapObjects.Data.DataModelBinding.BindModel(IList`1 columnSchema, IPocoModelMeta modelMeta, ITypeMapper mapper)

Is there any way we can influence the binding process?

Thanks,

Roland

 

mike S Accepted Answer Pending Moderation
3
Votes
Undo

since version 11, oracle has an int data type that is the same size as sql server int.  so it is at least an option to write conversion scripts to int if the binding process can't be changed.

Comment
Hi Roland,

There is no way to influence the binding process now.



If you don't want to modify the database, you can create another model using C# datatype decimal for Oracle number(38). But it's not easy to maintain code in this way.



Regards,

Logan
  1. Logan Liu
  2. Monday, 22 July 2019
There are no comments made yet.
  1. Friday, 19 July 2019
  2. SnapObjects
  3. # 1
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.