public void TestDeleteOK() { //SETUP var options = SqliteInMemory.CreateOptions <ExampleDbContext>(); using (var context = new ExampleDbContext(options)) { context.Database.EnsureCreated(); context.SeedDatabase(); var controller = new ToDoController(); var utData = context.SetupSingleDtoAndEntities <ChangeDifficultyDto>(_genericServiceConfig); var service = new CrudServices(context, utData.ConfigAndMapper); //ATTEMPT var response = controller.Delete(2, service); //VERIFY response.GetStatusCode().ShouldEqual(CreateResponse.OkStatusCode); var rStatus = response.CopyToStatus(); rStatus.IsValid.ShouldBeTrue(rStatus.GetAllErrors()); rStatus.Message.ShouldEqual("Successfully deleted a Todo Item"); context.TodoItems.Count().ShouldEqual(5); } }
public void TestPutNameOk() { //SETUP var options = SqliteInMemory.CreateOptions <ExampleDbContext>(); using (var context = new ExampleDbContext(options)) { context.Database.EnsureCreated(); context.SeedDatabase(); var controller = new ToDoController(); var utData = context.SetupSingleDtoAndEntities <ChangeNameDto>(_genericServiceConfig); var service = new CrudServices(context, utData.ConfigAndMapper); //ATTEMPT var dto = new ChangeNameDto() { Id = 2, Name = "Test", }; var response = controller.Name(dto, service); //VERIFY response.GetStatusCode().ShouldEqual(CreateResponse.OkStatusCode); var rStatus = response.CopyToStatus(); rStatus.IsValid.ShouldBeTrue(rStatus.GetAllErrors()); rStatus.Message.ShouldEqual("Successfully updated the Todo Item"); } }
public void TestPutDifficultyValidationError() { //SETUP var options = SqliteInMemory.CreateOptions <ExampleDbContext>(); using (var context = new ExampleDbContext(options)) { context.Database.EnsureCreated(); context.SeedDatabase(); var controller = new ToDoController(); var utData = context.SetupSingleDtoAndEntities <ChangeDifficultyDto>(_genericServiceConfig); var service = new CrudServices(context, utData.ConfigAndMapper); //ATTEMPT var dto = new ChangeDifficultyDto() { Id = 1, Difficulty = 99, }; var response = controller.Difficulty(dto, service); //VERIFY response.GetStatusCode().ShouldEqual(CreateResponse.ErrorsStatusCode); var rStatus = response.CopyToStatus(); rStatus.IsValid.ShouldBeFalse(); rStatus.GetAllErrors().ShouldEqual("The field Difficulty must be between 1 and 5."); } }
public void ReferencingANonIncludedEntityWillLazyLoadedViaASecondQuery() { using (ExampleDbContext dbContext = new ExampleDbContext()) { dbContext.Database.Log = s => System.Diagnostics.Debug.WriteLine(s); Person person = dbContext.Persons.First(p => p.Name == PERSON_JANE); /* * SELECT TOP (1) * [Extent1].[Id] AS [Id], * [Extent1].[Name] AS [Name] * FROM [dbo].[Person] AS [Extent1] * WHERE N'Jane' = [Extent1].[Name] * */ Assert.That(person.Pets.First(), Is.Not.Null); //the below query isn't emitted until the call to person.Pets.First() as it is lazy loaded /* * SELECT * [Extent1].[Id] AS [Id], * [Extent1].[Name] AS [Name], * [Extent1].[OwningPersonId] AS [OwningPersonId] * FROM [dbo].[Pet] AS [Extent1] * WHERE [Extent1].[OwningPersonId] = @EntityKeyValue1 * */ } }
public void TestCreateTodoOk() { //SETUP var options = SqliteInMemory.CreateOptions <ExampleDbContext>(); using (var context = new ExampleDbContext(options)) { context.Database.EnsureCreated(); context.SeedDatabase(); var controller = new ToDoController(); var noCachingConfig = new GenericBizRunnerConfig { TurnOffCaching = true }; var utData = new NonDiBizSetup(noCachingConfig); var bizInstance = new CreateTodoBizLogic(context); var service = new ActionService <ICreateTodoBizLogic>(context, bizInstance, utData.WrappedConfig); //ATTEMPT var dto = new CreateTodoDto() { Name = "Test", Difficulty = 3, }; var response = controller.Post(dto, service); //VERIFY response.GetStatusCode().ShouldEqual(201); var rStatus = response.CheckCreateResponse("GetSingleTodo", new { id = 7 }, context.TodoItems.Find(7)); rStatus.IsValid.ShouldBeTrue(rStatus.GetAllErrors()); rStatus.Message.ShouldEqual("Success"); } }
public IEnumerable<Person> GetSomePeople() { using (var ctx = new ExampleDbContext()) { return ctx.People.AsNoTracking().Take(30).ToList(); } }
public void ReferencingANonIncludedRelatedEntityThatWasAlreadyLoadedOnThisDbContextWillReturnANonNullValueBecauseItIsAlreadyCachedUpEvenWithLazyLoadingDisabled() { using (ExampleDbContext dbContext = new ExampleDbContext()) { dbContext.Database.Log = s => System.Diagnostics.Debug.WriteLine(s); dbContext.Configuration.LazyLoadingEnabled = false; //fetch all pets so they are cached up on the dbContext already List <Pet> pets = dbContext.Pets.ToList(); /* * SELECT * [Extent1].[Id] AS [Id], * [Extent1].[Name] AS [Name], * [Extent1].[OwningPersonId] AS [OwningPersonId] * FROM [dbo].[Pet] AS [Extent1] * */ Person person = dbContext.Persons.First(p => p.Name == PERSON_JANE); /* * SELECT TOP (1) * [Extent1].[Id] AS [Id], * [Extent1].[Name] AS [Name] * FROM [dbo].[Person] AS [Extent1] * WHERE N'Jane' = [Extent1].[Name] * */ //no query is emitted because the Pets property is already fully loaded as it was already cached on the DbContext Assert.That(person.Pets, Is.Not.Null); } }
public IEnumerable<Message> GetMessages() { using (var ctx = new ExampleDbContext()) { return ctx.Messages.Take(30).ToList(); } }
public GetUserClaimsQueryHandlerTests(ITestOutputHelper output) { _output = output; _dbHelper = new DbHelper <ExampleDbContext>().RunMigrations(); _handlerDbContext = _dbHelper.GetDbContext(); _httpContextAccessor = new TestHttpContextAccessor(); _handler = new GetUserClaimsQueryHandler <ExampleDbContext>(_handlerDbContext, _httpContextAccessor); }
public HomeController(ExampleDbContext dbContext) { _dbContext = dbContext; var dbinit = new DbInitializer(dbContext); dbinit.Initialize(); }
public CheckUserHasPrivilegeQueryHandlerTests(ITestOutputHelper output) { _output = output; _dbHelper = new DbHelper <ExampleDbContext>().RunMigrations(); _handlerDbContext = _dbHelper.GetDbContext(); _httpContextAccessor = new TestHttpContextAccessor(); _handler = new CheckUserHasPrivilegeQueryHandler <ExampleDbContext>(_handlerDbContext, _httpContextAccessor); }
protected void ReadAgain(Guid id) { using (var dbContext = new ExampleDbContext(_dbContextOptions)) { var t = dbContext.Find <EfcThing>(id); Assert.That(t.Id, Is.EqualTo(id)); } }
public TokenWrapper(Token originalToken, DeviantArtApp app, ExampleDbContext context) { _originalToken = originalToken; _context = context; CurrentToken = originalToken; App = app; }
public SaveUserCommandTests(ITestOutputHelper output) { _output = output; _dbHelper = new DbHelper <ExampleDbContext>().RunMigrations(); _handlerDbContext = _dbHelper.GetDbContext(); _handler = new SaveUserCommandHandler <ExampleDbContext>(_handlerDbContext); _validator = new SaveUserCommandValidator <ExampleDbContext>(_handlerDbContext); }
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(); }
public RemoveSystemRolePrivilegeCommandTests(ITestOutputHelper output) { _output = output; _dbHelper = new DbHelper <ExampleDbContext>().RunMigrations(); _handlerDbContext = _dbHelper.GetDbContext(); _handler = new RemoveSystemRolePrivilegeCommandHandler <ExampleDbContext>(_handlerDbContext); _validator = new RemoveSystemRolePrivilegeCommandValidator <ExampleDbContext>(_handlerDbContext); }
public void Setup() { var configuration = new ExampleInstaller(NullLoggerFactory.Instance).Config; using (var dbContext = new ExampleDbContext(configuration.Options)) { dbContext.Database.EnsureCreated(); } }
public IActionResult GetData([FromForm] FilterRequest model) { var context = new ExampleDbContext(); context.Database.EnsureCreated(); var result = context.Customers.AsQueryable().Load(model); return(Json(result)); }
public DataSource.User Get(int userId) { using (var db = new ExampleDbContext()) { return(db.User .Include(x => x.UserType) .FirstOrDefault(x => x.UserId == userId)); } }
public static void Main(string[] args) { using (var db = new ExampleDbContext()) { var xx = db.User .Include(x => x.UserType) .FirstOrDefault(x => x.UserId == 1); } }
public ActionResult OnPost() { StringBuilder resultSB = new StringBuilder(); try { ResultMessage = ""; resultSB.Append("Into Post <br/>"); using (var dbCtx = new ExampleDbContext() { ConnectionString = "User ID = waleedpg; Password = AbcXyz123; Server = localhost; Port = 5432; Database = turkexample2; " }) // + "Integrated Security = true; Pooling = true;"")) { resultSB.Append("Into using <br/>"); var klnclr = dbCtx.Kullanıcılar; if (klnclr != null && klnclr.Any()) { resultSB.Append("Got users <br/>"); Kullanıcılar = klnclr.ToList(); } else { resultSB.Append("There are no users!! <br/>"); } //var prsns = dbCtx.persons; //if (prsns != null && prsns.Any()) //{ // foreach (var p in prsns) // personsListBox.Items.Add($"{p.name} {p.birthdate.ToString("yyyy-MM-dd")} {p.email}"); //} } resultSB.Append("Out of Post <br/>"); ResultMessage = resultSB.ToString(); return(Page()); } catch (Exception ex) { resultSB.Append(ex.ToString()); ResultMessage = resultSB.ToString(); return(Page()); } }
public SampleOrderModel(IHostingEnvironment hostingEnvironment, IUploadFileService uploadFileService, IExamplesRepository examplesRepository, ExampleDbContext context) { _hostingEnvironment = hostingEnvironment; _uploadFileService = uploadFileService; _context = context; _exampleRepository = examplesRepository; Orders = new List <OrderViewModel>(); }
public static void Seed(ExampleDbContext ctx) { if (!ctx.People.Any()) { LoadPeopleData(ctx.Database.Connection.ConnectionString); } else { LogMsg("People records have already been added to the database."); } }
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); }
public AddClassificationCommandValidator(ExampleDbContext db) { RuleFor(e => e.Code) .NotEmpty() .Must(e => !db.Classifications.Any(c => c.Code == e)).WithLocalizedStringMessage(typeof(Core.Resources.Validation), "CodeAlreadyExists") ; RuleFor(e => e.DescEng) .MaximumLength(250); RuleFor(e => e.DescFre) .MaximumLength(255); }
public static async Task <List <PersonEntity> > GetPeopleEf() { try { using (var db = new ExampleDbContext()) { return(await db.People.ToListAsync()); } } catch (Exception e) { return(new List <PersonEntity>()); } }
public InviteNewUserAccountCommandTests() { _dbHelper = new DbHelper <ExampleDbContext>().RunMigrations(); _handlerDbContext = _dbHelper.GetDbContext(); _emailSender = new TestEmailSender(); _httpContextAccessor = new TestHttpContextAccessor(); _testUserService = new TestUserService(); var authEmailSender = new AuthEmailSender(_httpContextAccessor, _emailSender, GetIdentityProviderConfiguration(), GetApplicationConfiguration()); _handler = new InviteNewUserAccountCommandHandler <ExampleDbContext>(_handlerDbContext, authEmailSender, _testUserService); _validator = new InviteNewUserAccountCommandValidator <ExampleDbContext>(_handlerDbContext); }
public CustomerApiController(ExampleDbContext context, ICustomerRepository _repository, IUnitOfWork unitOfWork) { this._repository = _repository; this.unitOfWork = unitOfWork; this._context = context; // if (_context.Customers.Count() == 0) // { // _context.Customers.Add(new Customer { Name = "Mustafa", Surname = "Alkan", Age = 31 }); // _context.SaveChanges(); // } }
public Person GetPerson(int personId) { using (var ctx = new ExampleDbContext()) { return ctx .People .Include(p => p.EmailAddresses) .Include(p => p.PostalAddresses) .Include(p => p.PhoneNumbers) .AsNoTracking() .SingleOrDefault(p => p.PersonId == personId); } }
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); } }
protected override void Seed(ExampleDbContext context) { // This method will be called after migrating to the latest version. // You can use the DbSet<T>.AddOrUpdate() helper extension method // to avoid creating duplicate seed data. E.g. // // context.People.AddOrUpdate( // p => p.FullName, // new Person { FullName = "Andrew Peters" }, // new Person { FullName = "Brice Lambson" }, // new Person { FullName = "Rowan Miller" } // ); // }
public static void Register(HttpConfiguration config) { var dbContext = new ExampleDbContext(); var container = new UnityContainer(); container.RegisterType<IRdfWriter, RdfXmlWriter>(new InjectionConstructor()); container.RegisterType<ISelpConfiguration, InMemoryConfiguration>(); var efConstructorParameter = new InjectionConstructor(dbContext, container.Resolve<ISelpConfiguration>()); container.RegisterType<IUserRepository, UserRepository>(efConstructorParameter); container.RegisterType<IRegionRepository, RegionRepository>(efConstructorParameter); container.RegisterType<IPolicyRepository, PolicyRepository>(efConstructorParameter); container.RegisterType<IPartyRepository, PartyRepository>(efConstructorParameter); config.DependencyResolver = new UnityResolver(container); }
public void TestSeedDatabaseOk() { //SETUP var options = SqliteInMemory.CreateOptions <ExampleDbContext>(); using (var context = new ExampleDbContext(options)) { context.Database.EnsureCreated(); //ATTEMPT context.SeedDatabase(); //VERIFY context.TodoItems.Count().ShouldEqual(6); } }
public void TestCreateDatabaseSeedTaxAndStock() { //SETUP var options = SqliteInMemory.CreateOptions <ExampleDbContext>(); using (var context = new ExampleDbContext(options)) { //ATTEMPT context.Database.EnsureCreated(); context.SeedTaxAndStock(); //VERIFY context.TaxRates.Count().ShouldEqual(2); context.ProductStocks.Count().ShouldEqual(3); } }
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 UpdatePerson(Person person) { using (var ctx = new ExampleDbContext()) { ctx.People.Attach(person); ctx.Entry(person).State = EntityState.Modified; ctx.SaveChanges(); } }
public DatabaseSeed(ExampleDbContext dbContext) { _dbContext = dbContext; }
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(); } }
public PersonResponse GetPeople(PeopleRequest request) { request.Validate(); using (var ctx = new ExampleDbContext()) { IQueryable<Person> query; query = ctx.People.AsNoTracking(); var orderBy = (request.OrderBy ?? "").ToLower(); switch (orderBy) { default: query = request.Descending ? query.OrderByDescending(p => p.LastName).ThenByDescending(p => p.FirstName) : query.OrderBy(p => p.LastName).ThenBy(p => p.FirstName); break; case "firstname": query = request.Descending ? query.OrderByDescending(p => p.FirstName).ThenByDescending(p => p.LastName) : query.OrderBy(p => p.FirstName).ThenBy(p => p.LastName); break; case "middlename": query = request.Descending ? query.OrderByDescending(p => p.MiddleName).ThenByDescending(p => p.FirstName).ThenByDescending(p => p.LastName) : query.OrderBy(p => p.MiddleName).ThenBy(p => p.FirstName).ThenBy(p => p.LastName); break; case "suffix": query = request.Descending ? query.OrderByDescending(p => p.Suffix).ThenByDescending(p => p.LastName).ThenByDescending(p => p.FirstName) : query.OrderBy(p => p.Suffix).ThenBy(p => p.LastName).ThenBy(p => p.FirstName); break; case "title": query = request.Descending ? query.OrderByDescending(p => p.Title).ThenByDescending(p => p.LastName).ThenByDescending(p => p.FirstName) : query.OrderBy(p => p.Title).ThenBy(p => p.LastName).ThenBy(p => p.FirstName); break; } var results = query .Skip((request.PageIndex - 1) * request.PageSize) .Take(request.PageSize) .GroupBy(r => new { Total = query.Count() }) .ToList(); if (results.Count == 0) { return new PersonResponse { Total = 0, Page = 0, Records = 0, Rows = Enumerable.Empty<Person>().ToList() }; } int totalRecordCount = results[0].Key.Total; return new PersonResponse { Total = totalRecordCount / request.PageSize, Page = request.PageIndex, Records = totalRecordCount, Rows = results[0].ToList() }; } }