Application for MsAccess and MsSQL

Posts   
 
    
NLEdward
User
Posts: 5
Joined: 24-Nov-2005
# Posted on: 18-May-2006 10:22:24   

Hello,

is it possible with LLBLgen to write an application that uses MsAccess or MsSQL2005 (both databases have the same structure), only by using a different connectionstring. So based on a setting the program uses the MsAccess libraries of the MsSQL2005 libraries. I use Adapter Scenario (Full/Safe) Vs.Net 2005 (1.0.2005.1.10232005).

Thanks in advance Edward

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 18-May-2006 14:16:38   

Yes, you'd generate the code once for MSSQL and once for MSAccess, and use only one of those generated DBGerenric dlls. (they should be identical, if the schema are identical).

Then by using a config file or so you may detect which DBSpecific dll to use with the corresponding connection string.