//-------------------------------------------------------------------------
private bool Initialise(DbConnectionSettings settings)
{
try
{
Connection = new SqlConnection(settings.ConnectionString);
Connection.Open();
}
catch (Exception ex)
{
// Something's gone wrong, close any connections that were opened.
try
{
if (Connection != null)
{
Connection.Close();
}
}
catch {}
throw new Exception(
"Database connection error." +
Environment.NewLine +
Environment.NewLine +
ex.Message);
}
return(true);
}
//-------------------------------------------------------------------------
public DbConnection(string serverName,
string dbName,
string username,
string password)
{
DbConnectionSettings settings = new DbConnectionSettings();
settings.ServerName = serverName;
settings.DbName = dbName;
settings.SqlUserName = username;
settings.SqlPassword = password;
settings.UseSqlAuthentication = (settings.SqlUserName.Length > 0);
Initialise(settings);
}