public SchemaInitializationCommand(MappingSchema mappingSchema, IReadOnlyCollection <Type> dataTypes, IConnectionStringIdentity connectionStringIdentity, IReadOnlyCollection <string> sqlSchemas)
{
MappingSchema = mappingSchema;
DataTypes = dataTypes;
SqlSchemas = sqlSchemas;
ConnectionStringIdentity = connectionStringIdentity;
}
private DataConnection CreateDataConnection(IConnectionStringIdentity connectionStringIdentity, MappingSchema mappingSchema)
{
var connectionString = _connectionStringSettings.GetConnectionString(connectionStringIdentity);
var dataConnection = SqlServerTools.CreateDataConnection(connectionString);
dataConnection.AddMappingSchema(mappingSchema);
dataConnection.CommandTimeout = 0;
return(dataConnection);
}
public string GetConnectionString(IConnectionStringIdentity connectionStringIdentity)
{
string connectionString;
if (!_connectionStringsMap.TryGetValue(connectionStringIdentity, out connectionString))
{
throw new KeyNotFoundException(string.Format("Can't find connection string for identity '{0}'", connectionStringIdentity));
}
return connectionString;
}
public StorageDescriptor(
IConnectionStringIdentity connectionStringIdentity,
MappingSchema mappingSchema,
Tenant?tenant = null,
TimeSpan?commandTimeout = null)
{
ConnectionStringIdentity = connectionStringIdentity;
MappingSchema = mappingSchema;
Tenant = tenant;
CommandTimeout = commandTimeout ?? DefaultCommandTimeout;
}
public string GetConnectionString(IConnectionStringIdentity identity, Tenant tenant)
{
switch (identity)
{
case ErmConnectionStringIdentity _:
return(ConfigurationManager.ConnectionStrings[$"Erm.{tenant:G}"]?.ConnectionString);
default:
return(GetConnectionString(identity));
}
}
public Server CreateServerConnection(IConnectionStringIdentity connectionStringIdentity)
{
var connectionString = _connectionStringSettings.GetConnectionString(connectionStringIdentity);
var server = new Server();
server.ConnectionContext.ConnectionString = WithoutInitialCatalog(connectionString);
if (!server.ConnectionContext.IsOpen)
{
server.ConnectionContext.Connect();
}
return server;
}
public Database CreateDatabaseConnection(IConnectionStringIdentity connectionStringIdentity)
{
var connectionString = _connectionStringSettings.GetConnectionString(connectionStringIdentity);
var server = new Server();
server.ConnectionContext.ConnectionString = WithoutInitialCatalog(connectionString);
if (!server.ConnectionContext.IsOpen)
{
server.ConnectionContext.Connect();
}
return server.Databases[GetDatabaseName(connectionString)];
}
public IDisposable TemporaryRemoveViews(IConnectionStringIdentity connectionStringIdentity, IEnumerable<string> essentialViewNames)
{
var connectionString = _connectionStringSettings.GetConnectionString(connectionStringIdentity);
var database = GetDatabase(connectionString);
var views = new List<StringCollection>();
foreach (var view in database.Views.Cast<View>()
.Where(v => !v.IsSystemObject)
.Where(v => !essentialViewNames.Contains($"{v.Schema}.{v.Name}", StringComparer.InvariantCultureIgnoreCase)).ToArray())
{
views.Add(view.Script());
view.Drop();
}
return new ViewContainer(connectionString, views);
}
public IDisposable TemporaryRemoveViews(IConnectionStringIdentity connectionStringIdentity, IEnumerable <string> essentialViewNames)
{
var connectionString = _connectionStringSettings.GetConnectionString(connectionStringIdentity);
var database = GetDatabase(connectionString);
var views = new List <StringCollection>();
foreach (var view in database.Views.Cast <View>()
.Where(v => !v.IsSystemObject)
.Where(v => !essentialViewNames.Contains($"{v.Schema}.{v.Name}", StringComparer.InvariantCultureIgnoreCase)).ToArray())
{
views.Add(view.Script());
view.Drop();
}
return(new ViewContainer(connectionString, views));
}
public string GetConnectionString(IConnectionStringIdentity identity)
{
switch (identity)
{
case ValidationRulesConnectionStringIdentity _:
return(ConfigurationManager.ConnectionStrings["ValidationRules"].ConnectionString);
case AmsConnectionStringIdentity _:
return(ConfigurationManager.ConnectionStrings["Ams"].ConnectionString);
case RulesetConnectionStringIdentity _:
return(ConfigurationManager.ConnectionStrings["Rulesets"].ConnectionString);
default:
throw new ArgumentException($"Unsupported identity type {identity.GetType().Name}", nameof(identity));
}
}
public DefaultConnectionStringIdentityResolver(IConnectionStringIdentity defaultConnectionStringName)
{
_defaultConnectionStringName = defaultConnectionStringName;
}
public MasterConnectionStringFeature(IConnectionStringIdentity connectionStringIdentity)
{
ConnectionStringIdentity = connectionStringIdentity;
}
public StorageDescriptorFeature(ReplicationDirection direction, IConnectionStringIdentity connectionStringName, MappingSchema mappingSchema)
{
Direction = direction;
ConnectionStringName = connectionStringName;
MappingSchema = mappingSchema;
}
public StorageDescriptorFeature(ReplicationDirection direction, IConnectionStringIdentity connectionStringName, MappingSchema mappingSchema)
{
Direction = direction;
ConnectionStringName = connectionStringName;
MappingSchema = mappingSchema;
}
public StorageDescriptor(IConnectionStringIdentity connectionStringIdentity, MappingSchema mappingSchema, TimeSpan? commandTimeout = null)
{
ConnectionStringIdentity = connectionStringIdentity;
MappingSchema = mappingSchema;
CommandTimeout = commandTimeout ?? DefaultCommandTimeout;
}
public string GetConnectionString(IConnectionStringIdentity identity, Tenant tenant) =>
identity switch
{
public string GetConnectionString(IConnectionStringIdentity identity, Tenant tenant) => _connectionStringProvider.GetConnectionString(identity, tenant);
public string GetConnectionString(IConnectionStringIdentity identity) => _connectionStringProvider.GetConnectionString(identity, _tenantProvider.Current);
public string GetConnectionString(IConnectionStringIdentity identity)
{
return(_connectionStringSettings.GetConnectionString(_mapping[identity]));
}
public string GetConnectionString(IConnectionStringIdentity identity) => _connectionStringProvider.GetConnectionString(identity);
public BulkReplicationMetadataBuilder To(IConnectionStringIdentity connectionString, MappingSchema mappingSchema)
{
AddFeatures(new StorageDescriptorFeature(ReplicationDirection.To, connectionString, mappingSchema));
return(this);
}
public string GetConnectionString(IConnectionStringIdentity identity, Tenant tenant)
{
throw new System.NotImplementedException();
}
public string GetConnectionString(IConnectionStringIdentity identity)
{
return _connectionStringSettings.GetConnectionString(_mapping[identity]);
}
