public void AddTodoTasksToContext() { var builder = new DbContextOptionsBuilder <TodoContext>(); builder.UseInMemoryDatabase("TodoDB"); var options = builder.Options; using (var context = new TodoContext(options)) { var todoTasks = new List <TodoTask> { new TodoTask { Id = 1, Name = "Item1", IsComplete = true }, new TodoTask { Id = 2, Name = "Item2", IsComplete = true }, }; context.AddRange(todoTasks); context.SaveChanges(); } using (var context = new TodoContext(options)) { Assert.Equal(2, context.TodoTasks.Count()); } }
public async Task <IActionResult> Post(List <IFormFile> files) { ValidateFile(files); var dataTable = ParseToDataTable(files); if (dataTable.Rows.Count == 0) { return(Ok(new { rows = dataTable.Rows.Count, columns = dataTable.Columns.Count })); } var timeBlocks = DataTableConverter.ToTimeBlocks(dataTable); Context.AddRange(timeBlocks); await Context.SaveChangesAsync(); return(Ok(new { rows = dataTable.Rows.Count, columns = dataTable.Columns.Count })); }
//create Importances: hight,normal,low public static void CreateDefaultImportances(TodoContext context) { if (context.Importances.Count() == 0) { List <Importance> importances = new List <Importance> { new Importance { Name = "low", DigitValue = 0 }, new Importance { Name = "normal", DigitValue = 1 }, new Importance { Name = "hight", DigitValue = 2 } }; context.AddRange(importances); context.SaveChanges(); } }
public void Setup() { builder = new DbContextOptionsBuilder <TodoContext>(); builder.UseInMemoryDatabase("MyInMemoryDb"); var options = builder.Options; context = new TodoContext(options); var todos = new List <TodoItem> { new TodoItem { Id = 1, Name = "Mow the Lawn", IsComplete = false }, new TodoItem { Id = 2, Name = "Do the Dishes", IsComplete = false } }; context.AddRange(todos); context.SaveChanges(); }
public void Setup() { _todosContext = new TodoContext(new DbContextOptionsBuilder <TodoContext>() .UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString()).Options); _todos = new Todo[] { new Todo { Id = Guid.NewGuid(), Text = Guid.NewGuid().ToString(), CreatedAt = DateTime.Now, IsCompleted = false }, new Todo { Id = Guid.NewGuid(), Text = Guid.NewGuid().ToString(), CreatedAt = DateTime.Now, IsCompleted = true }, new Todo { Id = Guid.NewGuid(), Text = Guid.NewGuid().ToString(), CreatedAt = DateTime.Now, IsCompleted = false } }; _todosContext.AddRange(_todos); _todosContext.SaveChanges(); _sut = new TodosController(_todosContext); }
public void AddRange(List <Todo> todos) { _context.AddRange(todos); _context.SaveChanges(); }