Newbie question on connecting to SQL Server Or Oracle

Posts   
 
    
Waldo
User
Posts: 9
Joined: 15-Feb-2006
# Posted on: 15-Feb-2006 08:54:24   

Hi everyone,

Just downloaded the demo version earlier, looks like a great product. simple_smile

I have a question regarding connecting to SqL Server or Oracle backends.

When generating the code using the SQL Server template, is there anyway to use the code generated to also point to a Oracle backend database as well? (via Factory methods/app config file, etc)

(ie. if a client is using our data model in Oracle, can we connect to it from the code generated above Or do we need to re-generate it based on our data model in Oracle?)

Thanks!

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 15-Feb-2006 14:37:32   

You should be using the Adapter model.

You will have to re-generate the Database Specific project pointing to the Oracle database, and you can use either Database specific dlls within your code provided that the schema is the same and the database name is exactly the same.

Also you can refer to the following threads: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=4702 http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=4093 http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=3080 http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=2095

Waldo
User
Posts: 9
Joined: 15-Feb-2006
# Posted on: 16-Feb-2006 01:06:45   

Thanks for your help Walaa.