/// <summary>
/// Read data from reader
/// </summary>
/// <param name="reader">Sql data reader</param>
/// <returns>Collection of read data</returns>
private IEnumerable <ForeignKeyDto> ReadForeignKeys(SqlDataReader reader)
{
var res = new List <ForeignKeyDto>();
while (reader.Read())
{
var dto = new ForeignKeyDto();
dto.PrimaryKeyTable = reader.GetString(2);
dto.PrimaryKeyCollumn = reader.GetString(3);
dto.ForeignKeyTable = reader.GetString(6);
dto.ForeignKeyCollumn = reader.GetString(7);
dto.Name = reader.GetString(11);
res.Add(dto);
}
return(res);
}
/// <summary>
/// Read data from reader
/// </summary>
/// <param name="reader">Oracle data reader</param>
/// <returns>Collection of read data</returns>
private IEnumerable <ForeignKeyDto> ReadForeignKeys(OracleDataReader reader)
{
var res = new List <ForeignKeyDto>();
while (reader.Read())
{
var dto = new ForeignKeyDto();
int i = 0;
dto.Name = reader.GetString(i++);
dto.ForeignKeyTable = reader.GetString(i++);
dto.ForeignKeyCollumn = reader.GetString(i++);
dto.PrimaryKeyTable = reader.GetString(i++);
dto.PrimaryKeyCollumn = reader.GetString(i++);
dto.DeleteAction = reader.GetString(i++);
dto.LastModified = reader.GetDateTime(i++);
dto.UpdateAction = dto.DeleteAction;
res.Add(dto);
}
return(res);
}
