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.
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.
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; rs.Delete(first_record); rs.SaveChanges(); // Data bind to control. listView.ItemsSource = rs;
Friday, June 16, 2017
In preparation for the yet to be announced Ventura UX product, the Ventura Data Access Layer will be renamed to Ventura SQL....
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.
All Ventura libraries are available through NuGet. Here is a list of available Nuget packages:
|Ventura for||NuGet Id|
|Win10 App (UWP)||Ventura.UWP|