public TEntity Insert(TEntity entity) { try { _context.Set <TEntity>().Add(entity); int result = _context.SaveChanges(); return(entity); } catch (Exception exception) { throw exception; } }
public void GetExamples(CancellationToken cancellationToken) { var things = db.Things.ToList(); var po = new ParallelOptions { CancellationToken = cancellationToken, MaxDegreeOfParallelism = System.Environment.ProcessorCount }; try { Parallel.ForEach(things, po, t => { po.CancellationToken.ThrowIfCancellationRequested(); log.Information($"Updating {t.Name}"); t.Counter++; }); } catch (OperationCanceledException ex) { log.Information("Stopping GetExamples() due to shutdown."); return; } db.SaveChanges(); log.Information("Finished GetExamples operation."); }
public static void SeedDatabase(this ExampleDbContext context) { var todos = new List <TodoItem> { new TodoItem("Create ASP.NET Core API project", 1), new TodoItem("Create simple EF Core database", 1), new TodoItem("Add EfCore.GenericServices to web app", 1), new TodoItem("Create a example WebAPI controller", 3), new TodoItem("Write unit tests", 2), new TodoItem("Add Swagger for manual testing", 2) }; context.AddRange(todos); var todoHybrids = new List <TodoItemHybrid> { new TodoItemHybrid("Create ASP.NET Core API project", 1), new TodoItemHybrid("Create simple EF Core database", 1), new TodoItemHybrid("Add EfCore.GenericServices to web app", 1), new TodoItemHybrid("Create a example WebAPI controller", 3), new TodoItemHybrid("Write unit tests", 2), new TodoItemHybrid("Add Swagger for manual testing", 2) }; context.AddRange(todoHybrids); var books = new List <Book> { new Book("Efcore in action", "test description", DateTime.Now, "test", 50, "") }; context.AddRange(books); context.SaveChanges(); }
internal static void SeedDatabase(this ExampleDbContext context) { var todos = new List <TodoItem> { new TodoItem("Create ASP.NET Core API project", 1), new TodoItem("Create simple EF Core database", 1), new TodoItem("Add EfCore.GenericServices to web app", 1), new TodoItem("Create a example WebAPI controller", 3), new TodoItem("Write unit tests", 2), new TodoItem("Add Swagger for manual testing", 2) }; context.AddRange(todos); var todoHybrids = new List <TodoItemHybrid> { new TodoItemHybrid("Create ASP.NET Core API project", 1), new TodoItemHybrid("Create simple EF Core database", 1), new TodoItemHybrid("Add EfCore.GenericServices to web app", 1), new TodoItemHybrid("Create a example WebAPI controller", 3), new TodoItemHybrid("Write unit tests", 2), new TodoItemHybrid("Add Swagger for manual testing", 2) }; context.AddRange(todoHybrids); context.SaveChanges(); }
public IActionResult addSample(SampleModel newSample) { // sanity check // if(newSample.sampleBucketID > 0) // { // _context.Add(newSample); // _context.SaveChanges(); // return Content($"Added Sample {newSample.id} with Bucket {newSample.sampleBucketID}"); // } else // { // return Content($"bucket dropdown error"); // } _context.Add(newSample); _context.SaveChanges(); return(RedirectToAction("listAll")); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IWebHostEnvironment env, ExampleDbContext dbContext) { dbContext.Database.EnsureCreated(); dbContext.Database.Migrate(); dbContext.GatewayKeys.AddRange(new[] { new Models.GatewayKey("forbidden", "forbidden", GatewayKeyType.Device), new Models.GatewayKey("authorized", "authorized", GatewayKeyType.Device, true) }); dbContext.SaveChanges(); if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } app.UseHttpsRedirection(); app.UseRouting(); app.UseAuthorization(); app.UseEndpoints(endpoints => { endpoints.MapControllers(); }); }
public static void SeedTwoTaxRates(this ExampleDbContext context) { var rateNow = new TaxRate(DateTime.Today, 4); var rate2Days = new TaxRate(DateTime.Today.AddDays(2), 9); context.AddRange(rateNow, rate2Days); context.SaveChanges(); }
/// <summary> /// Seeds the database with Person entities at various stages of data integrity /// </summary> private void SeedDatabase() { if (_context.Persons.Count() == 0) { _context.Add(new Person() { FirstName = "Maximilian", LastName = "Coutuer", Age = 35, Country = new Country() { Name = "Belgium", Capital = new City() { Name = "Brussels", Population = 1199000, HistoricName = "Bruoxala" }, Population = 11350000, }, }); _context.Add(new Person() { FirstName = "Guðni", LastName = "Jóhannesson", Age = 51, Country = new Country() { Name = "Iceland", Capital = new City() { Name = "Reykjavik", Population = 112853, }, Population = 338349, }, }); _context.Add(new Person() { FirstName = "Xi", LastName = "Jinping", Country = null, }); _context.Add(new Person() { FirstName = "Halimah", LastName = "Yacob", Country = new Country() { Name = "Singapore", Population = 5612000, Capital = null, }, }); _context.SaveChanges(); } }
public ActionResult OnPostSaveOrder([FromBody] OrderViewModel data) { var result = "Error! Order is not completed."; //save to db // populate order var order = new Order { CustomerId = data.CustomerId, OrderDate = DateTime.UtcNow, Items = new List <OrderItem>(), Attachments = new List <OrderAttachment>() }; // populate order details foreach (var detail in data.Items) { var orderItem = new OrderItem { ItemNo = detail.ItemNo, ProductId = detail.ProductId, Quantity = detail.Quantity }; order.Items.Add(orderItem); } // populate attachments var files = _uploadFileService.GetFiles(User.Identity.Name, _key); var fileNames = data.Attachments.Select(x => x.FileName).ToList(); foreach (var attachment in data.Attachments) { order.Attachments.Add(new OrderAttachment { Id = attachment.Id, FileName = attachment.FileName, Size = attachment.Size }); } _context.Orders.Add(order); _context.SaveChanges(); // remove file stored from uploads folder which not exists in attachments foreach (var file in files.Where(x => !fileNames.Contains(x.FileName))) { var uploads = Path.Combine(_hostingEnvironment.WebRootPath, "uploads"); var fileName = file.Id + Path.GetExtension(file.FileName); if (System.IO.File.Exists(Path.Combine(uploads, fileName))) { System.IO.File.Delete(Path.Combine(uploads, fileName)); } } result = "Success! Order is completed."; //redirect to index page return(new JsonResult(result)); }
public void TestChangeDifficultyOk() { //SETUP var options = SqliteInMemory.CreateOptions <ExampleDbContext>(); using (var context = new ExampleDbContext(options)) { context.Database.EnsureCreated(); context.Add(new TodoItem("Test", 1)); context.SaveChanges(); //ATTEMPT var item = context.TodoItems.Single(); item.ChangeDifficulty(2); context.SaveChanges(); //VERIFY context.TodoItems.Single().Difficulty.ShouldEqual(2); } }
public void TestChangeNameOk() { //SETUP var options = SqliteInMemory.CreateOptions <ExampleDbContext>(); using (var context = new ExampleDbContext(options)) { context.Database.EnsureCreated(); context.Add(new TodoItem("Test", 1)); context.SaveChanges(); //ATTEMPT var item = context.TodoItems.Single(); var status = item.ChangeName("New Name"); context.SaveChanges(); //VERIFY status.IsValid.ShouldBeTrue(status.GetAllErrors()); context.TodoItems.Single().Name.ShouldEqual("New Name"); } }
public IActionResult HandCodedUpdate(int id, JsonPatchDocument <TodoItemHybrid> patch, [FromServices] ExampleDbContext context) { var entity = context.Find <TodoItemHybrid>(id); if (entity == null) { return(NoContent()); } patch.ApplyTo(entity); context.SaveChanges(); return(Ok()); }
public static List <ProductStock> SeedExampleProductStock(this ExampleDbContext context) { var prodStocks = new List <ProductStock> { new ProductStock("Product1", 5), new ProductStock("Product2", 10), new ProductStock("Product3", 20), }; context.AddRange(prodStocks); context.SaveChanges(); return(prodStocks); }
protected virtual Guid SaveIt() { using (var dbContext = new ExampleDbContext(_dbContextOptions)) { var newThing = new EfcThing { Value = 45.0 }; dbContext.Add(newThing); dbContext.SaveChanges(); return(newThing.Id); } }
static void Main(string[] args) { var configBuilder = new ConfigurationBuilder(); configBuilder.AddJsonFile("appsettings.json"); var configuration = configBuilder.Build(); using var sqlServerDbContext = new ExampleDbContext(configuration, DatabaseType.SqlServer); using var postgresDbContext = new ExampleDbContext(configuration, DatabaseType.PostgreSql); var personToAdd = new Person("Tom", "Brady", new DateTime(1980, 10, 10)); sqlServerDbContext.Person.Add(personToAdd); postgresDbContext.Person.Add(personToAdd); sqlServerDbContext.SaveChanges(); postgresDbContext.SaveChanges(); }
public void TestCheckSaveChangesReturningCount() { //SETUP var options = SqliteInMemory.CreateOptions <ExampleDbContext>(); using (var context = new ExampleDbContext(options)) { context.Database.EnsureCreated(); //ATTEMPT context.Add(new TaxRate(DateTime.UtcNow, 4)); var numUpdates = context.SaveChanges(); //VERIFY numUpdates.ShouldEqual(1); } }
static void Main(string[] args) { ExampleDbContext exampleDbContext = new ExampleDbContext(); var config = new MapperConfiguration(c => c.AddProfile <Model.Entities.HumanResources.Profiles.PersonProfile>()); var mapper = config.CreateMapper(); var newPerson = new Person { DocumentType = DocumentType.Dni, DocumentNumber = "35000000", Birthdate = DateTime.Now.AddYears(-30), FirstName = "TestUser", LastName = "TestUser" }; exampleDbContext.People.Add(newPerson); exampleDbContext.SaveChanges(mapper); }
public DatabaseFixture() { // establish an in-memory database var dbOptions = new DbContextOptionsBuilder <ExampleDbContext>() .UseInMemoryDatabase(databaseName: "exampleapi") .Options; mockExampleDbContext = new ExampleDbContext(dbOptions); this.personController = new PersonController(mockExampleDbContext); // seed database with randomly generated test persons mockExampleDbContext.Database.EnsureCreated(); for (int i = 0; i < 10; i++) { testPersons[i] = CreateRandomPerson(); mockExampleDbContext.Add(testPersons[i]); } mockExampleDbContext.SaveChanges(); }
public ExampleController(ExampleDbContext context) { _context = context; if (_context.ExampleEntities.Count() == 0) { _context.ExampleEntities.Add(new ExampleEntity { ExampleName = "Example Name in DB", ExampleDescription = "Some description", ExampleId = 15 }); _context.ExampleEntities.Add(new ExampleEntity { ExampleName = "Example Name in DB nr 2", ExampleDescription = "Some description nr 2", ExampleId = 10 }); _context.SaveChanges(); } }
public void TestCreateTodoViaBizLogicOk() { //SETUP var options = SqliteInMemory.CreateOptions <ExampleDbContext>(); using (var context = new ExampleDbContext(options)) { context.Database.EnsureCreated(); var service = new CreateTodoBizLogic(context); //ATTEMPT var dto = new CreateTodoDto { Name = "Test", Difficulty = 3 }; var result = service.BizAction(dto); context.SaveChanges(); //VERIFY service.HasErrors.ShouldBeFalse(service.GetAllErrors()); context.TodoItems.Single().Name.ShouldEqual("Test"); } }
public void UpdatePerson(Person person) { using (var ctx = new ExampleDbContext()) { ctx.People.Attach(person); ctx.Entry(person).State = EntityState.Modified; ctx.SaveChanges(); } }
/// <summary> /// Save /// </summary> public void Save() { _dbContext.SaveChanges(); }
public void CreatePerson(Person person) { using (var ctx = new ExampleDbContext()) { ctx.People.Add(person); ctx.SaveChanges(); } }
public void DeletePerson(int personId) { using (var ctx = new ExampleDbContext()) { var person = ctx.People.SingleOrDefault(p => p.PersonId == personId); if (person == null) { throw new ObjectNotFoundException("Invalid person id."); } ctx.People.Remove(person); ctx.SaveChanges(); } }