Class SqlServerTools

Namespace

LinqToDB.DataProvider.SqlServer

Assembly

linq2db.dll

public static class SqlServerTools

Inheritance

object

SqlServerTools

Properties

AutoDetectProvider

public static bool AutoDetectProvider { get; set; }

Property Value

bool

Methods

CreateDataConnection(DbConnection, SqlServerVersion, SqlServerProvider)

public static DataConnection CreateDataConnection(DbConnection connection, SqlServerVersion version = SqlServerVersion.AutoDetect, SqlServerProvider provider = SqlServerProvider.AutoDetect)

Parameters

connection DbConnection

version SqlServerVersion

provider SqlServerProvider

Returns

DataConnection

CreateDataConnection(DbTransaction, SqlServerVersion, SqlServerProvider)

public static DataConnection CreateDataConnection(DbTransaction transaction, SqlServerVersion version = SqlServerVersion.AutoDetect, SqlServerProvider provider = SqlServerProvider.AutoDetect)

Parameters

transaction DbTransaction

version SqlServerVersion

provider SqlServerProvider

Returns

DataConnection

CreateDataConnection(string, SqlServerVersion, SqlServerProvider)

public static DataConnection CreateDataConnection(string connectionString, SqlServerVersion version = SqlServerVersion.AutoDetect, SqlServerProvider provider = SqlServerProvider.AutoDetect)

Parameters

connectionString string

version SqlServerVersion

provider SqlServerProvider

Returns

DataConnection

GetDataProvider(SqlServerVersion, SqlServerProvider, string?, DbConnection?, DbTransaction?)

public static IDataProvider GetDataProvider(SqlServerVersion version = SqlServerVersion.AutoDetect, SqlServerProvider provider = SqlServerProvider.AutoDetect, string? connectionString = null, DbConnection? connection = null, DbTransaction? transaction = null)

Parameters

version SqlServerVersion

provider SqlServerProvider

connectionString string

connection DbConnection

transaction DbTransaction

Returns

IDataProvider

QuoteIdentifier(string)

public static string QuoteIdentifier(string identifier)

Parameters

identifier string

Returns

string

ResolveSqlTypes(Assembly)

Registers spatial types assembly (Microsoft.SqlServer.Types). Also check https://linq2db.github.io/articles/FAQ.html#how-can-i-use-sql-server-spatial-types for additional required configuration steps.

public static void ResolveSqlTypes(Assembly assembly)

Parameters

assembly Assembly

ResolveSqlTypes(string)

Tries to load and register spatial types using provided path to types assembly (Microsoft.SqlServer.Types). Also check https://linq2db.github.io/articles/FAQ.html#how-can-i-use-sql-server-spatial-types for additional required configuration steps.

public static void ResolveSqlTypes(string path)

Parameters

path string