Business Object was filled from ORACLE. (Table)

But When I 'm trying to access "id" property getting the error "specified cast is not valid".

Id property (Int32), Datatable.Column.type is System.Decimal. (ORacle table column is NUMBER").

I've run the query through FillDataTable("Select statement") command.

public System.Int32 id

{

get

{

return (System.Int32)this.CurrentRow["id"];

}

set

{

this.CurrentRow["id"] = value;

}

}

Sorry, I've not seen your response because I've forgotten to look at the next page. So, I've written a post about waiting guidance and roadmap.

I've understood your advice for external queries. But What about queries generated by strataframe. ? I've found a point that I've written above as a post. As explained in that post, INSERT,UPDATE and Delete queries can not be executed because there is a need for type conversion from SQL TO ORACLE. This is the critical point. The case have to be solved by Strataframe developers.

I've solved  for the external queries. 

Actually this is not something that needs to be changed by SF developers, but rather something that you should take into account in your application.  We have no intention of making the SqlDataSourceItem try and figure out of a data type should be converted into an Oracle item..this would break a lot of peoples applications and is not something that we are going to do.

Now, since you have this need, you can do this quite easily yourself.  You already have your application setup to determine if you are running SQL or Oracle and since you have this need, this would be my suggestion.  Create your own data sources.  You have the SF source code, so you can copy the code from the SqlDataSOurceItem and create your own...or just inherit from the SqlDataSOurceItem and override the CreateDbCommand (probably the better route) and then take this into account yourself.  You can copy the code from the SqlDataSourceItem or the OracleDataSourceItem so that you can see exactly what the CreateDbCommand is doing and then adjust this to meet your needs.  This is going to be the route that you will need to take...and it doesn't require anything whatsoever to be done within the framework itslef but rather is specific to your application.