GameCollector.SQLiteUtils 4.3.2.1

There is a newer version of this package available.
See the version list below for details.
dotnet add package GameCollector.SQLiteUtils --version 4.3.2.1                
NuGet\Install-Package GameCollector.SQLiteUtils -Version 4.3.2.1                
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="GameCollector.SQLiteUtils" Version="4.3.2.1" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add GameCollector.SQLiteUtils --version 4.3.2.1                
#r "nuget: GameCollector.SQLiteUtils, 4.3.2.1"                
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install GameCollector.SQLiteUtils as a Cake Addin
#addin nuget:?package=GameCollector.SQLiteUtils&version=4.3.2.1

// Install GameCollector.SQLiteUtils as a Cake Tool
#tool nuget:?package=GameCollector.SQLiteUtils&version=4.3.2.1                

Logo

GameCollector

a fork of GameFinder

CI codecov

.NET library for finding games. GameCollector expands on upstream GameFinder (which is primarily designed to support modding tools), by adding additional supported store launchers, emulators, and data sources, and includes additional information about each game (sufficient for a multi-store game launcher such as GLC). This fork is indebted to erri120's hard work, but as he is reticent to expand the scope of GameFinder, GameCollector continues with a different philosophy.

The following launchers and emulators are supported:

handler package
Amazon Games Nuget
Arc Nuget
Bethesda.net Nuget
Big Fish Game Manager Nuget
Blizzard Battle.net Nuget
Dolphin Emulator Nuget
EA app Nuget Nuget
Epic Games Store Nuget Nuget
Game Jolt Client Nuget
GOG Galaxy Nuget Nuget
Heroic (GOG) Nuget Nuget
Humble App Nuget
Indiegala IGClient Nuget
itch Nuget
Legacy Games Launcher Nuget
Multiple Arcade Machine Emulator (MAME) Nuget
Oculus Nuget
Origin Nuget Nuget
Paradox Launcher Nuget
Plarium Play Nuget
Riot Client Nuget
RobotCache Client Nuget
Rockstar Games Launcher Nuget
Steam Nuget Nuget
Ubisoft Connect Nuget
Wargaming.net Game Center Nuget
Xbox Game Pass Nuget Nuget

If you are interested in understanding how GameCollector/GameFinder finds these games, check the upstream wiki for more information (descriptions of the added handlers should eventually be added to a wiki here).

Additionally, the following Linux tools are supported:

handler package
Wine Nuget Nuget

Example and Binaries

The example project uses every available store handler and can be used as a reference. You can go to Releases to download Windows builds of GameCollector.exe, or the GitHub Actions Page and click on one of the latest CI workflow runs to download pre-release binaries for this project.

GameCollector Issues

  • Known issues: See GameCollector issues here or upstream GameFinder issues here. Please do not submit bugs/requests for GameCollector on GameFinder's GitHub.
  • DLCs/clones: When an entry is detected as a DLC addon (or a clone in the MAME handler), the string? GameData.BaseGame field is set to the ID of the main game (or sometimes the string "False" when the relationship can't be determined). To hide DLCs from the consumer application, use FindAllGames(Settings) where bool Settings.BaseOnly = true, or do not use entries where string? GameData.BaseGame != null.
  • Owned not-installed games: Some handlers can find owned not-installed games. To support this feature for Steam games, see note below. To hide not-installed games, use FindAllGames(Settings) where bool Settings.InstalledOnly = true, or do not use entries where bool GameData.IsInstalled == false.
  • Unowned games: A few handlers can find all entries in the launcher database. To show only owned games, use FindAllGames(Settings) where bool Settings.OwnedOnly = true, or do not use entries where bool GameData.IsOwned == false.
  • Non-game items: Some handlers can find non-game (e.g., applications) items. To show only games, use FindAllGames(Settings) where bool Settings.GamesOnly = true, or parse the item's List<string> GameData.Genres for the appropriate string values.

Dolphin/MAME

These handlers both require you pass an AbsolutePath to the emulator executable when instantiating the handler class, e.g., new MAMEHandler(fileSystem, mamePath).

Oculus

If the Oculus service is running (as it does even when the program is not open), the database is usually locked and connot be read. The handler attempts to stop the service, but this only works if the consumer application is running as administrator.

Differences from Upstream

GameCollector adds a FindClient() function to get the path to a given store client's executable.

The TGame implementations of GameCollector's handlers inherit a generic GameData record. Unfortunately, no handler populates all of the following fields, and many only provide a few:

  • enum Handler
  • string GameId
  • string GameName
  • AbsolutePath GamePath
  • AbsolutePath? SavePath
  • AbsolutePath Launch
  • string LaunchArgs
  • string LaunchUrl
  • AbsolutePath Icon
  • AbsolutePath Uninstall
  • string UninstallArgs
  • string UninstallUrl
  • DateTime? InstallDate
  • DateTime? LastRunDate
  • uint NumRuns
  • TimeSpan? RunTime
  • bool IsInstalled
  • bool IsOwned
  • bool IsHidden
  • List<Problem>? Problems
  • List<string>? Tags
  • ushort? MyRating
  • string? BaseGame
  • Dictionary<string, List<string>>? Metadata

The Metadata dictionary may include (depending on available information): "ReleaseDate", "Description", "Developers", "Publishers", "Genres", "ImageUrl", etc.

Supported Emulators

This is a new category of handler for GameCollector. They are Windows-only for now.

  • Dolphin
  • MAME

New Supported Launchers

The following 17 handlers have been added for GameCollector. They are all Windows-only for now:

  • Amazon Games
  • Arc
  • Big Fish Game Manager
  • Blizzard Battle.net
  • Game Jolt
  • Humble App
  • Indiegala IGClient
  • itch
  • Legacy Games Launcher
  • Oculus
  • Paradox Launcher
  • Plarium Play
  • Riot Client
  • RobotCache Client
  • Rockstar Games Launcher
  • Ubisoft Connect
  • Wargaming.net Game Center

Usage

Like GameFinder, all store handlers inherit from AHandler<TGame, TId> and implement FindAllGames() which returns IEnumerable<OneOf<TGame, ErrorMessage>>. The OneOf struct is a F# style union and is guaranteed to only contain one of the following: a TGame or an ErrorMessage. I recommended checking out the OneOf library, if you want to learn more.

Some important things to remember:

  • All store handler methods are pure, meaning they do not change the internal state of the store handler because they don't have any. This also means that the results are not cached and you shouldn't call the same method multiple times. It's up to the library consumer to cache the results somewhere.
  • GameIds are store dependent. Each store handler has their own type of id and figuring out the right id for your game might require some testing. You can find useful resources in this README for some store handlers.

Basic Usage

var results = handler.FindAllGames();

foreach (var result in results)
{
    // using the switch method
    result.Switch(game =>
    {
        Console.WriteLine($"Found {game}");
    }, error =>
    {
        Console.WriteLine(error);
    });

    // using the provided extension functions
    if (result.TryGetGame(out var game))
    {
        Console.WriteLine($"Found {game}");
    } else
    {
        Console.WriteLine(result.AsError());
    }
}

Finding a single game

If you're working on an application that only needs to find 1 game, then you can use the FindOneGameById method instead. IMPORTANT NOTE: the results are not cached. If you call this method multiple, the store handler will do the same thing multiple times, which is search for every game installed. Do not call this method if you need to find multiple games.

var game = handler.FindOneGameById(someId, out var errors);

// I highly recommend logging errors regardless of whether or not the game was found.
foreach (var error in errors)
{
    Console.WriteLine(error);
}

if (game is null)
{
    Console.WriteLine("Unable to find game");
} else
{
    Console.WriteLine($"Found {game}");
}

Finding multiple games

If you need to find multiple games at once, you can use the FindAllGamesById method instead. This returns an IReadOnlyDictionary<TId, TGame> which you can use to lookup games by id. IMPORTANT NOTE: the results are not cached. You have to do that yourself.

var games = handler.FindAllGamesById(out var errors);

// I highly recommend always logging errors.
foreach (var error in errors)
{
    Console.WriteLine(error);
}

if (games.TryGetValue(someId, out var game))
{
    Console.WriteLine($"Found {game}");
} else
{
    Console.WriteLine($"Unable to find game with the id {someId}");
}

Upstream Supported Launchers

The following handlers come from upstream GameFinder:

Steam

Steam is supported natively on Windows and Linux. Use SteamDB to find the ID of a game.

Usage (cross-platform):

var handler = new SteamHandler(FileSystem.Shared, OperatingSystem.IsWindows() ? WindowsRegistry.Shared : null);

GameCollector adds the ability to check a Steam profile for owned not-installed games. A specific Steam ID may be specified, though it will automatically attempt to find one. However, this feature requires that an API key be activated and specified, and the user profile set to public.

GOG Galaxy

GOG Galaxy is supported natively on Windows, and with Wine on Linux. Use the GOG Database to find the ID of a game.

Usage (native on Windows):

var handler = new GOGHandler(WindowsRegistry.Shared, FileSystem.Shared);

Usage (Wine on Linux):

See Wine for more information.

// requires a valid prefix
var wineFileSystem = winePrefix.CreateOverlayFileSystem(FileSystem.Shared);
var wineRegistry = winePrefix.CreateRegistry(FileSystem.Shared);

var handler = new GOGHandler(wineRegistry, wineFileSystem);

GameCollector adds finding all GOG games in the launcher's database, whether installed, owned not-installed, or unowned.

Epic Games Store

The Epic Games Store is supported natively on Windows, and with Wine on Linux. Use the Epic Games Store Database to find the ID of a game (WIP).

Usage (native on Windows):

var handler = new EGSHandler(WindowsRegistry.Shared, FileSystem.Shared);

Usage (Wine on Linux):

See Wine for more information.

// requires a valid prefix
var wineFileSystem = winePrefix.CreateOverlayFileSystem(FileSystem.Shared);
var wineRegistry = winePrefix.CreateRegistry(FileSystem.Shared);

var handler = new EGSHandler(wineRegistry, wineFileSystem);

GameCollector adds finding owned not-installed EGS games.

Origin

Origin is supported natively on Windows, and with Wine on Linux. Note: EA is deprecating Origin and will replace it with EA app.

Usage (native on Windows):

var handler = new OriginHandler(FileSystem.Shared);

Usage (Wine on Linux):

See Wine for more information.

// requires a valid prefix
var wineFileSystem = winePrefix.CreateOverlayFileSystem(FileSystem.Shared);

var handler = new OriginHandler(wineFileSystem);

EA app

The EA app is the replacement for Origin on Windows: See EA is deprecating Origin. This is by far the most complicated Store Handler. You should read the upstream wiki entry. This implementation decrypts the encrypted file created by the EA app. You should be aware that the key used to encrypt the file is derived from hardware information. If the user changes their hardware, the decryption process might fail because they key has changed.

The EA app is only supported on Windows.

Usage:

var handler = new EADesktopHandler(FileSystem.Shared, new HardwareInfoProvider());

Xbox Game Pass

This package used to be deprecated, but support was re-added in GameFinder 3.0.0. Xbox Game Pass used to install games inside a SYSTEM protected folder, making modding not feasible for the average user. You can read more about this here.

Xbox Game Pass is only supported on Windows.

Usage:

var handler = new XboxHandler(FileSystem.Shared);

Bethesda.net

As of May 11, 2022, the Bethesda.net launcher is no longer in use. The upstream package GameFinder.StoreHandlers.BethNet has been deprecated and marked as legacy.

Wine

Wine is a compatibility layer capable of running Windows applications on Linux. Wine uses prefixes to create and store virtual C: drives. A user can install and run Windows program inside these prefixes, and applications running inside the prefixes likely won't even notice they are not actually running on Windows.

Since GameCollector/GameFinder is all about finding games, it also has to be able to find games inside Wine prefixes to provide good Linux support. The package NexusMods.Paths from NexusMods.App provides a file system abstraction IFileSystem which enables path re-mappings:

AWinePrefix prefix = //...

// creates a new IFileSystem, with path mappings into the wine prefix
IFileSystem wineFileSystem = prefix.CreateOverlayFileSystem(FileSystem.Shared);

// this wineFileSystem can be used instead of FileSystem.Shared:
var handler = new OriginHandler(wineFileSystem);

// you can also create a new IRegistry:
IRegistry wineRegistry = prefix.CreateRegistry(FileSystem.Shared);

// and use both:
var handler = new EGSHandler(wineRegistry, wineFileSystem);

Default Prefix Manager

GameCollector.Wine implements a IWinePrefixManager for finding Wine prefixes.

Usage:

var prefixManager = new DefaultWinePrefixManager(FileSystem.Shared);

foreach (var result in prefixManager.FindPrefixes())
{
    result.Switch(prefix =>
    {
        Console.WriteLine($"Found wine prefix at {prefix.ConfigurationDirectory}");
    }, error =>
    {
        Console.WriteLine(error.Value);
    });
}

Bottles

GameCollector.Wine implements a IWinePrefixManager for finding Wine prefixes managed by Bottles.

Usage:

var prefixManager = new BottlesWinePrefixManager(FileSystem.Shared);

foreach (var result in prefixManager.FindPrefixes())
{
    result.Switch(prefix =>
    {
        Console.WriteLine($"Found wine prefix at {prefix.ConfigurationDirectory}");
    }, error =>
    {
        Console.WriteLine(error.Value);
    });
}

Proton

Valve's Proton is a compatibility tool for Steam and is mostly based on Wine. The Wine prefixes managed by Proton are in the compatdata directory of the steam library where the game itself is installed. Since the path is relative to the game itself and requires the app id, erri120 decided to put this functionality in the Steam store handler:

SteamGame? steamGame = steamHandler.FindOneGameById(1237970, out var errors);
if (steamGame is null) return;

ProtonWinePrefix protonPrefix = steamGame.GetProtonPrefix();
var protonPrefixDirectory = protonPrefix.ProtonDirectory;

if (protonDirectory != default && fileSystem.DirectoryExists(protonDirectory))
{
    Console.WriteLine($"Proton prefix is at {protonDirectory}");
}

Trimming

Self-contained deployments and executables can be trimmed starting with .NET 6. This feature is only available to applications that are published self-contained.

Trimmable:

  • GameCollector.Common
  • GameCollector.RegistryUtils
  • GameCollector.Wine
  • GameCollector.StoreHandlers.Steam
  • GameCollector.StoreHandlers.GOG
  • GameCollector.StoreHandlers.EGS
  • GameCollector.StoreHandlers.Origin

NOT Trimmable:

I recommend looking at the project file of the example project, if you run into warnings or errors with trimming.

Contributing

See CONTRIBUTING for more information.

License

See LICENSE for more information.

Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (4)

Showing the top 4 NuGet packages that depend on GameCollector.SQLiteUtils:

Package Downloads
GameCollector

Package Description

GameCollector.StoreHandlers.GOG

Library for finding games owned and installed with GOG Galaxy.

GameCollector.StoreHandlers.Itch

Library for finding games owned and installed with itch.

GameCollector.StoreHandlers.Amazon

Library for finding games owned and installed with Amazon Games.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
4.4.0.1 117 12/12/2024
4.3.2.1 130 10/9/2024
4.3.1.1 112 10/4/2024
4.2.4.1 138 7/11/2024
4.2.3.2 140 7/3/2024
4.2.3.1 127 7/3/2024
4.2.0.8 155 4/16/2024
4.2.0.7 153 3/12/2024
4.2.0.6 159 3/5/2024
4.2.0.5 158 2/25/2024
4.2.0.4 170 2/14/2024
4.2.0.2 183 2/8/2024