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));
}
