Hi,

I would like to have my concepts clear, so I would like to know the following:

1. I have a SQL Server LLBLGen Pro project, I have my generic and specific project.
2. I add some custom code to my generic project.
3. Later a would like to use my application with other database server (for example: Oracle), I create the database with the same structure as my SQL server database structure. Generate the specific and generic project for the new database server.
4. The question is: Can I use the SQL server generic project (which has my custom code) with the new specific project (Oracle) ? My concept is that it is possible; but I would like to confirm it.

BTW, the generated ConstansEnums say:

' // Do not try to run this code on another version of the database than the database ' // which was used to generate this code. This means that when you used f.e. SqlServer 2000 ' // to generate this code, it is likely that you will not be able to use that code on ' // SqlServer 7 due to SQL syntax mismatches. Most code is generic code which will work ' // with any database, but some code relies on a specific database type/vendor/version used. ' // This code is located in the DaoClasses which target a specific specified database. Also all ' // classes target a specific specified Dynamic Query Engine (DQE) in the using/imports ' // directives.

I think this is confuse.

Rogelio wrote:

Hi,

I would like to have my concepts clear, so I would like to know the following:

1. I have a SQL Server LLBLGen Pro project, I have my generic and specific project.
2. I add some custom code to my generic project.
3. Later a would like to use my application with other database server (for example: Oracle), I create the database with the same structure as my SQL server database structure. Generate the specific and generic project for the new database server.
4. The question is: Can I use the SQL server generic project (which has my custom code) with the new specific project (Oracle) ? My concept is that it is possible; but I would like to confirm it.

That's possible indeed. It doesn't matter which generic project you're using, the sqlserver one or the oracle one.

BTW, the generated ConstansEnums say:

' // Do not try to run this code on another version of the database than the database ' // which was used to generate this code. This means that when you used f.e. SqlServer 2000 ' // to generate this code, it is likely that you will not be able to use that code on ' // SqlServer 7 due to SQL syntax mismatches. Most code is generic code which will work ' // with any database, but some code relies on a specific database type/vendor/version used. ' // This code is located in the DaoClasses which target a specific specified database. Also all ' // classes target a specific specified Dynamic Query Engine (DQE) in the using/imports ' // directives. I think this is confuse.

I know, I've tried to remove them as much as possible from the generated code in v1.0.2004.2. If you're using that beta, please let me know and I'll do another search to see if I forgot a few templates.

Otis wrote:

I know, I've tried to remove them as much as possible from the generated code in v1.0.2004.2. If you're using that beta, please let me know and I'll do another search to see if I forgot a few templates.

I am using v1.0.2004.2

Thanks, I'll make sure that remark is removed from the final code.