/// <summary>
/// Methods of adding a record in the database (Storage1).
/// Called from the methods TransactionScopeWithStorage.
/// </summary>
/// <param name="context">The context of the interaction with the database.</param>
/// <param name="entity">The object to add the type of User.</param>
/// <param name="count">Counter.</param>
/// <param name="commitCount">Meaning - "every time commitCount doing SaveChanges()".</param>
/// <param name="recreateContext">It must be true.</param>
/// <returns>The context of the interaction with the database.</returns>
private static Storage1Context AddToStorage1(Storage1Context context, User entity, int count, int commitCount, bool recreateContext)
{
context.Set<User>().Add(entity);
if (count%commitCount != 0)
return context;
context.SaveChanges();
if (!recreateContext)
return context;
context.Dispose();
context = new Storage1Context();
context.Configuration.AutoDetectChangesEnabled = false;
return context;
}
/// <summary>
/// The method for forming transactions with Storage1.
/// Called from an event handler btnFill_Click.
/// </summary>
/// <param name="users">The list of users you want to add.</param>
public void TransactionScopeWithStorage1(List<User> users)
{
using (var scope = new TransactionScope())
{
Storage1Context context = null;
try
{
context = new Storage1Context();
context.Configuration.AutoDetectChangesEnabled = false;
var count = 0;
foreach (var entityToInsert in users)
{
++count;
context = AddToStorage1(context, entityToInsert, count, 100, true);
}
context.SaveChanges();
}
finally
{
context?.Dispose();
}
scope.Complete();
}
}
/// <summary>
/// Event: Make all friends.
/// </summary>
/// <param name="sender">Sender</param>
/// <param name="e">Event Args</param>
override protected void btnFriends_Click(object sender, RoutedEventArgs e)
{
var arrayNumberFriends = new int[500000];
for (var i = 0; i < 500000; i++) arrayNumberFriends[i] = 0;
var rnd = new Random();
var storage1Context = new Storage1Context();
var storage2Context = new Storage2Context();
var storage3Context = new Storage3Context();
var storage4Context = new Storage4Context();
var storage5Context = new Storage5Context();
storage1Context.Configuration.AutoDetectChangesEnabled = false;
storage2Context.Configuration.AutoDetectChangesEnabled = false;
storage3Context.Configuration.AutoDetectChangesEnabled = false;
storage4Context.Configuration.AutoDetectChangesEnabled = false;
storage5Context.Configuration.AutoDetectChangesEnabled = false;
for (var i = 0; i < 500000; i++)
{
if (arrayNumberFriends[i] == 5)
continue;
var shortage = 5 - arrayNumberFriends[i];
for (var j = 0; j < shortage; j++)
{
var friendId = rnd.Next(1, 500001);
if (i == friendId)
friendId = rnd.Next(1, 500001);
if (i <= 100000)
{
storage1Context.Friends.Add(new Friends { User_Id = i + 1, Friend_Id = friendId });
storage1Context.SaveChanges();
arrayNumberFriends[i]++;
}
else if (i > 100000 && i < 200000)
{
storage2Context.Friends.Add(new Friends { User_Id = i, Friend_Id = friendId });
storage2Context.SaveChanges();
arrayNumberFriends[i]++;
}
else if (i > 200000 && i < 300000)
{
storage3Context.Friends.Add(new Friends { User_Id = i, Friend_Id = friendId });
storage3Context.SaveChanges();
arrayNumberFriends[i]++;
}
else if (i > 300000 && i < 400000)
{
storage4Context.Friends.Add(new Friends { User_Id = i, Friend_Id = friendId });
storage4Context.SaveChanges();
arrayNumberFriends[i]++;
}
else if (i > 400000 && i < 500000)
{
storage5Context.Friends.Add(new Friends { User_Id = i, Friend_Id = friendId });
storage5Context.SaveChanges();
arrayNumberFriends[i]++;
}
if (friendId > 1 && friendId < 100000)
{
storage1Context.Friends.Add(new Friends { User_Id = friendId, Friend_Id = (i <= 100000) ? i + 1 : i });
storage1Context.SaveChanges();
arrayNumberFriends[friendId]++;
}
else if (friendId > 100000 && friendId < 200000)
{
storage2Context.Friends.Add(new Friends { User_Id = friendId, Friend_Id = (i <= 100000) ? i + 1 : i });
storage2Context.SaveChanges();
arrayNumberFriends[friendId]++;
}
else if (friendId > 200000 && friendId < 300000)
{
storage3Context.Friends.Add(new Friends { User_Id = friendId, Friend_Id = (i <= 100000) ? i + 1 : i });
storage3Context.SaveChanges();
arrayNumberFriends[friendId]++;
}
else if (friendId > 300000 && friendId < 400000)
{
storage4Context.Friends.Add(new Friends { User_Id = friendId, Friend_Id = (i <= 100000) ? i + 1 : i });
storage4Context.SaveChanges();
arrayNumberFriends[friendId]++;
}
else if (friendId > 400000 && friendId < 500000)
{
storage5Context.Friends.Add(new Friends { User_Id = friendId, Friend_Id = (i <= 100000) ? i + 1 : i });
storage5Context.SaveChanges();
arrayNumberFriends[friendId]++;
}
}
}
}