Class SqlServerDatasourceConnection

Namespace

YndigoBlue.Velocity.Connections

Assembly

YndigoBlue.Velocity.dll

Connection configuration for Microsoft SQL Server databases.

public sealed class SqlServerDatasourceConnection : DatasourceConnection, IDatasourceConnection

Inheritance

object

DatasourceConnection

SqlServerDatasourceConnection

Implements

IDatasourceConnection

Examples

// Connect to SQL Server with basic authentication
var conn = new SqlServerDatasourceConnection
{
    Hostname = "localhost",
    Port = 1433,
    Database = "mydatabase",
    Username = "sa",
    Password = "MyP@ssw0rd"
};

using (var m = new Manager(conn))
{
    var schema = m.LoadSchema("dbo");
    // Perform database operations
}

Remarks

Warning

SQL Server database support is not available in the Community Edition of Velocity. It requires the Full Edition.

Supports SQL Server 2016 and later versions.

Default port: 1433

Properties

DatasourceType

Gets the datasource type for SQL Server.

TrustServerCertificate

Gets or sets whether to trust the server certificate without validation. Default is true.