Page 1 of 1

How to use NonQuery with an SQLite database

Posted: 08 Nov 2023, 19:26
by JonnyTech
The NonQuery node looks like it can support INSERT queries to a local SQLite database, but I am struggling with the connection string.

From https://www.ventuz.com/support/help/lat ... abase.html
The Database functionality inside Ventuz is based on the ​ADO.NET (System.Data .NET framework and supports ​ODBC, ​MS-SQL, ​OleDB, ​Oracle and ​MySQL
Therefore I should be able to connect at least via System.Data.SQLite.SQLiteConnection or ODBC or any other AOD.NET method.

Can someone share a simple example project or instructions to connect with my local SQLite .db file, please?