Mimer SQL Data Provider help 11.0
New Functions
Mimer SQL Data Provider > Overview > Release Notes > New Functions

The Mimer SQL Data Provider 11.0 is developed to provide support for the .NET Framework and .NET Core.

For the latest information about current package please refer to the Mimer SQL developer site.

The provider for the .NET Framework 2 and .NET Framework 4 must have different version numbers to be able to coexist in the assembly cache. Version numbers for the .NET Framework 4 provider therefore end with 4 in the last digit of the version number. Correspondingly the digit 2 is appended for .NET Framework 2 assemblies. In addition a new provider is available for .NET Framework 4.5.2 and later. This is provider has a 5 last in its versions number.

New functions in Mimer SQL Data Provider 11.0.1.24 (11.0.1B):

  1. It is now possible to convert from a BOOLEAN value from the database server to string through MimerDataReader.GetString.

New functions in Mimer SQL Data Provider 11.0.1.14 (11.0.1A):

  1. Support for .NET Core 3.1.
  2. Run-time libraries for .NET Framework 4.5.2, 4.0, 2.0 and .NET Core 3.1 can be now installed as NuGet packages.
  3. A new graphical utility Mimer SQL Monitor is included. It can be used to interactively view the cost of SQL statements executed by the Mimer SQL database server. The server must be version 10.1.3 or later to be used with the utility.
  4. The statistics gathered by SQL Monitor can be picked up by an application using the MimerMonitor and MimerMonitorInstance classes.
  5. Support for Mimer SQL version 11 servers. This includes new internal data formats, more efficient routines for transferring of data between server and client, etc.
  6. Support for new column type BUILTIN.UUID. This is a globally unique identifier. Use method MimerDataReader.GetGuid to retrieve this new type. To insert values either the SQL function BUILTIN.UUID_NEW() can be used. To generate a UUID from code use the MimerDbType.Guid type with the static method System.Guid.NewGuid() in your MimerParameter object.
  7. Support for distributed XA transactions and automatic enlistment. This includes methods such as MimerConnection.EnlistDistributedTransaction and MimerConnection.EnlistTransaction. Please see MimerConnection.ConnectionString enlist attribute for more information about connection options that control enlistment.
  8. A new command line utility MimerDtcRecover.exe to resolve pending distributed transactions after a failure.
  9. Support for integration with Visual Studio 2017 and Visual Studio 2019.

New functions in Mimer SQL Data Provider 10.1.2.14 (10.1.2A):

  1. Support for integration with Visual Studio 2012, 2013, and 2015.
  2. Visual Studio toolbox items are now added automatically for the MimerCommand, MimerCommandBuilder, MimerConnection, and MimerDataAdapter objects.
  3. If a MimerCommand or MimerDataAdapter is dragged onto a form from the Visual Studio toolbox, references to the Mimer.Data.Client assembly is automatically added to the project.

New functions in Mimer SQL Data Provider 10.1.1.22 and 10.1.1.24 (10.1.1B):

  1. When connecting via TCP/IP to a database the system first tries to connect using the numeric TCP/IP address. If a non-numeric address is provided a DNS lookup for the TCP/IP node name is done. By doing it in this order, the system can connect in environments where reverse name lookup in TCP/IP has been incorrectly configured.

New functions in Mimer SQL Data Provider 10.1.0.32 and 10.1.0.34 (10.1.0C):

  1. Support for Visual Studio 2012 integration including documentation.

New functions in Mimer SQL Data Provider 10.1.0.22 and 10.1.0.24 (10.1.0B):

  1. Support for Visual Studio Intellisense provided by including xml documentation files for the Mimer.Data.Client assemblies.

New functions in Mimer SQL Data Provider 10.1.0.12 and 10.1.0.14 (10.1.0A):

  1. Support for Mimer SQL version 10.1 servers. This includes support for both Mimer SQL Engine and Mimer SQL Experience servers. Starting from this version of the Mimer SQL Data Provider, the version number will match Mimer SQL server versions so that it is easier to match the two.
  2. Support for user defined types as provided in Mimer SQL Engine servers from version 10.1. These are specifically integrated with the MimerUserDefinedType class and MimerDataReader.GetUserDefinedType method. Two new meta data information types: "UserDefinedTypes" and "UserDefinedTypesAttributes" have been added to the MimerConnection.GetSchema method.
  3. Support for returning xml explain information via MimerCommand.GetExplainXmlText method when using Mimer SQL Experience servers. This is primarily intended for tools that wants to display a graphical representation of the execution plan for an SQL statement.
  4. New properties MimerError.ErrorLength and ErrorPosition that returns more specific information about SQL compilation errors.
  5. Performance data can be retrieved with a new function MimerConnection.GetPerformanceData.