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