Next release

Jul 5, 2007 at 9:55 PM
Hello

We are looking at your product and it seems to respond to our criteria. We saw that some of the code is "deprecated" (we are using VS 2005 and .NET 3.0).
The question is: are you planning a new release soon ?

For the Oracle10 DataStore we had a problem at the scripts generation: all the tables and columns names are between quotas and because of that the created tables work fine when the sql script is generated, but when we are trying to use something like: SqlQueryScript(@"SELECT * FROM TESTDOTNET.tbTestObjects")) it give us the error "Table or view not found".
Normally, the Oracle table names are upper case, but because of using the quotas in the generated script, the table names seems to remain in lowercase and are not accessible for queries like "SELECT * "...
How did it work for Oracle in your test program the TestQueryScriptBtn_Click method ?

Thank you,

Alina
Coordinator
Jul 24, 2007 at 6:12 PM
I'm actively working on the .NET 2.0 version of Retina.NET and it will be released soon (three weeks aprox.).

Regarding the Oracle table names, they are case sensitive and therefore they must be referenced using the exac same casing used when the table was created, being that lower, upper or mixed case.
If you have a database object names standard different from what Retina.NET generates, you can specify a different table name on your entity classes (the casing will be preserved) or customize the Oracle DataStore (and DataStore Generator) to suit your needs.

Best regards,
Andrés.



alina wrote:
Hello

We are looking at your product and it seems to respond to our criteria. We saw that some of the code is "deprecated" (we are using VS 2005 and .NET 3.0).
The question is: are you planning a new release soon ?

For the Oracle10 DataStore we had a problem at the scripts generation: all the tables and columns names are between quotas and because of that the created tables work fine when the sql script is generated, but when we are trying to use something like: SqlQueryScript(@"SELECT * FROM TESTDOTNET.tbTestObjects")) it give us the error "Table or view not found".
Normally, the Oracle table names are upper case, but because of using the quotas in the generated script, the table names seems to remain in lowercase and are not accessible for queries like "SELECT * "...
How did it work for Oracle in your test program the TestQueryScriptBtn_Click method ?

Thank you,

Alina