/// <summary> /// Builds a data object from the current row in a data reader.. /// </summary> /// <param name="dataReader">Container for database row.</param> /// <returns>Data object built from current row.</returns> private static TestUpdateChangedOnlyData GetDataObjectFromReader(SqlDataReader dataReader) { TestUpdateChangedOnlyData data = new TestUpdateChangedOnlyData(); if (dataReader.IsDBNull(dataReader.GetOrdinal("sqlstringcolumn"))) { data.StringColumn = StringType.UNSET; } else { data.StringColumn = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("sqlstringcolumn"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("sqlintcolumn"))) { data.Int32Column = IdType.UNSET; } else { data.Int32Column = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("sqlintcolumn"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("EmailFormat"))) { data.EmailFormat = FormatType.UNSET; } else { data.EmailFormat = FormatType.GetInstance(dataReader.GetString(dataReader.GetOrdinal("EmailFormat"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("addr1"))) { data.Address.Address1 = StringType.UNSET; } else { data.Address.Address1 = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("addr1"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("addr2"))) { data.Address.Address2 = StringType.UNSET; } else { data.Address.Address2 = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("addr2"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("city"))) { data.Address.City = StringType.UNSET; } else { data.Address.City = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("city"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("state"))) { data.Address.State = StringType.UNSET; } else { data.Address.State = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("state"))); } if (dataReader.IsDBNull(dataReader.GetOrdinal("zip"))) { data.Address.PostalCode = StringType.UNSET; } else { data.Address.PostalCode = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("zip"))); } return(data); }