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