public static List<int?> GetStationList(string connectionString) { using (MessageLogContext ctx = new MessageLogContext(connectionString)) { return ctx.MessageLogs.Select(m => m.StationNo.HasValue ? m.StationNo : 0).Distinct().ToList(); } }
public static List<string> GetProgramList(string connectionString) { using (MessageLogContext ctx = new MessageLogContext(connectionString)) { return ctx.MessageLogs.Select(m => m.ProgramName).Distinct().ToList(); } }