Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved SnapObjects Oracle Model Binding

  1. Issue
0
Votes
Undo
  1. Peter Kurz
    Peter Kurz
  2. SnapObjects
  3. Friday, 14 August 2020 13:15 PM UTC

Hello,

is there a way to influence the binding process between SnapObjects and a database (specifically Oracle) yet?

The issue we're facing is that when reading from an Column that has the type NUMBER, SnapObjects requires the property in the C# Model to be a decimal, which doesn't make a lot of sense if the property/column in question is for example an ID.

This feature has already been asked for in late 2019 (https://community.appeon.com/index.php/qna/q-a/different-binding-for-oracle-and-sql-server-number-columns), so I was wondering if this is possible yet.

If not, is there any other way to resolve this? I've tried to create a struct that allows for casting between decimal and int, but SnapObjects doesn't seem to care about whether or not the assignment would be possible, it's just looking for the decimal type and won't accept anything else. Creating an entirely different model just for Oracle would be very unwieldy and hard to maintain.

Kind regards,

Peter

  1. Oracle
  2. SQL
  3. .NET DataStore
ISqlExecutor using model created a runtime
Getting Error Details from SelectProcedure?
Responses (2)
Logan Liu @Appeon
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Saturday, 15 August 2020 16:08 PM UTC
  2. SnapObjects
  3. # 1

Hi Peter,

There is still no way to influence the binding process between SnapObjects and a database. So you still need to maintain different models for each database.

If you want this feature, we suggest that you submit an enhancement ticket on our support portal (at https://www.appeon.com/standardsupport). This way, our product team will analyze this request when they plan to extend SnapObjects in the future. 

Regards,

Logan

 

Comment
There are no comments made yet.
armando herrera @Appeon
armando herrera @Appeon Accepted Answer Pending Moderation
  1. Friday, 14 August 2020 20:30 PM UTC
  2. SnapObjects
  3. # 2

Hi Peter,

For Datatype conversion unlike PowerBuilder which allows conversions between numeric data types, C# has quite strict controls over this.

For data types that are not allowed to convert to another data type implicitly in C#, the migrator may do forced conversions based on its deduction of the data type.

Please refer to the following guide for rules on datatype conversions.

or you can always open a support ticket for more support. 

 

Regards! 

Comment
There are no comments made yet.
  • Page :
  • 1


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