On this page, project specific options are set.

Database Connection

Connecting to a database needs a connection string. Figuring out the connection string is probably the hardest part of using Ventura SQL, and this is the first thing you need to do when creating a new project.



Select ADO.NET Provider button. Opens the Select ADO.NET Provider page.


Advanced Provider Settings. Opens the Advanced Provider Settings window.


Connection string. The database connection string. In the documentation for the provider or database server you find instructions on how to assemble a connection string.


See topic Connection strings for sample connection strings.


Use the macro '{pf}' to have Ventura SQL studio dynamically insert the project folder when opening the database connection. The folder name is without trailing backslash. The macro only works in Ventura SQL Studio and not with the Ventura runtime in your projects.


Test connection string. Opens and closes the database connection and displays the error message if there is a problem.


Copy to clipboard. Copies the connection string into the Windows clipboard.

Auto Create Recordsets

Click the [Settings] button to open the Auto Create Recordsets Settings window.

Visual Studio C# Project

Up to 6 C# output projects can be defined.


Enabled checkbox. When unchecked, the project definition is excluded from code generation.


In the text-input box, the path to the VS project file (.csproj) is specified relative to the location of the Ventura SQL Studio project file (.venproj).


Select C# project.  Select a C# project file in a file open dialog. The dialog opens with either the C# project file folder selected, or the Ventura SQL project file folder selected.


Target platform. Currently only .Net Standard is available.


Generate with Direct ADO.NET connection support. When checked, the generated recordset class will contain the SQL script allowing direct ADO.NET connections. When unchecked, the recordset can only retrieve and update data through the HTTP web service.