Database.CreateConnectionString C# (CSharp) Method

CreateConnectionString() public static method

public static CreateConnectionString ( string host, string user, string password, string database, int port, int minPoolSize, int maxPoolSize, DatabaseType dbType ) : string
host string
user string
password string
database string
port int
minPoolSize int
maxPoolSize int
dbType DatabaseType
return string
    public static string CreateConnectionString(string host, string user, string password, string database, int port, int minPoolSize, int maxPoolSize, DatabaseType dbType)
    {
        if (dbType == DatabaseType.MySql)
            return $"Server={host};User Id={user};Port={port};Password={password};Database={database};Pooling=True;Min Pool Size={minPoolSize};Max Pool Size={maxPoolSize};CharSet=utf8";

        if (dbType == DatabaseType.MSSql)
            return $"Data Source={host}; Initial Catalog = {database}; User ID = {user}; Password = {password};Pooling=True;Min Pool Size={minPoolSize};Max Pool Size={maxPoolSize}";

        return null;
    }
}

Usage Example

        private static ConnectionStringSettings CreateConnectionString(IEnumerable <Claim> claims)
        {
            string dblogin = claims.FirstOrDefault(c => c.Type == "dblogin").Value;
            string dbpass  = claims.FirstOrDefault(c => c.Type == "dbpass").Value;
            string dbname  = claims.FirstOrDefault(c => c.Type == "dbname").Value;

            return(Database.CreateConnectionString("System.Data.SqlClient", @"MCT-NIELS\DATAMANAGEMENT", dbname, dblogin, dbpass));
        }
All Usage Examples Of Database::CreateConnectionString