Product name change: Ventura becomes Ventura SQL

In preparation for the yet to be announced Ventura UX product, the Ventura Data Access Layer will be renamed to Ventura SQL.

We are currently in the process of updating the website and the product documentation.

Within the next 2 weeks we will release Ventura SQL 1.0.200 that will implement the new naming.

The EXE and DLL names and NuGet Id's will change.

EXE and DLL names

VenturaStudio.exe becomes VenturaSQLStudio.exe
VenturaUWP.dll becomes VenturaSQL.UWP.dll
VenturaAndroid.dll becomes VenturaSQL.Android.dll
VenturaIOS.dll becomes VenturaSQL.IOS.dll
VenturaWPF.dll becomes VenturaSQL.WPF.dll
VenturaWinForms.dll becomes VenturaSQL.WinForms.dll
VenturaAspNet.dll becomes VenturaSQL.AspNet.dll


Ventura.UWP becomes VenturaSQL.UWP
Ventura.Android becomes VenturaSQL.Android
Ventura.iOS becomes VenturaSQL.iOS
Ventura.WPF becomes VenturaSQL.WPF
Ventura.WinForms becomes VenturaSQL.WinForms
Ventura.AspNet becomes VenturaSQL.AspNet





Priority Support is available

Priority support is an optional service for business customers who need a guaranteed response time of one business day.

Customers will be given an email address to contact support directly.

The price is US$ 500,00 per developer per year.

Click here for more information.

Sql parameters are generated as Nullable

Input and output parameters for Sql Server commands are Nullable, meaning they can always contain the value NULL. This is a feature of Sql Server.

For this reason, the generated C# Recordset code will always implement the Nullable type. Like the 'int?' in this example:

An example of a Nullable output parameter:

Online store opens in January 2017

We planned the RTM release of Ventura and the opening of the online store to go together.

Version 1.0.80 is the RTM release of Ventura, and has been available for download since 13 December, but unfortunately the online store is not ready yet, and will open in January 2017.

Meanwhile, please use a trial license to get started with Ventura. It is a fully functional version of Ventura, the world's best Data Access Layer. Do not worry about the 30-day limit, for we will extend the trial until the store opens.

Release Candidate 4 is available for download

Version 1.0.60 - Release Candidate 4 - Saturday 3 December 2016

A minor fix.
When a resultset column contains an expression like SELECT SUM(Invoice.Total), the column will be nameless. For this reason you have to give the column a name by adding the "AS" clause. For example:
  SELECT SUM(Invoice.Total) AS 'TotalInvoiced'
The Recordset validator did not check for missing column names, and this allowed Recordsets to be generated with empty property names. The validator has been updated.

Release Candidate 3 is available for download

Version 1.0.49 - Release Candidate 3 - Wednesday 23 November 2016

Two small changes.
A Sql variable starting with @@ is a global variable. They are declared and set automatically by Sql server.
When parsing a Sql statement in the Recordset, global variables would inadvertently be added to the parameter list. This was fixed.
Generated C# source code files were written in ASCII format. This was changed to UTF8 to allow for special characters.

Release Candidate 2 is available for download

Two small cosmetic changes only.

The first lines of a generated Recordset .cs source code file now contain the name of the project file, target platform, generator version and the generation timestamp:

/*  Project file: "C:\Projects\\Chinook.venproj"
    Target platform: AspNet
    Generator version: 1.0.48
    Generated on: Monday, November 21, 2016 at 11:50:08 AM

Also, the updateable table information in the class summary was improved:

    /// <summary>
    /// This Recordset can be used to insert, update and delete data for Sql Server table [Chinook].[dbo].[Employee].
    /// All the columns of the updateable table are present in the Recordset:
    /// - Primary key column(s) of the updateable table present in the Recordset: EmployeeId.
    /// - Non-primary key column(s) of the updateable table present in the Recordset: LastName, FirstName, (...)
    /// </summary>

Release Candidate 1 is available for download

I am thrilled to announce that the first RELEASE CANDIDATE for Ventura is available.

It was an incredible amount of work to get to this point, and it was all worth it. When using Ventura for your projects, you will quickly find out how easy it is to retrieve and update Sql Server data. The concept has been polished to perfection. It is all about simplicity and developer productivity. Remember, developing software that is simple to use, is difficult and takes a lot of time and effort.

What is new:

MRU list

After loading Ventura Studio the Start Page will be displayed. The page contains a Most Recently Used (MRU) list of recently opened Ventura projects.