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.
Direct SQL connections are not desirable in modern apps, as you do not want to expose your organization's SQL statements to outsiders. Ventura SQL 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 Ventura SQL you define the data access layer by entering SQL statements in Ventura SQL 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.
Ventura SQL uses ADO.NET to access the database. ADO.NET Providers are available for a wide range of databases.
Ventura SQL 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.
Ventura SQL is made up of 3 distinct parts
- Ventura SQL 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.