private IDbConnection GetConnection(DatabaseEngine providerType, string connectionString) { var provider = _connectionProviderFactory.GetInstance(providerType); var cn = provider.GetCustomConnection(connectionString); return(cn); }
private void ExecuteScriptFile(DatabaseEngine serverType, string server, string file) { var scriptContent = File.ReadAllText(file); var provider = _connectionProviderFactory.GetInstance(serverType); using var cn = provider.GetConnectionFromParams(server); var cmd = cn.CreateCommand(); cmd.CommandText = scriptContent; cmd.Connection = cn; cn.ExecuteCommand(cmd); }