public void SetUp() { var connection = DbConnectionFactory.CreateTransient(); dbContext = new ItemsDbContext(connection); itemRepository = new ItemRepository(dbContext); }
protected async Task <ItemApiModel> SaveItemAsync(Item itemToSave) { using IServiceScope scope = Server.CreateScope(); ItemsDbContext itemsDbContext = scope.ServiceProvider.GetRequiredService <ItemsDbContext>(); itemsDbContext.Add(itemToSave); await itemsDbContext.SaveChangesAsync(); return(new ItemApiModel { Id = itemToSave.Id, IsDone = itemToSave.IsDone, Text = itemToSave.Text, Priority = itemToSave.Priority }); }
private static void Main(string[] args) { var timer = Stopwatch.StartNew(); var items = ApiCaller.GetItems <BaseModel>("delirium", "base"); var db = new ItemsDbContext(); //var deleted = db.Database.EnsureDeleted(); var created = db.Database.EnsureCreated(); //Console.WriteLine(deleted); Console.WriteLine(created); if (db.Bases.Any()) { Console.WriteLine("Updating Items"); db.Bases.UpdateRange(items); db.SaveChanges(); } else { Console.WriteLine("Adding Items"); db.Bases.AddRange(items); db.SaveChanges(); } foreach (var accessoryModel in db.Bases.Where(a => a.Exalted > 1).OrderBy(a => a.Exalted)) { Console.Write($"{accessoryModel.Name} "); foreach (var influence in accessoryModel.Influences) { Console.Write($"{influence.ToString()} "); } Console.Write($"{accessoryModel.BaseItemLevel} {accessoryModel.Exalted} {accessoryModel.Id}"); Console.Write("\n"); } Console.WriteLine("Finished in {0}ms", timer.ElapsedMilliseconds); }
public TestServerFixture() { string projectRootPath = Path.Combine( Directory.GetCurrentDirectory(), "..", "..", "..", "..", "..", "src", "services", "Items", "TodoList.Items.API"); IWebHostBuilder webHostBuilder = WebHost.CreateDefaultBuilder() .UseContentRoot(projectRootPath) .UseEnvironment(Environments.Development) .UseStartup <TestStartup>(); Server = new TestServer(webHostBuilder); Client = Server.CreateClient(); AsyncRetryPolicy retryPolicy = Policy .Handle <SqlException>() .WaitAndRetryAsync(3, retryNumber => TimeSpan.FromSeconds(retryNumber * 2), (exception, sleepDuration) => Console.WriteLine($"SQL Server connection retry, sleep duration: {sleepDuration}")); User?user = null; retryPolicy.ExecuteAsync(async() => { using IServiceScope scope = Server.CreateScope(); ItemsDbContext itemsDbContext = scope.ServiceProvider.GetRequiredService <ItemsDbContext>(); await itemsDbContext.Database.MigrateAsync(); user = await itemsDbContext.Users .AsNoTracking() .SingleAsync(u => u.IdentityId == 1); }).GetAwaiter().GetResult(); User = user !; Server.Services.GetRequiredService <IOptions <RouteOptions> >().Value.SuppressCheckForUnhandledSecurityMetadata = true; }
public ItemsController(ItemsDbContext context) { _context = context; }
public TestDataBuilder(ItemsDbContext context) { _context = context; }
public ItemsService(ItemsDbContext db) : base(db) { }
public ItemRepository(ItemsDbContext dbContext) : base(dbContext) { }
protected BaseService(ItemsDbContext db) { _db = db; }
private ItemsDbContext _itemsDbContext; //= new ItemsDbContext(); public ItemController(ItemsDbContext itemsDbContext) { _itemsDbContext = itemsDbContext; }
public DbBuilder(ItemsDbContext context) { _context = context; }
protected RepositoryBase(ItemsDbContext dbContext) { this.dbContext = dbContext; }
public CraftableRepository(ItemsDbContext context) { _context = context; }
public BondRepository(ItemsDbContext context) { _context = context; }