private static void SaveCategories(IEnumerable <Category> categories, string connectionString = null)
{
var options = new DbContextOptionsBuilder <RunnerDbContext>()
.UseSqlServer(connectionString ?? "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=MarathonManager;Integrated Security=True")
.Options;
using (var context = new RunnerDbContext(options))
{
context.AddRange(categories.ToList());
context.SaveChanges();
}
}
private static void InsertCategories()
{
var defaultCategories = ReadCategories();
var options = new DbContextOptionsBuilder <RunnerDbContext>()
.UseSqlServer(Configuration.GetConnectionString("Default"))
.Options;
using (var context = new RunnerDbContext(options))
{
var categories = defaultCategories.Select(c => new Category {
Name = c.Name
});
context.AddRange(categories);
context.SaveChanges();
WriteLine("Categories were successfully saved:");
categories.ForEach(c => WriteLine($"| {c.Name}"));
}
}