How to use NonQuery with an SQLite database

Q and A about functionality and how to solve a special task for your application.

Moderator: Support

Post Reply
Posts: 1
Joined: 07 Nov 2023, 20:42

How to use NonQuery with an SQLite database

Post by JonnyTech » 08 Nov 2023, 19:26

The NonQuery node looks like it can support INSERT queries to a local SQLite database, but I am struggling with the connection string.

From ... 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?

Post Reply