public async Task GameLibraryIntegrationQuery_Test() { var path = new DirectoryInfo(Path.GetTempPath()) .CreateSubdirectory(Path.GetFileNameWithoutExtension(Path.GetTempFileName())); var fs = new PhysicalFileSystem(); var gfs = fs.GetOrCreateSubFileSystem(fs.ConvertPathFromInternal(path.FullName)); var optionsBuilder = new DbContextOptionsBuilder <DatabaseContext>(); optionsBuilder.UseSqlite($"Data Source={Path.GetTempFileName()}"); var glib = new GameRecordLibrary(optionsBuilder); var gl = new GameLibrary(glib); var game = gl.CreateGame("NINTENDO_NES"); Assert.NotEmpty(gl.QueryGames(g => g.PlatformID == "NINTENDO_NES")); Assert.NotEmpty(gl.GetGames(g => g.PlatformID == "NINTENDO_NES")); Assert.NotEmpty(gl.GetAllGames()); Assert.NotNull(gl.GetGame(game.Record.RecordID)); }