ADR: Database connection technology. - SystemModeller/primarysystem GitHub Wiki

I have looked to see the latest Database Connection technology, given the use of MS SQL server. Microsoft have a page detailing the suggested development routes (28/12/2020) that a user should follow.

https://docs.microsoft.com/en-us/sql/connect/sql-connection-libraries?view=sql-server-ver15

This article provides download links to connection modules or drivers that your client programs can use for interacting with Microsoft SQL Server, and with its twin in the cloud Azure SQL Database. C++ ODBC / OLE DB

https://docs.microsoft.com/en-us/sql/connect/connect-history?view=sql-server-ver15

Microsoft ODBC Driver for SQL Server After SQL Server 2012, the primary ODBC driver for SQL Server has been developed and released as the Microsoft ODBC Driver for SQL Server. For more information, see the Microsoft ODBC Driver for SQL Server documentation.

ADO.NET ADO.NET is a set of classes that defines an interface for accessing any kind of data source, both relational and non-relational. ADO.NET was introduced with the Microsoft .NET Framework and continues to be improved and maintained in .NET. The SqlClient library is an ADO.NET data provider that provides connectivity to SQL Server and Azure SQL data sources.

OLE DB There are three distinct generations of Microsoft OLE DB providers for SQL Server. In 2017, OLE DB data access technology was later undeprecated and a new planned release was announced for 2018. The new OLE DB provider is called the "Microsoft OLE DB Driver for SQL Server" (MSOLEDBSQL) and is currently maintained and supported.

Microsoft.Data.SqlClient Introduced in 2019, the Microsoft SqlClient Data Provider for SQL Server is an ADO.NET data provider supporting applications that target .NET Framework, .NET Core, and .NET Standard. For more information about the Microsoft.Data.SqlClient namespace, see Microsoft ADO.NET for SQL Server.

Further: https://docs.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server?view=sql-server-ver15 3. Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) OLE DB was undeprecated and released in 2018.

The new OLE DB provider is called the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL). The new provider will be updated with the most recent server features going forward.