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