Ventura SQL 2.7.1000 is available for download.
This version add the code-snippet creator for Ventura UWP.
Ventura UWP is a complete solution for rapidly developing LOB applications, and will be available soon.
Added design and runtime support for the Microsoft.Data.Sqlite provider.
This provider works with UWP projects. We had a problem to get SQLite.org's System.Data.SQLite to run on UWP.
Ventura SQL 2.6 is available for download.
Deleted Recordsets will also be deleted from the Visual Studio C# output projects. All folders you specify in a Ventura SQL project are managed by Ventura SQL. Ventura will empty the folders as needed. So do not place other files in these folder, as they will be deleted at code generation time.
"Auto-run Auto Create"
The Auto Create Recordsets module runs when code generation is started.
This makes Ventura easier to use when modifying tables in the database.
Before: a) modify/add table column. b) delete Auto Create folder. c) run Auto Create d) run Generate.
New: a) modify/add table column. b) run Generate.
A preview for Ventura SQL 2.5 is available for download.
This is a major update that makes Ventura SQL a mature product with extended functionality.
The code generator, Ventura SQL Studio is feature complete:
- Select any ADO.NET Provider in the provider page;
- A new Advanced Provider Settings dialog;
- When creating a new project, there is a list of templates to choose from;
- A new Recordset parameter definition dialog;
- The Auto Create Recordsets module has been added;
- A lot of improvements to the generated Recordset C# code;
The documentation and website have not been updated yet.
I am still tweaking the runtimes, to make loading and saving data with the Recordsets as simple and productive as possible.
Later this month, Ventura SQL version 2.5 will be available for download.
This version is not locked down to SQL Server anymore. You can consume any ADO.NET Provider with Ventura.
Use Ventura for a 3-tier solution with SQL Server, or use Ventura with a locally installed SQLite database. There are no limitations.
Ventura SQL is the only Data Access Layer with integrated middle-tier.