private static IEnumerable<File> IterateFiles(DbDataReader reader)
{
while(!reader.IsClosed && reader.Read())
{
yield return
new File
{
Name = reader.GetString(0),
Ext = reader.GetString(1),
Url = reader.TryGetString(2)
};
}
}
private static IEnumerable<Msg> IterateMessages(DbDataReader reader)
{
while(!reader.IsClosed && reader.Read())
{
yield return
new Msg
{
Time = reader.GetDateTime(0),
Type = reader.TryGetString(1).TryParseOrDefault(MsgType.Unknown),
Text = reader.TryGetString(2)
};
}
}
private static IEnumerable<Flag> IterateFlags(DbDataReader reader)
{
while(!reader.IsClosed && reader.Read())
{
yield return
new Flag
{
Value = reader.GetString(0),
Type = reader.TryGetString(1).TryParseOrDefault(FlagType.Unknown)
};
}
}
private static IEnumerable<Score> IterateScores(DbDataReader reader)
{
while(!reader.IsClosed && reader.Read())
{
yield return
new Score
{
Name = reader.GetString(0),
Area = reader.TryGetString(1),
Avatar = reader.TryGetString(2),
Stars = reader.TryGetInt32(3)
};
}
}
