public DataBaseSeeder SeedInitial()
{
BulkCopyOptions options = new BulkCopyOptions
{
CheckConstraints = false,
BulkCopyType = BulkCopyType.Default,
KeepIdentity = true
};
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Data seed Initial in DataBase:");
Console.ResetColor();
Console.WriteLine("SectionTypes");
db.BulkCopy(options, dataContainer.SectionTypes);
Console.WriteLine("Categories");
db.BulkCopy(options, dataContainer.Categories);
Console.WriteLine("Users");
db.BulkCopy(options, dataContainer.Users);
Console.WriteLine("Roles");
db.BulkCopy(options, dataContainer.Roles);
Console.WriteLine("UserRoles");
db.BulkCopy(options, dataContainer.UserRoles);
Console.WriteLine("OperationKeys");
db.BulkCopy(options, dataContainer.OperationKeys);
Console.WriteLine("CategoryAccesses");
db.BulkCopy(options, dataContainer.CategoryAccesses);
Console.WriteLine("CategoryOperationAccesses");
db.BulkCopy(options, dataContainer.CategoryOperationAccesses);
RunDbCpecificCode();
return(this);
}
private static void EnsureItems(DataBaseConnection db)
{
var allItemsDic = db.ConfigurationItems.ToList().ToDictionary(x => x.Name, x => x);
var itemsToAdd = new List <ConfigurationItem>();
foreach (var(name, value) in ConfigDefaults.ConfigurationItems)
{
if (!allItemsDic.ContainsKey(name))
{
itemsToAdd.Add(
new ConfigurationItem
{
Name = name,
Value = value.ToString()
}
);
}
}
db.BulkCopy(itemsToAdd);
}
public DataBaseSeeder SeedInitial()
{
BulkCopyOptions options = new BulkCopyOptions
{
CheckConstraints = false,
BulkCopyType = BulkCopyType.Default,
KeepIdentity = true
};
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("Data seed Initial in DataBase:");
Console.ResetColor();
Console.WriteLine("Categories");
db.BulkCopy(options, dataContainer.Categories);
Console.WriteLine("Users");
db.BulkCopy(options, dataContainer.Users);
Console.WriteLine("Materials");
db.BulkCopy(options, dataContainer.Materials);
Console.WriteLine("Roles");
db.BulkCopy(options, dataContainer.Roles);
Console.WriteLine("UserRoles");
db.BulkCopy(options, dataContainer.UserRoles);
Console.WriteLine("OperationKeys");
db.BulkCopy(options, dataContainer.OperationKeys);
Console.WriteLine("CategoryAccesses");
db.BulkCopy(options, dataContainer.CategoryAccesses);
Console.WriteLine("CategoryOperationAccesses");
db.BulkCopy(options, dataContainer.CategoryOperationAccesses);
Console.WriteLine("MenuItems");
db.BulkCopy(options, dataContainer.MenuItems);
Console.WriteLine("Components");
db.BulkCopy(options, dataContainer.Components);
Console.WriteLine("CipherSecrets");
db.BulkCopy(options, dataContainer.CipherSecrets);
if (dataContainer.CacheSettings != null)
{
Console.WriteLine("Cache Settings");
db.Insert(dataContainer.CacheSettings);
}
RunDbCpecificCode();
return(this);
}