Skip to content
| Marketplace
Sign in
Visual Studio>Tools>Ventura SQL - The 3-tier SQL framework for C# projects

Ventura SQL - The 3-tier SQL framework for C# projects

Frank Th. van de Ven

|
131 clicks
| (0) | Free
The only SQL framework with integrated Web Service middle-tier. Runtime for .Net Core, .Net Framework, Xamarin and Mono. The middle-tier runs on ASP.NET Core and ASP.NET.

Recordsets

The Ventura SQL Studio program generates C# code for recordsets and adds them to your Visual Studio C# projects. A recordset is a collection of rows and columns containing the resultset(s) for a simple SELECT statement or a complex SQL script. Imagine a recordset as a wrapper around a SQL script. For each script, there is a different recordset class. Recordsets can be read-only or updateable and have built in advanced change-tracking. Recordset columns fully support data-binding.

image__8.png

Among other things, the recordset contains the schema definition as returned for each column by the database. The following illustration shows, in pseudo-code, what's inside a recordset class:

image__9.png

Save oodles of time

Ventura SQL is the 3-tier SQL framework for C# projects where database access and web services are integrated into a single solution. Save lots of development time. Ventura SQL replaces Entity Framework, ORM, LINQ and Web API with an enterprise-level solution.

image.png

SQL statements

You only need to enter SQL statements in Ventura SQL Studio and click the Generate button. The generated SQL framework code for client and server is injected into your C# projects and the runtime does the rest. There is no need to define models and mappings. This is a genius concept that maximizes programmer productivity.

image__1.png

Perfectly designed

Ventura SQL was designed with attention to detail. The API is close to perfect, convenient and easy to use. We did the low-level plumbing so you can stay focused on the business logic.

image__2.png

Record breaking performance

The high performance FrameStream API transmits data in the fastest way possible. As the runtime does not use object mapping and reflection, data is accessed at record speed.

image__3.png

Any C# project

Ventura SQL is compatible with all C# platforms including UWP, WPF, WinForms, Xamarin.iOS, Xamarin.Android, ASP.NET, ASP.NET Core and Mono.

image__4.png

Security

The server-side Data Sentry protects your database without hindering bona-fide users.

image__5.png

ADO.NET Providers

Ventura is compatible with all ADO.NET providers: SQL Server (SqlClient), Oracle, DB2, MySQL, PostgreSQL, MariaDB, SQLite, CData and many more.

image__6.png

Quickstart

Get started quickly with the project templates, sample recordsets, data and Visual Studio C# projects. We also provide a Line of Business software programming pattern on how to optimally use recordsets in your code.

image__7.png

  • Contact us
  • Jobs
  • Privacy
  • Terms of use
  • Trademarks
© 2019 Microsoft