Explore New Features in Version 5.0

The major new features on Monarch Base 5.0 are:

• Support for .NET 8.0
• Support for Reads with No-Lock on SQL Server

Version 5.0 is backwards compatible with Version 4.0.

Support for .NET 8.0

Monarch Base 5.0 is packaged with assemblies multitargeted for .NET 6.0 and .NET 8.0.

Read with NoLock on SQL Server

DataGate can communicate directly with SQL Server using ADO.NET; this method of communication is known as DataGate Linear. To use DataGate Linear set the (SourceProfile.PlatformAttribute = "*SQLCLIENT".

Starting with version 5.0, DataGate Linear supports reading records without locking them on files that were open for update. While this feature is supported on DataGate for IBM i, this was not possible when accessing SQL Server. Up to now, whenever a file was accessed for update, any read would always apply a lock to the record read. Now with DataGate Linear it is possible to pass the parameter requesting the record not be locked. Notice that DataGate for SQL Server (DSS) does not have this enhancement.

The feature comes with a restriction however. It is not possible to switch between sequential reads with-lock and without-lock. In order to switch modes, a random-access operation is needed between the reads, this operation could be a seek (SETLL) or random-read (CHAIN).