This document provides a peek into upcoming new features and changes for Ventura SQL Studio. Plans are subject to change.

Central data inspection

Centrally inspect and modify ADO.NET data before INSERT/UPDATE/DELETE.

This allows the developer to centrally update a column, like setting the DateTime "Modified" column to the current time. Or you can register information about the update to a log.

This feature is expected for the version 2.8 update.

Data Sentry

Inspect and modify received web service data before the INSERT/UPDATE/DELETE is executed on server.

The Data Sentry is similar to "central data inspection," but this module runs on the middle-tier server.

Here you can inspect data before it is send to the database.

For example: You can detect that user John tries to update customer record 100. If John is not allowed to do that, you can abort the transaction.

This feature is expected for the version 2.8 update.

Blazor (WebAssembly) support

This is definitely going to happen.

Blazor is a .NET web framework that allows developers to run C# in the browser. Blazor compiles C# code into WebAssembly format.

WebAssembly (WASM) is a small, fast binary format that promises near-native performance for web applications. WebAssembly is designed to be a compilation target for any language, JavaScript being just one of them. Every major browser supports WebAssembly.

At the moment Blazor is still in the experimental stage. We are going to wait supporting it until the alpha release is a bit more mature. In theory the Ventura SQL runtime will work with Blazor without any changes, as Blazor is announced to support .Net Standard 2.0

See Rick Strahl's article on Blazor in the September/October 2018 issue of CODE Magazine.