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