Writing DQE

Posts   
 
    
abutler77
User
Posts: 16
Joined: 03-Aug-2007
# Posted on: 30-Sep-2022 21:20:23   

Hi. I'm looking for local database support for my .NET MAUI applications. VistaDB looks like a good fit. Are there any updated notes on developing a DQE? The notes here at https://www.llblgen.com/TinyForum/Thread/15489#86378 are a few years old.

I do not need all the features. My needs are: - C# .NET - .NET 6 - LLBLGen Pro runtime only (Adapter) - no stored procedures or LINQ support

Since VistaDB is very MS SQL like, I am hoping this is not a heavy lift.

Regards, Arthur

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 01-Oct-2022 09:03:08   

I think vistadb can be used with sql server queries, but the metadata for the driver is likely not compatible. So for the queries at runtime, you likely can just use the dqe of sqlserver, perhaps change it a bit to make it use the vistadb factory and e.g. not emit catalog names in the output.

The sourcecode of the dqe's is shipped with the installer and also available in 'My account -> Downloads -> version -> Extras section'. It also contains the sourcecode of the drivers.

As it's a db we don't natively support, there's always some detail that might take a while to implement. We can't assist in this matter so you have to deal with setbacks yourself, but as the sourcecode of all drivers + DQEs is available to you, it should be reasonably straight forward. I'd start with the SQL Server DQE and see what to change to make it work on vistadb. Keep in mind that with catalog/schema overwriting using name -> "" you can already remove schema/catalog names in the queries that are generated.

Frans Bouma | Lead developer LLBLGen Pro
abutler77
User
Posts: 16
Joined: 03-Aug-2007
# Posted on: 01-Oct-2022 19:02:33   

Thank you.