public static TeamMember?Get(int userId, Team team)
=> ExecuteGet(
"SELECT * FROM team_members WHERE user_id=@userId AND team_id=@team",
FromReader,
("userId", userId),
("team", team.Id));
public static League?Get(int id) => ExecuteGet("SELECT * FROM leagues WHERE id=@id", FromReader, ("id", id));
public static Team?Get(long id)
=> ExecuteGet(
"SELECT * FROM teams WHERE id=@id",
FromReader,
("id", id));
public static Team?Get(string name, int leagueId)
=> ExecuteGet(
"SELECT * FROM teams WHERE name=@name AND league_id=@leagueId",
FromReader,
("name", name),
("leagueId", leagueId));
public static string?Get(string key)
=> ExecuteGet(
"SELECT value FROM __meta WHERE key=@key",
r => r.GetString(0),
("key", key));