Functions to interact with Micosoft SQL server.

Because my library can be referenced by a Framework or Core project, I created two different projects in the same solution that share the same source code but with different target. So one project is targeted to Framework 4.x (where I defined the variable FRAMEWORK) and the other to Core 8 (where I defined the variable CORE)

In this case the compiler uses different library for Sql, the classical System.Data.SqlClient for Framework project and the more recent Microsoft.Data.SqlClient for Core project (where System.Data.SqlClient is deprecated).

Here the required Imports:

Imports System.Data
Imports System.Reflection
Imports System.Text.RegularExpressions

#If CORE Then
Imports Microsoft.Data.SqlClient
#ElseIf FRAMEWORK Then
Imports System.Data.SqlClient
#End If

Imports System.Data
Imports System.Reflection
Imports System.Text.RegularExpressions

#If CORE Then
Imports Microsoft.Data.SqlClient
#ElseIf FRAMEWORK Then
Imports System.Data.SqlClient
#End If

The Functions list:

• Check Sql Connection
• Execute Non Query Sql Cmd (Signature 1)
• Execute Non Query Sql Cmd (Signature 2)
• Execute Query On DataTable
• Load Sql Table
• Read Sql Table Chunk
• Sql Bulk Write
• Table Exists