public ICollection <ItemDTO> CreateItem(ItemDTO newItem) { _validator.ValidateAndThrow(newItem); var mappedItem = _mapper.Map <Item>(newItem); if (mappedItem != null) { mappedItem.IsDeleted = false; mappedItem.LastModifiedOn = DateTime.Now; _context.Item.Add(mappedItem); _context.SaveChanges(); return(GetAllItems()); } throw new NullReferenceException(); }
public static void CleanupData() { //startup var all = dbContext.Item.ToList(); dbContext.RemoveRange(all); dbContext.Database .ExecuteSqlRaw("UPDATE SQLITE_SEQUENCE SET SEQ= '0' WHERE NAME='Item';"); dbContext.SaveChanges(); }