/// <summary>
/// Register tenant shard
/// </summary>
/// <param name="tenantServerConfig">The tenant server configuration.</param>
/// <param name="databaseConfig">The database configuration.</param>
/// <param name="catalogConfig">The catalog configuration.</param>
/// <param name="resetEventDate">If set to true, the events dates for all tenants will be reset </param>
public async void RegisterTenantShard(TenantServerConfig tenantServerConfig, DatabaseConfig databaseConfig, CatalogConfig catalogConfig, bool resetEventDate)
{
//get all database in devtenantserver
var tenants = GetAllTenantNames(tenantServerConfig, databaseConfig);
var connectionString = new SqlConnectionStringBuilder
{
UserID = databaseConfig.DatabaseUser,
Password = databaseConfig.DatabasePassword,
ApplicationName = "EntityFramework",
ConnectTimeout = databaseConfig.ConnectionTimeOut
};
foreach (var tenant in tenants)
{
var tenantId = GetTenantKey(tenant);
var result = await Sharding.RegisterNewShard(tenant, tenantId, tenantServerConfig.TenantServer, databaseConfig.DatabaseServerPort, catalogConfig.ServicePlan);
if (result)
{
// resets all tenants' event dates
if (resetEventDate)
{
#region EF core
////https://github.com/aspnet/EntityFramework/issues/7032
//using (var context = new TenantDbContext(Sharding.ShardMap, tenantId, connectionString.ConnectionString))
//{
// //context.Database.ExecuteSqlCommand("sp_ResetEventDates");
//}
#endregion
}
}
}
}
/// <summary>
/// Gets all tenant names from tenant server
/// </summary>
/// <param name="tenantServerConfig">The tenant server configuration.</param>
/// <param name="databaseConfig">The database configuration.</param>
/// <returns></returns>
private List <string> GetAllTenantNames(TenantServerConfig tenantServerConfig, DatabaseConfig databaseConfig)
{
List <string> list = new List <string>();
string conString = $"Server={databaseConfig.SqlProtocol}:{tenantServerConfig.TenantServer},{databaseConfig.DatabaseServerPort};Database={""};User ID={databaseConfig.DatabaseUser};Password={databaseConfig.DatabasePassword};Trusted_Connection=True;Encrypt=False;Connection Timeout={databaseConfig.ConnectionTimeOut};";
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("SELECT name, * from sys.databases WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb', 'CatalogDb') AND state_desc NOT IN ('OFFLINE')", con))
{
using (IDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
list.Add(dr[0].ToString());
}
}
}
}
return(list);
}