コード例 #1
0
        /// <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);
        }