public static IEntityList <Starter> Select()
{
IEntityList <Starter> result = new EntityList <Starter>();
using (SQLiteConnection connection = OpenConnection())
{
using (SQLiteCommand cmd = new SQLiteCommand(connection))
{
StringBuilder sb = new StringBuilder()
.Append("SELECT Id, FirstName, LastName, Birthdate, Club, Comment, Costs, Paied ")
.Append("FROM EO_Starter ")
.Append("ORDER BY LastName, FirstName;");
cmd.CommandText = sb.ToString();
_log.Debug(CreateLogString(cmd));
using (SQLiteDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
result.Add(new Starter
{
Id = rdr.GetInt32(0),
FirstName = rdr.GetNullableString(1),
LastName = rdr.GetNullableString(2),
Birthdate = rdr.GetNullableDateTime(3),
Club = rdr.GetNullableString(4),
Comment = rdr.GetNullableString(5),
Costs = rdr.GetNullableDecimal(6),
Paied = rdr.GetBoolean(7)
});
}
}
}
}
return(result);
}
