public void DapperAndEfCoreShouldWorkUderSameUnitOfWork() { Resolve <IEventBus>().Register <EntityCreatingEventData <Blog> >( eventData => { eventData.Entity.Name.ShouldBe("SameUow"); throw new Exception("Uow Rollback"); }); try { using (IUnitOfWorkCompleteHandle uow = Resolve <IUnitOfWorkManager>().Begin()) { int blogId = blogDapperRepository.InsertAndGetId(new Blog("SameUow", "www.oguzhansoykan.com")); Blog person = blogRepository.Get(blogId); person.ShouldNotBeNull(); uow.Complete(); } } catch (Exception exception) { //no handling. } blogDapperRepository.FirstOrDefault(x => x.Name == "SameUow").ShouldBeNull(); blogRepository.FirstOrDefault(x => x.Name == "SameUow").ShouldBeNull(); }
public void Dapper_and_EfCore_should_work_under_same_unitofwork_and_when_any_exception_appears_then_rollback_should_be_consistent_for_two_orm() { Resolve <IEventBus>().Register <EntityCreatingEventData <Blog> >( eventData => { eventData.Entity.Name.ShouldBe("Oguzhan_Same_Uow"); throw new Exception("Uow Rollback"); }); try { using (IUnitOfWorkCompleteHandle uow = Resolve <IUnitOfWorkManager>().Begin()) { int blogId = _blogDapperRepository.InsertAndGetId(new Blog("Oguzhan_Same_Uow", "www.oguzhansoykan.com")); Blog person = _blogRepository.Get(blogId); person.ShouldNotBeNull(); uow.Complete(); } } catch (Exception exception) { //no handling. } _blogDapperRepository.FirstOrDefault(x => x.Name == "Oguzhan_Same_Uow").ShouldBeNull(); _blogRepository.FirstOrDefault(x => x.Name == "Oguzhan_Same_Uow").ShouldBeNull(); }
public void Should_Insert_People() { _personRepository.Insert(new Person("Oguzhan2")); Person insertedPerson = UsingSession(session => session.Query <Person>().FirstOrDefault(p => p.Name == "Oguzhan2")); insertedPerson.ShouldNotBe(null); insertedPerson.IsTransient().ShouldBe(false); insertedPerson.Name.ShouldBe("Oguzhan2"); Person insertedPersonFromDapper = _personDapperRepository.FirstOrDefault(x => x.Name == "Oguzhan2"); insertedPersonFromDapper.ShouldNotBe(null); insertedPersonFromDapper.IsTransient().ShouldBe(false); insertedPersonFromDapper.Name.ShouldBe("Oguzhan2"); }
/// <summary> /// 缓存 /// </summary> /// <returns></returns> public async Task <IEnumerable <AbpUser> > GetCacheAll() { //IEnumerable<AbpUser> ret = _userRepository.GetAll(); //return ret; var entityCache = await _cacheManager.GetCache("MemberUserCache") .Get("MemberUser", () => _userRepository.GetAllAsync());// 缓存之后这句就不执行了,_userRepository.GetAllAsync() 断点调试 var entityCache1 = _cacheManager.GetCache("MemberUserCache") .Get("User_1", () => _userRepository.FirstOrDefault(1));// .GetAllAsync()); // 清除缓存 // _cacheManager.GetCache("MemberUserCache").Clear(); // 打开监视器可以看到已经去除掉了 // await _cacheManager.GetCache("MemberUserCache").ClearAsync(); // 打开监视器可以看到已经去除掉了 // ITypedCache泛型版本 var entityCache2 = _cacheManager.GetCache("MemberUserCache") // ControllerCache .AsTyped <string, IEnumerable <AbpUser> >() .Get("AllUsers", () => _userRepository.GetAll()); // 注意对应 IEnumerable<AbpUser> , 不是 List<AbpUser> // _cacheManager.GetCache("MemberUserCache").Remove("AllUsers"); // 打开监视器可以看到已经去除掉了 // await _cacheManager.GetCache("MemberUserCache").RemoveAsync("AllUsers"); // 打开监视器可以看到已经去除掉了 return(entityCache); }
public GetOpenIdOutput GetOpenId(GetOpenIdInput input) { if (input == null) { throw new ArgumentNullException(nameof(input)); } var openUserHead = _openUserHeadsRepository.FirstOrDefault( x => x.UserId == input.UserId && x.OpenPlatformMicroApplicationId == input.OpenPlatformMicroApplicationId); if (openUserHead == null) { var id = Guid.NewGuid(); openUserHead = _openUserHeadsRepository.Insert(new Models.OpenUserHeads { CreateTime = DateTime.Now, OpenPlatformMicroApplicationId = input.OpenPlatformMicroApplicationId, UserId = input.UserId, Id = id, OpenId = id.ToString("N") }); } return(new GetOpenIdOutput { OpenId = openUserHead.OpenId }); }
public void Update_With_Action_Test() { Person userBefore = UsingSession(session => session.Query <Person>().Single(p => p.Name == "Oguzhan_Initial")); Person updatedUser = _personRepository.Update(userBefore.Id, user => user.Name = "Oguzhan_Updated_With_NH"); updatedUser.Id.ShouldBe(userBefore.Id); updatedUser.Name.ShouldBe("Oguzhan_Updated_With_NH"); Person userAfter = UsingSession(session => session.Get <Person>(userBefore.Id)); userAfter.Name.ShouldBe("Oguzhan_Updated_With_NH"); Person updatedWithNh = _personDapperRepository.FirstOrDefault(x => x.Name == "Oguzhan_Updated_With_NH"); updatedWithNh.Name = "Oguzhan_Updated_With_Dapper"; _personDapperRepository.Update(updatedWithNh); Person updatedWithDapper = _personDapperRepository.Get(updatedWithNh.Id); updatedWithDapper.Name.ShouldBe("Oguzhan_Updated_With_Dapper"); }
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 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 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(); } }