How to user AccessDQEConfiguration

Posts   
 
    
Blex
User
Posts: 3
Joined: 15-Dec-2023
# Posted on: 15-Dec-2023 09:47:02   

I am currently trying to access an Access database. There is AccessDQEConfiguration. (https://www.llblgen.com/Documentation/5.10/ReferenceManuals/LLBLGenProRTF/html/84F2E60F.htm) Unfortunately, I don't know what I need to include to make this DQE available?

Perhaps there is a small example of how I can access an Access DB with .net 6? (SelfService, TwoClasses)

Thanks a lot!

Walaa avatar
Walaa
Support Team
Posts: 14986
Joined: 21-Aug-2005
# Posted on: 15-Dec-2023 13:32:34   

So you have successfully accessed the database from the designer, done the mapping and generated the code?

P.S. the DQEs are shipped in the following path in the LLBLGen installation folder:

\Frameworks\LLBLGen Pro\RuntimeLibraries\CompiledRuntimeLibraries

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39760
Joined: 17-Aug-2003
# Posted on: 16-Dec-2023 09:23:05   

An example:

RuntimeConfiguration.AddConnectionString("NWConnectionString.MS Access (OleDb)", @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=path to your access .accdb file;User Id=admin;Password=;Jet OLEDB:System Database=;Jet OLEDB:Database password=");
RuntimeConfiguration.ConfigureDQE<AccessDQEConfiguration>(c => c.SetTraceLevel(TraceLevel.Verbose)
                                                                   .AddDbProviderFactory(typeof(System.Data.OleDb.OleDbFactory)));
Frans Bouma | Lead developer LLBLGen Pro