Represents a connection to a Microsoft SQL Server database.

Namespace

Interfaces

IDatabase

Base Types

object

graph BT Type-->Base0["object"] Type-.->Interface0["IDatabase"] click Interface0 "/api/DbSyncKit.DB.Interface/IDatabase" Type["Connection"] class Type type-node

Syntax

public class Connection : IDatabase

Constructors

Name	Summary
Connection()	Initializes a new instance of the `Connection` class.
Connection(string, bool, string, string, string)	Initializes a new instance of the `Connection` class with the specified parameters.

Properties

Name	Property Type	Summary
Provider	DatabaseProvider	Gets the database provider type, which is MSSQL for this class.

Methods

Name	Return Value	Summary
ExecuteQuery(string, string)	DataSet	Executes a SQL query and returns the result as a DataSet.
GetConnectionString()	string	Gets the connection string based on the provided parameters.
TestConnection()	bool	Tests the database connection.