private SQLiteDataReader GetZodiacsDataReader() { using var command = _connection.CreateCommand(); command.Connection = _connection; command.CommandText = $"select {Zodiac.GetIdColumnName()}, {Zodiac.GetNameColumnName()}, {Zodiac.GetTypeColumnName()} " + $"from {Zodiac.GetTableName()};"; Console.WriteLine("Execute SQL: " + command.CommandText); return(command.ExecuteReader()); }
public Zodiac GetZodiac(int id) { using var command = _connection.CreateCommand(); command.Connection = _connection; command.CommandText = $"select {Zodiac.GetIdColumnName()}, {Zodiac.GetNameColumnName()}, {Zodiac.GetTypeColumnName()} " + $"from {Zodiac.GetTableName()} " + $"where {Zodiac.GetIdColumnName()} = :id;"; command.Parameters.AddWithValue("id", id); Console.WriteLine("Execute SQL: " + command.CommandText); return(Factory.CreateZodiac(command.ExecuteReader())); }
private SQLiteDataReader GetZodiacDataReader(ZodiacType zodiacType) { using var command = _connection.CreateCommand(); command.Connection = _connection; command.CommandText = $"select {Zodiac.GetIdColumnName()}, {Zodiac.GetNameColumnName()}, {Zodiac.GetTypeColumnName()} " + $"from {Zodiac.GetTableName()} " + $"where {Zodiac.GetTypeColumnName()} = :enum_number;"; command.Parameters.AddWithValue("enum_number", (int)zodiacType); Console.WriteLine("Execute SQL: " + command.CommandText); return(command.ExecuteReader()); }