Are you developing a Windows 10 (UWP) App and need to retrieve and update Sql Server data?
Xamarin.Android, Xamarin.iOS, ASP.Net, WPF and WinForms runtimes also included.

Introducing the Ventura Data Access Layer for .Net with C#:

UWP, Android and iOS

Direct Sql connections are not supported or desirable in modern apps. This makes sense as you do not want to expose your organisation's Sql statements to outsiders.

That is why you need to use a 3-tier architecture for modern apps.

We are the pioneer in integrating the middle-tier into the Data Access Layer.

In a 3-tier solution, the client does not connect to the database directly, instead it retrieves and updates data through a middle layer Web server.

ADO.NET & EF

Ventura is the perfect ADO.NET enhancement. Ventura's Recordsets make retrieving and updating Sql server data a breeze. Recordsets replace SqlDataAdapter, DataSet, DataTable and SqlDataReader calls.

There is no need to learn Entity Framework and LINQ and Web services as you will only be needing Ventura Recordsets to retrieve and update Sql server data at record-breaking performance in a genuine 3-tier architecture.

Sql statements!

In Ventura you define the Data Access Layer by entering Sql statements in Ventura Studio. The DAL is then generated in the form of Recordsets, based on the resultset(s) as returned by Sql server.

This is a genius concept that maximizes programmer productivity.

There is no need to define models or mappings, and that is what keeps your Data Access Layer simple, understandable and manageable.

Ventura makes defining your Data Access Layer as easy as entering a Sql statement and clicking the [Generate] button.

Using the generated Recordset in your code to retrieve and update Sql Server data is a breeze.

VenturaConfig.DefaultConnector = new Connector("DefaultConnection", 
       ConnectorMode.Http, "https://venturatools.com/Ventura.FSPRO");
 
ChinookEmployeeRecordset rs = new ChinookEmployeeRecordset();
 
rs.ExecSql(5 /* EmployeeId */ );
 
// Add a record.
rs.Append();
rs.FirstName = "Robert";
rs.LastName = "King";
 
// Enumerate records.
foreach (var record in rs)
    record.Phone = "+1 (403) 456-9986";
 
// Delete a record.
var first_record = rs[0];
rs.Delete(first_record);
 
rs.SaveChanges();
 
// Data bind to control.
listView.ItemsSource = rs;

Latest blog post

Friday, June 16, 2017

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

Read the Blog

Product status

Thursday, June 29, 2017. Version 1.0.200, is available for download.

The installer can be found on the Download page.

A designer knows he has achieved perfection not when there is nothing left to add, but when there is nothing left to take away.

Antoine de Saint-Exupery

Download with NuGet

All Ventura libraries are available through NuGet. Here is a list of available Nuget packages:

Ventura for NuGet Id
Win10 App (UWP) Ventura.UWP
Android (Xamarin) Ventura.Android
iOS (Xamarin) Ventura.iOS
WPF Ventura.WPF
WinForms Ventura.WinForms
ASP.Net Ventura.AspNet