public void DoSomeStuff() { var people = _personDapperRepository.Query("select * from AppPersons"); _personDapperRepository.Execute("Insert into AppPersons (Id,Name,CreationTime) values ('" + Guid.NewGuid() + "','Name_" + Guid.NewGuid().ToString().Substring(10) + "','" + Clock.Now.ToString() + "')"); _personDapperRepository.Execute("UPDATE AppPersons set Name=@name where Id=@Id", new { name = "Name_" + Guid.NewGuid().ToString().Substring(10), Id = people.FirstOrDefault()?.Id }); var person = people.FirstOrDefault(); person.Name = "Yebin_" + Guid.NewGuid().ToString().Substring(15); _personDapperRepository.Update(person); person = _personDapperRepository.Single(people.Skip(1).Take(1).First().Id); _personDapperRepository.Insert(new Person { Name = "Yebin_" + Guid.NewGuid().ToString().Substring(15), Id = Guid.NewGuid(), CreationTime = Clock.Now }); _personDapperRepository.Delete(people.Skip(2).Take(1).First().Id); }
public void Should_Trigger_Event_On_Delete() { var triggerCount = 0; Resolve <IEventBus>().Register <EntityDeletedEventData <Person> >( eventData => { eventData.Entity.Name.ShouldBe("Oguzhan_Initial"); triggerCount++; }); Person person = _personDapperRepository.Single(p => p.Name == "Oguzhan_Initial"); _personDapperRepository.Delete(person); triggerCount.ShouldBe(1); _personDapperRepository.FirstOrDefault(p => p.Name == "Oguzhan_Initial").ShouldBe(null); }
public async Task Dapper_Repository_Tests() { using (IUnitOfWorkCompleteHandle uow = _unitOfWorkManager.Begin()) { //---Insert operation should work and tenant, creation audit properties must be set--------------------- _productDapperRepository.Insert(new Product("TShirt")); Product insertedProduct = _productDapperRepository.GetAll(x => x.Name == "TShirt").FirstOrDefault(); insertedProduct.ShouldNotBeNull(); insertedProduct.TenantId.ShouldBe(AbpSession.TenantId); insertedProduct.CreationTime.ShouldNotBeNull(); insertedProduct.CreatorUserId.ShouldBe(AbpSession.UserId); //----Update operation should work and Modification Audits should be set--------------------------- _productDapperRepository.Insert(new Product("TShirt")); Product productToUpdate = _productDapperRepository.GetAll(x => x.Name == "TShirt").FirstOrDefault(); productToUpdate.Name = "Pants"; _productDapperRepository.Update(productToUpdate); productToUpdate.ShouldNotBeNull(); productToUpdate.TenantId.ShouldBe(AbpSession.TenantId); productToUpdate.CreationTime.ShouldNotBeNull(); productToUpdate.LastModifierUserId.ShouldBe(AbpSession.UserId); //---Get method should return single------------------------------------------------------------------- _productDapperRepository.Insert(new Product("TShirt")); Action getAction = () => _productDapperRepository.Single(x => x.Name == "TShirt"); getAction.ShouldThrow <InvalidOperationException>("Sequence contains more than one element"); //----Select * from syntax should work--------------------------------- IEnumerable <Product> products = _productDapperRepository.Query("select * from Products"); products.Count().ShouldBeGreaterThan(0); //------------Ef and Dapper should work under same transaction--------------------- Product productFromEf = _productRepository.FirstOrDefault(x => x.Name == "TShirt"); Product productFromDapper = _productDapperRepository.Single(productFromEf.Id); productFromDapper.Name.ShouldBe(productFromEf.Name); productFromDapper.TenantId.ShouldBe(productFromEf.TenantId); //------Soft Delete should work for Dapper-------------- _productDapperRepository.Insert(new Product("SoftDeletableProduct")); Product toSoftDeleteProduct = _productDapperRepository.Single(x => x.Name == "SoftDeletableProduct"); _productDapperRepository.Delete(toSoftDeleteProduct); toSoftDeleteProduct.IsDeleted.ShouldBe(true); toSoftDeleteProduct.DeleterUserId.ShouldBe(AbpSession.UserId); toSoftDeleteProduct.TenantId.ShouldBe(AbpSession.TenantId); Product softDeletedProduct = _productRepository.FirstOrDefault(x => x.Name == "SoftDeletableProduct"); softDeletedProduct.ShouldBeNull(); Product softDeletedProductFromDapper = _productDapperRepository.FirstOrDefault(x => x.Name == "SoftDeletableProduct"); softDeletedProductFromDapper.ShouldBeNull(); using (_unitOfWorkManager.Current.DisableFilter(AbpDataFilters.SoftDelete)) { Product softDeletedProductWhenFilterDisabled = _productRepository.FirstOrDefault(x => x.Name == "SoftDeletableProduct"); softDeletedProductWhenFilterDisabled.ShouldNotBeNull(); Product softDeletedProductFromDapperWhenFilterDisabled = _productDapperRepository.Single(x => x.Name == "SoftDeletableProduct"); softDeletedProductFromDapperWhenFilterDisabled.ShouldNotBeNull(); } using (AbpSession.Use(2, 266)) { int productWithTenant2Id = _productDapperRepository.InsertAndGetId(new Product("ProductWithTenant2")); Product productWithTenant2 = _productRepository.Get(productWithTenant2Id); productWithTenant2.TenantId.ShouldBe(1); //Not sure about that?,Because we changed TenantId to 2 in this scope !!! Abp.TenantId = 2 now NOT 1 !!! } using (_unitOfWorkManager.Current.SetTenantId(3)) { int productWithTenant3Id = _productDapperRepository.InsertAndGetId(new Product("ProductWithTenant3")); Product productWithTenant3 = _productRepository.Get(productWithTenant3Id); productWithTenant3.TenantId.ShouldBe(3); } Product productWithTenantId3FromDapper = _productDapperRepository.FirstOrDefault(x => x.Name == "ProductWithTenant3"); productWithTenantId3FromDapper.ShouldBeNull(); Product p = await _productDapperRepository.FirstOrDefaultAsync(x => x.Status == Status.Active); p.ShouldNotBeNull(); using (_unitOfWorkManager.Current.SetTenantId(3)) { Product productWithTenantId3FromDapperInsideTenantScope = _productDapperRepository.FirstOrDefault(x => x.Name == "ProductWithTenant3"); productWithTenantId3FromDapperInsideTenantScope.ShouldNotBeNull(); } //About issue-#2091 using (_unitOfWorkManager.Current.SetTenantId(AbpSession.TenantId)) { int productWithTenantId40 = _productDapperRepository.InsertAndGetId(new Product("ProductWithTenantId40")); Product productWithTenant40 = _productRepository.Get(productWithTenantId40); productWithTenant40.TenantId.ShouldBe(AbpSession.TenantId); productWithTenant40.CreatorUserId.ShouldBe(AbpSession.UserId); } //Second DbContext tests int productDetailId = _productDetailRepository.InsertAndGetId(new ProductDetail("Woman")); _productDetailDapperRepository.Get(productDetailId).ShouldNotBeNull(); uow.Complete(); } }
public void Delete(TEntity entity) { _dapperRepository.Delete(entity); }
public void DoSomeStuff() { try { using (IUnitOfWorkCompleteHandle uow = _unitOfWorkManager.Begin()) { Logger.Debug("Uow Began!"); int persionId1 = _personRepository.InsertAndGetId(new Person("Oğuzhan")); _personRepository.Insert(new Person("Ekmek")); int animalId1 = _animalRepository.InsertAndGetId(new Animal("Kuş")); _animalRepository.Insert(new Animal("Kedi")); _animalDbContextProvider.GetDbContext().Animals.Add(new Animal("Kelebek")); _unitOfWorkManager.Current.SaveChanges(); Person personCache = _cacheManager.GetCache(DemoCacheName.Demo).Get("person", () => _personRepository.FirstOrDefault(x => x.Name == "Oğuzhan")); Person person = _personRepository.FirstOrDefault(x => x.Name == "Oğuzhan"); Animal animal = _animalRepository.FirstOrDefault(x => x.Name == "Kuş"); using (StoveSession.Use(266)) { _productDapperRepository.Insert(new Product("TShirt1")); int gomlekId = _productDapperRepository.InsertAndGetId(new Product("Gomlek1")); Product firstProduct = _productDapperRepository.FirstOrDefault(x => x.Name == "TShirt1"); IEnumerable <Product> products = _productDapperRepository.GetAll(); firstProduct.Name = "Something"; _productDapperRepository.Update(firstProduct); _mailDapperRepository.Insert(new Mail("New Product Added")); Guid mailId = _mailDapperRepository.InsertAndGetId(new Mail("Second Product Added")); IEnumerable <Mail> mails = _mailDapperRepository.GetAll(); Mail firstMail = mails.First(); firstMail.Subject = "Sorry wrong email!"; _mailDapperRepository.Update(firstMail); } Animal oneAnimal = _animalDapperRepository.Get(animalId1); Animal oneAnimalAsync = _animalDapperRepository.GetAsync(animalId1).Result; Person onePerson = _personDapperRepository.Get(persionId1); Person onePersonAsync = _personDapperRepository.GetAsync(persionId1).Result; IEnumerable <Animal> birdsSet = _animalDapperRepository.GetSet(x => x.Name == "Kuş", 0, 10, "Id"); using (_unitOfWorkManager.Current.DisableFilter(StoveDataFilters.SoftDelete)) { IEnumerable <Person> personFromDapperNotFiltered = _personDapperRepository.GetAll(x => x.Name == "Oğuzhan"); } IEnumerable <Person> personFromDapperFiltered = _personDapperRepository.GetAll(x => x.Name == "Oğuzhan"); IEnumerable <Animal> birdsFromExpression = _animalDapperRepository.GetSet(x => x.Name == "Kuş", 0, 10, "Id"); IEnumerable <Animal> birdsPagedFromExpression = _animalDapperRepository.GetAllPaged(x => x.Name == "Kuş", 0, 10, "Name"); IEnumerable <Person> personFromDapperExpression = _personDapperRepository.GetAll(x => x.Name.Contains("Oğuzhan")); int birdCount = _animalDapperRepository.Count(x => x.Name == "Kuş"); var personAnimal = _animalDapperRepository.Query <PersonAnimal>("select Name as PersonName,'Zürafa' as AnimalName from Persons with(nolock) where name=@name", new { name = "Oğuzhan" }) .MapTo <List <PersonAnimalDto> >(); birdsFromExpression.ToList(); birdsPagedFromExpression.ToList(); birdsSet.ToList(); IEnumerable <Person> person2FromDapper = _personDapperRepository.Query("select * from Persons with(nolock) where name =@name", new { name = "Oğuzhan" }); _personDapperRepository.Insert(new Person("oğuzhan2")); int id = _personDapperRepository.InsertAndGetId(new Person("oğuzhan3")); Person person3 = _personDapperRepository.Get(id); person3.Name = "oğuzhan4"; _personDapperRepository.Update(person3); _personDapperRepository.Delete(person3); Person person2Cache = _cacheManager.GetCache(DemoCacheName.Demo).Get("person", () => _personRepository.FirstOrDefault(x => x.Name == "Oğuzhan")); //Person oguzhan = _personRepository.Nolocking(persons => persons.FirstOrDefault(x => x.Name == "Oğuzhan")); Person oguzhan2 = _personRepository.FirstOrDefault(x => x.Name == "Oğuzhan"); uow.Complete(); _messageBus.Publish <IPersonAddedMessage>(new PersonAddedMessage { Name = "Oğuzhan", CorrelationId = NewId.NextGuid() }); //_hangfireBackgroundJobManager.EnqueueAsync<SimpleBackgroundJob, SimpleBackgroundJobArgs>(new SimpleBackgroundJobArgs //{ // Message = "Oğuzhan" //}); //_hangfireScheduleJobManager.ScheduleAsync<SimpleBackgroundJob, SimpleBackgroundJobArgs>(new SimpleBackgroundJobArgs //{ // Message = "Oğuzhan" //}, Cron.Minutely()); Logger.Debug("Uow End!"); } } catch (Exception ex) { Logger.Error(ex); throw ex; } }
public int Delete(Table entity) { return(_dapperRepository.Delete(entity)); }
public void Dapper_Repository_Tests() { using (IUnitOfWorkCompleteHandle uow = _unitOfWorkManager.Begin()) { //---Insert operation should work and tenant, creation audit properties must be set--------------------- _productDapperRepository.Insert(new Product("TShirt")); Product insertedProduct = _productDapperRepository.GetAll(x => x.Name == "TShirt").FirstOrDefault(); Guid mailId = _mailRepository.InsertAndGetId(new Mail("Hi There !")); _unitOfWorkManager.Current.SaveChanges(); Mail mail = _mailDapperRepository.Get(mailId); mail.ShouldNotBeNull(); mail.CreatorUserId.ShouldNotBeNull(); mail.CreatorUserId.ShouldBe(StoveSession.UserId); Mail mailFromCustomRepository = _mailCustomDapperRepository.GetMailById(mailId); mailFromCustomRepository.ShouldNotBeNull(); insertedProduct.ShouldNotBeNull(); insertedProduct.CreationTime.ShouldNotBeNull(); insertedProduct.CreatorUserId.ShouldNotBeNull(); insertedProduct.CreatorUserId.ShouldBe(StoveSession.UserId); //----Update operation should work and Modification Audits should be set--------------------------- _productDapperRepository.Insert(new Product("TShirt")); Product productToUpdate = _productDapperRepository.GetAll(x => x.Name == "TShirt").FirstOrDefault(); productToUpdate.Name = "Pants"; _productDapperRepository.Update(productToUpdate); productToUpdate.ShouldNotBeNull(); productToUpdate.CreationTime.ShouldNotBeNull(); productToUpdate.LastModifierUserId.ShouldBe(StoveSession.UserId); productToUpdate.CreatorUserId.ShouldBe(StoveSession.UserId); //---Get method should return single------------------------------------------------------------------- _productDapperRepository.Insert(new Product("TShirt")); Action getAction = () => _productDapperRepository.Single(x => x.Name == "TShirt"); getAction.ShouldThrow <InvalidOperationException>("Sequence contains more than one element"); //----Select * from syntax should work--------------------------------- IEnumerable <Product> products = _productDapperRepository.Query("select * from Products"); products.Count().ShouldBeGreaterThan(0); //------------Ef and Dapper should work under same transaction--------------------- Product productFromEf = _productRepository.FirstOrDefault(x => x.Name == "TShirt"); Product productFromDapper = _productDapperRepository.Single(productFromEf.Id); productFromDapper.Name.ShouldBe(productFromEf.Name); //------Soft Delete should work for Dapper-------------- _productDapperRepository.Insert(new Product("SoftDeletableProduct")); Product toSoftDeleteProduct = _productDapperRepository.Single(x => x.Name == "SoftDeletableProduct"); _productDapperRepository.Delete(toSoftDeleteProduct); toSoftDeleteProduct.IsDeleted.ShouldBe(true); toSoftDeleteProduct.DeleterUserId.ShouldBe(StoveSession.UserId); Product softDeletedProduct = _productRepository.FirstOrDefault(x => x.Name == "SoftDeletableProduct"); softDeletedProduct.ShouldBeNull(); Product softDeletedProductFromDapper = _productDapperRepository.FirstOrDefault(x => x.Name == "SoftDeletableProduct"); softDeletedProductFromDapper.ShouldBeNull(); using (_unitOfWorkManager.Current.DisableFilter(StoveDataFilters.SoftDelete)) { Product softDeletedProductWhenFilterDisabled = _productRepository.FirstOrDefault(x => x.Name == "SoftDeletableProduct"); softDeletedProductWhenFilterDisabled.ShouldNotBeNull(); Product softDeletedProductFromDapperWhenFilterDisabled = _productDapperRepository.Single(x => x.Name == "SoftDeletableProduct"); softDeletedProductFromDapperWhenFilterDisabled.ShouldNotBeNull(); } using (StoveSession.Use(266)) { _productDapperRepository.Insert(new Product("InsertedProductWith266Id")); Product InsertedProductWith266Id = _productDapperRepository.GetAll(x => x.Name == "InsertedProductWith266Id").FirstOrDefault(); InsertedProductWith266Id.ShouldNotBeNull(); InsertedProductWith266Id.CreationTime.ShouldNotBeNull(); InsertedProductWith266Id.CreatorUserId.ShouldNotBeNull(); InsertedProductWith266Id.CreatorUserId.ShouldBe(StoveSession.UserId); } _productDapperRepository.Insert(new Product("InsertedProductAfterSpecifiedUserId")); Product InsertedProductAfterSpecifiedUserId = _productDapperRepository.GetAll(x => x.Name == "InsertedProductAfterSpecifiedUserId").FirstOrDefault(); InsertedProductAfterSpecifiedUserId.ShouldNotBeNull(); InsertedProductAfterSpecifiedUserId.CreationTime.ShouldNotBeNull(); InsertedProductAfterSpecifiedUserId.CreatorUserId.ShouldNotBeNull(); InsertedProductAfterSpecifiedUserId.CreatorUserId.ShouldBe(StoveSession.UserId); uow.Complete(); } }
public void TextRemove() { var user = userInfoRepository.Get(1); var result = userInfoRepository.Delete(user); }
public ActionResult Delete(int id) { _dapper.Delete(id); return(RedirectToAction("Index")); }
public void Test() { TestClass t1 = new TestClass(); t1.Id = 1; t1.Data = "test1"; TestClass t2 = new TestClass(); t2.Id = 2; t2.Data = "test2"; t2.FakeNameColumn = "2222"; var result = repo.Insert(t1); Assert.Equal(1, result); result = repo.Insert(t2); Assert.Equal(1, result); var item1 = repo.GetItem(new TestClass() { Id = 1 }); Assert.Equal("test1", item1.Data); var item2 = repo.GetItem(new TestClass() { Id = 2 }); Assert.Equal("test2", item2.Data); // update 테스트 t1.Data = "test1-1"; t1.FakeNameColumn = "1111"; result = repo.Update(t1); Assert.Equal(1, result); item1 = repo.GetItem(new TestClass() { Id = 1 }); Assert.Equal("test1-1", item1.Data); // 조건 리스트 var list = repo.GetList(t1, new ParamColumn("Id", "<", "3")); Assert.Equal(2, list.Count); // 조건 아이템 var item4 = repo.GetItem(t1, new ParamColumn(nameof(t1.LDate), "is not null", "")); Assert.Equal(1, item4.Id); item4 = repo.GetItem(t1, new ParamColumn(nameof(t1.LDate), "is null", null)); Assert.Equal(2, item4.Id); item4 = repo.GetItem(t1, new ParamColumn(nameof(t1.Data), "like", "'%1-1'")); Assert.Equal(1, item4.Id); // Delete result = repo.Delete(new TestClass() { Id = 1, Data = "test1-1" }); Assert.Equal(1, result); result = repo.Delete(new TestClass() { Id = 2 }); Assert.Equal(1, result); }
public void DoSomeStuff() { using (IUnitOfWorkCompleteHandle uow = _unitOfWorkManager.Begin()) { Logger.Debug("Uow Began!"); _personRepository.Insert(new Person("Oğuzhan")); _personRepository.Insert(new Person("Ekmek")); _animalRepository.Insert(new Animal("Kuş")); _animalRepository.Insert(new Animal("Kedi")); _animalDbContextProvider.GetDbContext().Animals.Add(new Animal("Kelebek")); _unitOfWorkManager.Current.SaveChanges(); Person personCache = _cacheManager.GetCache(DemoCacheName.Demo).Get("person", () => _personRepository.FirstOrDefault(x => x.Name == "Oğuzhan")); Person person = _personRepository.FirstOrDefault(x => x.Name == "Oğuzhan"); Animal animal = _animalRepository.FirstOrDefault(x => x.Name == "Kuş"); #region DAPPER var list = new List <string> { "elma", "armut" }; ExpressionStarter <Animal> predicate = PredicateBuilder.New <Animal>(); predicate.And(x => x.Name == "Kuş"); IEnumerable <Animal> birdsSet = _animalDapperRepository.GetSet(new { Name = "Kuş" }, 0, 10, "Id"); IEnumerable <Person> personFromDapper = _personDapperRepository.GetList(new { Name = "Oğuzhan" }); IEnumerable <Animal> birdsFromExpression = _animalDapperRepository.GetSet(predicate, 0, 10, "Id"); IEnumerable <Animal> birdsPagedFromExpression = _animalDapperRepository.GetListPaged(x => x.Name == "Kuş", 0, 10, "Name"); IEnumerable <Person> personFromDapperExpression = _personDapperRepository.GetList(x => x.Name.Contains("Oğuzhan")); int birdCount = _animalDapperRepository.Count(x => x.Name == "Kuş"); var personAnimal = _animalDapperRepository.Query <PersonAnimal>("select Name as PersonName,'Zürafa' as AnimalName from Person with(nolock) where name=@name", new { name = "Oğuzhan" }) .MapTo <List <PersonAnimalDto> >(); birdsFromExpression.ToList(); birdsPagedFromExpression.ToList(); birdsSet.ToList(); IEnumerable <Person> person2FromDapper = _personDapperRepository.Query("select * from Person with(nolock) where name =@name", new { name = "Oğuzhan" }); _personDapperRepository.Insert(new Person("oğuzhan2")); int id = _personDapperRepository.InsertAndGetId(new Person("oğuzhan3")); Person person3 = _personDapperRepository.Get(id); person3.Name = "oğuzhan4"; _personDapperRepository.Update(person3); _personDapperRepository.Delete(person3); #endregion Person person2Cache = _cacheManager.GetCache(DemoCacheName.Demo).Get("person", () => _personRepository.FirstOrDefault(x => x.Name == "Oğuzhan")); Person oguzhan = _personRepository.Nolocking(persons => persons.FirstOrDefault(x => x.Name == "Oğuzhan")); Person oguzhan2 = _personRepository.FirstOrDefault(x => x.Name == "Oğuzhan"); uow.Complete(); _messageBus.Publish <IPersonAddedMessage>(new PersonAddedMessage { Name = "Oğuzhan", CorrelationId = NewId.NextGuid() }); //_hangfireBackgroundJobManager.EnqueueAsync<SimpleBackgroundJob, SimpleBackgroundJobArgs>(new SimpleBackgroundJobArgs //{ // Message = "Oğuzhan" //}); _hangfireScheduleJobManager.ScheduleAsync <SimpleBackgroundJob, SimpleBackgroundJobArgs>(new SimpleBackgroundJobArgs { Message = "Oğuzhan" }, Cron.Minutely()); Logger.Debug("Uow End!"); } }