How I can use the generated code to work on Oracle/MSSQL

Posts   
 
    
eirizarry
User
Posts: 48
Joined: 30-Mar-2011
# Posted on: 30-Apr-2011 17:57:57   

I have a web application that use the generated code from an Oracle Database. Can i use the same code to connect to a MS SQL Server database if i already migrate the tables an procedures to MS SQL Server? if, yes, how i do it? if not, I need to create a new code from MS SQL Server?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 01-May-2011 22:06:02   

You need to create a new LLBLGen project for SQLServer and generate code again. If you use Adapter templateset then the generated code consists of two projects (DBGeneric and DBSpecific). The DBGeneric project will be the same, but the DBSpecific will be specific to make the calls to SQLServer.

If you want to convert your existing project to point to SqlServer, do this: In the v3 designer you should add relational model data from the other database (like when refreshing), delete the old catalog (Oracle) and then use forward mapping (auto-map unmapped entities, by right-clicking 'Entities'). Then regenerate code.

David Elizondo | LLBLGen Support Team