private SourceTimetableRecord GetSourceTimetableRecord(string identifierColName, object identifierValue) { var sb = new SqlBuilder(); sb.Append("select src_timetable_id, timetable_name, server_name, database_name, schema_version, guid"); sb.AppendFormat("from {0} where {1} = @ID", GetQualifiedTableName(SrcTimetableName), identifierColName); SqlParameter[] sqlParameters = { new SqlParameter("@ID", identifierValue) }; SourceTimetableRecord result = null; DatabaseUtils.GetSingleResult( ConnectionString, sb.ToString(), TimeoutSecs, r => { result = new SourceTimetableRecord { Id = (int)r["src_timetable_id"], Name = (string)r["timetable_name"], SqlServerName = (string)r["server_name"], DatabaseName = (string)r["database_name"], SchemaVersion = (int)r["schema_version"], Identifier = (Guid)r["guid"] }; }, sqlParameters); return(result); }
public IReadOnlyList <SourceTimetableRecord> GetSourceTimetableRecords() { var sb = new SqlBuilder(); sb.Append("select src_timetable_id, timetable_name, server_name, database_name, schema_version, guid"); sb.AppendFormat("from {0}", GetQualifiedTableName(SrcTimetableName)); var result = new List <SourceTimetableRecord>(); DatabaseUtils.EnumerateResults(ConnectionString, sb.ToString(), TimeoutSecs, r => { var rec = new SourceTimetableRecord { Name = (string)r["timetable_name"], SqlServerName = (string)r["server_name"], DatabaseName = (string)r["database_name"], SchemaVersion = (int)r["schema_version"], Identifier = (Guid)r["guid"] }; result.Add(rec); }); return(result); }