SQLite and ATTACH database

BIZ TMS Aurelius
1

I wonder, how I can use the SQLite ATTACH from within Aurelius and how I then can adresse the tables of the second database via their aliases.

tx for any info!
Bernd

2

You can execute arbitrary SQL statements in Aurelius using Connection.CreateStatement method. Thus you can execute the ATTACH statement directly.

Since table name prefix is not required if the table names in the attached database are unique, you can then simply use Aurelius normally. If you need to prefix the table, you can add the prefix to the mapped table name itself.