Multiple Database Support - Self-Servicing LLBLGen Pro 2.5

Posts   
 
    
mshe
User
Posts: 167
Joined: 02-Feb-2006
# Posted on: 29-May-2008 06:32:48   

Hi all,

I've searched through the forums a bit in regards to multiple database support ... but most of the comments seem a bit out of date.

Is it possible to support multiple database with the self-servicing model? i.e. Today the app will use SQL Server, tomorrow MySQL, next year Oracle? I would just like to make a config file change to enable the end-user to swap DB drivers?

Thanks!

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 29-May-2008 08:21:27   

Hi Markham,

In short, SelfServicing is about the paradigm that object persistence is something about the objects being persisted, so an entity object should know how to persist itself. SelfServicing's code is generated for one database type (e.g. Sqlserver / Oracle.

So Adapter TemplateSet is recommended when the project targets multiple database types or would be able to do that in the future.

David Elizondo | LLBLGen Support Team