The 3-tier SQL framework for C# projects.

Save 80% of development time and costs as database access and web service middle-tier are integrated into a single solution. No need to learn Entity Framework, ORM, LINQ and Web API. 

Ventura was specifically designed for developing Line of Business (LOB) applications, that deal with large numbers of small database transactions (OLTP) by a large number of users.

Direct SQL connections are not desirable in modern apps, as you do not want to expose your organization's SQL statements to outsiders. VenturaSQL is an SQL framework with an integrated middle-tier. In a 3-tier solution, the client does not connect to the database directly, instead it retrieves an updates data through middle layer web services via HTTP.

In VenturaSQL you define the data access layer by entering SQL statements in VenturaSQL Studio. Ventura Studio generates recordset source based on the resultset(s) as returned by the database. 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.

VenturaSQL uses ADO.NET to access the database. ADO.NET Providers are available for a wide range of databases. 

VenturaSQL uses Microsoft's IIS (Internet Information Server) or Kestrel as the middle-tier web server. On Linux, the web server to use is Microsoft's Kestrel, optionally with a reverse-proxy server like Nginx or Apache. 

VenturaSQL is made up of 3 distinct parts

  • VenturaSQL Studio is the program used to create recordset definitions, and generate C# source code for your Visual Studio projects;
  • The Client and Server runtime DLLs. This is the engine used to make the recordset classes work;
  • The LOB Application Programming Pattern. We designed an optimal way to use recordsets in the Line of Business applications you are developing.