Esempio n. 1
0
 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));
Esempio n. 2
0
 public static League?Get(int id) => ExecuteGet("SELECT * FROM leagues WHERE id=@id", FromReader, ("id", id));
Esempio n. 3
0
 public static Team?Get(long id)
 => ExecuteGet(
     "SELECT * FROM teams WHERE id=@id",
     FromReader,
     ("id", id));
Esempio n. 4
0
 public static Team?Get(string name, int leagueId)
 => ExecuteGet(
     "SELECT * FROM teams WHERE name=@name AND league_id=@leagueId",
     FromReader,
     ("name", name),
     ("leagueId", leagueId));
Esempio n. 5
0
 public static string?Get(string key)
 => ExecuteGet(
     "SELECT value FROM __meta WHERE key=@key",
     r => r.GetString(0),
     ("key", key));