Class MySqlDatasourceConnection

Namespace

YndigoBlue.Velocity.Connections

Assembly

YndigoBlue.Velocity.dll

Connection configuration for MySQL databases.

public class MySqlDatasourceConnection : DatasourceConnection, IDatasourceConnection

Inheritance

object

DatasourceConnection

MySqlDatasourceConnection

Implements

IDatasourceConnection

Remarks

Supports MySQL 8.4 and later versions.

Default port: 3306

Includes geospatial support with distance calculations and SRID transformations.

Examples

// Connect to MySQL with standard configuration
var conn = new MySqlDatasourceConnection
{
    Hostname = "localhost",
    Port = 3306,
    Database = "mydatabase",
    Username = "root",
    Password = "mypassword"
};

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

Properties

AllowLoadLocalInfile

Gets or sets whether to allow LOAD DATA LOCAL INFILE statements. Default is true.

AllowUserVariables

Gets or sets whether to allow user-defined variables. Default is true.

DatasourceType

Gets the datasource type for MySQL.

LengthUnit

Gets or sets the unit of measurement for distance calculations (e.g., "metre", "kilometer"). Default is "metre".