/// <summary>
/// Verifies whether a it is possible to connect to a database.
/// </summary>
public bool CanConnect(string databaseType, string connectionString, string server, string database, string login, string password, bool integratedAuth)
{
// we do not test SqlCE or LocalDB connections
if (databaseType.InvariantContains("SqlCe") || databaseType.InvariantContains("SqlLocalDb"))
{
return(true);
}
string providerName;
if (string.IsNullOrWhiteSpace(connectionString) == false)
{
providerName = ConfigConnectionString.ParseProviderName(connectionString);
}
else if (integratedAuth)
{
// has to be Sql Server
providerName = Constants.DbProviderNames.SqlServer;
connectionString = GetIntegratedSecurityDatabaseConnectionString(server, database);
}
else
{
connectionString = GetDatabaseConnectionString(
server, database, login, password,
databaseType, out providerName);
}
var factory = _dbProviderFactoryCreator.CreateFactory(providerName);
return(DbConnectionExtensions.IsConnectionAvailable(connectionString, factory));
}
/// <summary>
/// 打出sql命令参数
/// </summary>
/// <param name="sqlCmd"></param>
/// <param name="sqlParas"></param>
public void SqlOutPutToLogAsync(string sqlCmd, object sqlParas = null)
{
if (this.DbConfig.SqlOutPut == true)
{
DbConnectionExtensions.SqlOutPutToLogAsync(sqlCmd, sqlParas);
}
}
private void SetFolders()
{
var appData = GetApplicationData();
if (appData == null)
{
return;
}
var commandText = "PRAGMA temp_store_directory = '" + appData.TemporaryFolder.Path + "'";
DbConnectionExtensions.ExecuteNonQuery(this, commandText);
}
private InstallState GetInstallState()
{
var installState = InstallState.Unknown;
// TODO: we need to do a null check here since this could be entirely missing and we end up with a null ref
// exception in the installer.
var databaseSettings = _connectionStrings.Get(Constants.System.UmbracoConnectionName);
var hasConnString = databaseSettings != null && _databaseBuilder.IsDatabaseConfigured;
if (hasConnString)
{
installState = (installState | InstallState.HasConnectionString) & ~InstallState.Unknown;
}
var connStringConfigured = databaseSettings?.IsConnectionStringConfigured() ?? false;
if (connStringConfigured)
{
installState = (installState | InstallState.ConnectionStringConfigured) & ~InstallState.Unknown;
}
var factory = _dbProviderFactoryCreator.CreateFactory(databaseSettings?.ProviderName);
var canConnect = connStringConfigured && DbConnectionExtensions.IsConnectionAvailable(databaseSettings?.ConnectionString, factory);
if (canConnect)
{
installState = (installState | InstallState.CanConnect) & ~InstallState.Unknown;
}
var umbracoInstalled = canConnect ? _databaseBuilder.IsUmbracoInstalled() : false;
if (umbracoInstalled)
{
installState = (installState | InstallState.UmbracoInstalled) & ~InstallState.Unknown;
}
var hasNonDefaultUser = umbracoInstalled ? _databaseBuilder.HasSomeNonDefaultUser() : false;
if (hasNonDefaultUser)
{
installState = (installState | InstallState.HasNonDefaultUser) & ~InstallState.Unknown;
}
return(installState);
}
public static List <T> Query <T>(this IDbConnection that, CommandType cmdType, string cmdText, params DbParameter[] cmdParms) => DbConnectionExtensions.GetCurd(that?.GetType()).Ado.Query <T>(that as DbConnection, null, cmdType, cmdText, cmdParms);
public static List <T> Query <T>(this IDbConnection that, string cmdText, object parms = null) => DbConnectionExtensions.GetCurd(that?.GetType()).Ado.Query <T>(that as DbConnection, null, cmdText, parms);
public static IDelete <T1> Delete <T1>(this IDbConnection that) where T1 : class => DbConnectionExtensions.GetCurd(that?.GetType()).Delete <T1>().WithConnection(that as DbConnection);
public static IInsert <T1> Insert <T1>(this IDbConnection that, IEnumerable <T1> source) where T1 : class => DbConnectionExtensions.GetCurd(that?.GetType()).Insert <T1>(source).WithConnection(that as DbConnection);
private static IDbConnection GetConnection(DataOptions dataOptions)
{
return(DbConnectionExtensions.GetConnection(dataOptions));
}
