private static void CopyShardletIntoTempTables(string shardingKey, ShardConnection sourceConnection,
ShardConnection destinationConnection, string uniqueProcessString)
{
// copy the shardlet data to the temporary tables
var copier = new BulkCopier(sourceConnection.ConnectionString, destinationConnection.ConnectionString);
using (var sourceSqlConnection = new ReliableSqlConnection(sourceConnection.ConnectionString))
{
sourceSqlConnection.Open();
CopySalesOrderHeadersIntoTempTable(shardingKey, uniqueProcessString, sourceSqlConnection, copier);
CopySalesOrderDetailsIntoTempTable(shardingKey, uniqueProcessString, sourceSqlConnection, copier);
CopyShoppingCartItemsToTempTable(shardingKey, uniqueProcessString, sourceSqlConnection, copier);
}
}
private static void CopyShoppingCartItemsToTempTable(string shardingKey, string uniqueProcessString,
ReliableSqlConnection sourceSqlConnection, BulkCopier copier)
{
// Copy shopping cart items from source to destination
var shoppingCartItemReaderCommand =
new SqlCommand("[Shardlets].[GetShoppingCartItemsByCustomerId]", sourceSqlConnection.Current)
{
CommandType = CommandType.StoredProcedure
};
shoppingCartItemReaderCommand.Parameters.Add(CreateShardingKeyParameter(shardingKey));
var shoppingCartItemReader = shoppingCartItemReaderCommand.ExecuteReader();
var shoppingCartItemTableName = GetTempTableName(uniqueProcessString, "[Shardlets].[ShoppingCartItem_");
copier.Copy(shoppingCartItemReader, shoppingCartItemTableName);
shoppingCartItemReader.Close();
}
private static void CopySalesOrderHeadersIntoTempTable(string shardingKey, string uniqueProcessString,
ReliableSqlConnection sourceSqlConnection, BulkCopier copier)
{
// Copy sales order header from source to destination
var headerReaderCommand =
new SqlCommand("[Shardlets].[GetSalesOrderHeadersByCustomerId]", sourceSqlConnection.Current)
{
CommandType = CommandType.StoredProcedure
};
headerReaderCommand.Parameters.Add(CreateShardingKeyParameter(shardingKey));
var headerReader = headerReaderCommand.ExecuteReader();
var headerTargetTableName = GetTempTableName(uniqueProcessString, "[Shardlets].[SalesOrderHeader_");
copier.Copy(headerReader, headerTargetTableName);
headerReader.Close();
}
