C# IDataRecord类代码示例

        /// <summary>
        /// Reads the values from an <see cref="IDataRecord"/> and assigns the read values to this
        /// object's properties. The database column's name is used to as the key, so the value
        /// will not be found if any aliases are used or not all columns were selected.
        /// </summary>
        /// <param name="source">The object to add the extension method to.</param>
        /// <param name="dataRecord">The <see cref="IDataRecord"/> to read the values from. Must already be ready to be read from.</param>
        public static void ReadValues(this CharacterTemplateInventoryTable source, IDataRecord dataRecord)
        {
            Int32 i;

            i = dataRecord.GetOrdinal("chance");

            source.Chance = (ItemChance)dataRecord.GetUInt16(i);

            i = dataRecord.GetOrdinal("character_template_id");

            source.CharacterTemplateID = (CharacterTemplateID)dataRecord.GetUInt16(i);

            i = dataRecord.GetOrdinal("id");

            source.ID = dataRecord.GetInt32(i);

            i = dataRecord.GetOrdinal("item_template_id");

            source.ItemTemplateID = (ItemTemplateID)dataRecord.GetUInt16(i);

            i = dataRecord.GetOrdinal("max");

            source.Max = dataRecord.GetByte(i);

            i = dataRecord.GetOrdinal("min");

            source.Min = dataRecord.GetByte(i);
        }

        public ChangeAuditEventLoaderInfo(IDataRecord record)
        {
            Contract.Requires(null != record, "The record object can not be null.");

            record.TryGetOrdinal("TextData", out _textDataOrdinal);
            record.TryGetOrdinal("DatabaseID", out _databaseIDOrdinal);
            record.TryGetOrdinal("LineNumber", out _lineNumberOrdinal);
            record.TryGetOrdinal("NTUserName", out _nTUserNameOrdinal);
            record.TryGetOrdinal("NTDomainName", out _nTDomainNameOrdinal);
            record.TryGetOrdinal("HostName", out _hostNameOrdinal);
            record.TryGetOrdinal("ClientProcessID", out _clientProcessIDOrdinal);
            record.TryGetOrdinal("ApplicationName", out _applicationNameOrdinal);
            record.TryGetOrdinal("LoginName", out _loginNameOrdinal);
            record.TryGetOrdinal("SPID", out _sPIDOrdinal);
            record.TryGetOrdinal("StartTime", out _startTimeOrdinal);
            record.TryGetOrdinal("EventSubClass", out _eventSubClassOrdinal);
            record.TryGetOrdinal("Success", out _successOrdinal);
            record.TryGetOrdinal("ServerName", out _serverNameOrdinal);
            record.TryGetOrdinal("EventClass", out _eventClassOrdinal);
            record.TryGetOrdinal("NestLevel", out _nestLevelOrdinal);
            record.TryGetOrdinal("DatabaseName", out _databaseNameOrdinal);
            record.TryGetOrdinal("OwnerName", out _ownerNameOrdinal);
            record.TryGetOrdinal("DBUserName", out _dBUserNameOrdinal);
            record.TryGetOrdinal("LoginSid", out _loginSidOrdinal);
            record.TryGetOrdinal("ColumnPermissions", out _columnPermissionsOrdinal);
            record.TryGetOrdinal("RequestID", out _requestIDOrdinal);
            record.TryGetOrdinal("XactSequence", out _xactSequenceOrdinal);
            record.TryGetOrdinal("EventSequence", out _eventSequenceOrdinal);
            record.TryGetOrdinal("IsSystem", out _isSystemOrdinal);
            record.TryGetOrdinal("SessionLoginName", out _sessionLoginNameOrdinal);
        }

 /// <summary>
 /// Map the basic fields for the BusinessContact table to the Channel model object
 /// </summary>
 /// <param name="record">The SqlDataReader with the executed query result</param>
 /// <param name="prefix">a prefix used to identify fields for the BusinessContact model  in the resultset if required</param>        
 /// <returns>An instance of BusinessContactl</returns>
 internal static BusinessContactPerson MapRecord(IDataRecord record, string prefix = "")
 {
     return new BusinessContactPerson
     {
         BusinessId = DbHelper.ConvertValue<long>(record[prefix + Parameters.BusinessId]),
         ContactTypeCode = DbHelper.ConvertValue<string>(record[prefix + Parameters.ContactTypeCode]),
         TitleId = DbHelper.ConvertValue<byte?>(record[prefix + Parameters.TitleId]),
         Forename = DbHelper.ConvertValue<string>(record[prefix + Parameters.Forename]),
         Surname = DbHelper.ConvertValue<string>(record[prefix + Parameters.Surname]),
         Email = DbHelper.ConvertValue<string>(record[prefix + Parameters.Email]),
         UseBusinessAddress = DbHelper.ConvertValue<bool>(record[prefix + Parameters.UseBusinessAddress]),
         AddressLine1 = DbHelper.ConvertValue<string>(record[prefix + Parameters.AddressLine1]),
         AddressLine2 = DbHelper.ConvertValue<string>(record[prefix + Parameters.AddressLine2]),
         AddressLine3 = DbHelper.ConvertValue<string>(record[prefix + Parameters.AddressLine3]),
         City = DbHelper.ConvertValue<string>(record[prefix + Parameters.City]),
         StateProvinceId = DbHelper.ConvertValue<int?>(record[prefix + Parameters.StateProvinceId]),
         PostCode = DbHelper.ConvertValue<string>(record[prefix + Parameters.PostCode]),
         CountryId = DbHelper.ConvertValue<int?>(record[prefix + Parameters.CountryId]),
         Notes = DbHelper.ConvertValue<string>(record[prefix + Parameters.Notes]),
         IsPrimary = DbHelper.ConvertValue<bool>(record[prefix + Parameters.IsPrimary]),
         CreatedDatetime = DbHelper.ConvertValue<DateTime>(record[prefix + Parameters.CreatedDateTime]),
         UpdatedByUserId = DbHelper.ConvertValue<Guid>(record[prefix + Parameters.UpdatedByUserId]),
         UpdatedDateTime = DbHelper.ConvertValue<DateTime>(record[prefix + Parameters.UpdatedDatetime]),
     };
 }

        public static void Fill_EntityProperty_Ids( IDataRecord record, IList _includeEntityPropertyList, ref Hashtable _entityProperty_ids ) {

            if (_includeEntityPropertyList == null) return;

            foreach (EntityPropertyInfo info in _includeEntityPropertyList) {

                String columnName = info.ColumnName;
                try
                {
                    if (record[columnName] == DBNull.Value) continue;

                    if (_entityProperty_ids[columnName] == null)
                    {
                        _entityProperty_ids[columnName] = record[columnName] + ",";
                    }
                    else
                    {
                        String ids = _entityProperty_ids[columnName].ToString();
                        String tempId = "," + record[columnName] + ",";
                        if (("," + ids).IndexOf(tempId) < 0)
                        {
                            _entityProperty_ids[columnName] = ids + record[columnName] + ",";
                        }
                    }
                }
                catch (Exception ex)
                {
                    LogManager.GetLogger("Class:System.ORM.Operation.EntityPropertyUtil Method:Fill_EntityProperty_Ids").Info("异常：" + ex.Message + "\n堆栈：" + ex.StackTrace);
                }
            }
        }

 /// <summary>
 /// constructor
 /// </summary>
 /// <param name="dataRecord"></param>
 public C2C(IDataRecord dataRecord)
 {
     this.Id = int.Parse(dataRecord["Id"].ToString());
     this.Campus = dataRecord["CAMPUS"].ToString().Replace("'", string.Empty);
     this.CadGap = dataRecord["CAD_GAP"].ToString();
     this.CadMath = dataRecord["CAD_MATH"].ToString();
     this.CadPost = dataRecord["CAD_POST"].ToString();
     this.CadProgress = dataRecord["CAD_PROGRESS"].ToString();
     this.CadRead = dataRecord["CAD_READ"].ToString();
     this.CadScie = dataRecord["CAD_SCIE"].ToString();
     this.CadSoci = dataRecord["CAD_SOCI"].ToString();
     this.CampusName = dataRecord["CAMPNAME"].ToString();
     this.Cflalted = dataRecord["CFLALTED"].ToString();
     this.Cflchart = dataRecord["CFLCHART"].ToString();
     this.CountyName = dataRecord["CNTYNAME"].ToString();
     this.County = dataRecord["COUNTY"].ToString();
     this.CRating = dataRecord["C_RATING"].ToString();
     this.DistrictName = dataRecord["DISTNAME"].ToString();
     this.District = dataRecord["DISTRICT"].ToString();
     this.Grdspan = dataRecord["GRDSPAN"].ToString();
     this.Grdtype = dataRecord["GRDTYPE"].ToString();
     this.Paircamp = dataRecord["PAIRCAMP"].ToString();
     this.Pairname = dataRecord["PAIRNAME"].ToString();
     this.Region = dataRecord["REGION"].ToString();
 }

 public object Map(IDataRecord record, Type type)
 {
     var instance = _instanceFactory.CreateInstance(type);
     foreach (var propertySetter in _recordToPropertyMappers)
         propertySetter.Execute(record, instance);
     return instance;
 }

        /// <summary>
        /// Reads the values from an <see cref="IDataRecord"/> and assigns the read values to this
        /// object's properties. The database column's name is used to as the key, so the value
        /// will not be found if any aliases are used or not all columns were selected.
        /// </summary>
        /// <param name="source">The object to add the extension method to.</param>
        /// <param name="dataRecord">The <see cref="IDataRecord"/> to read the values from. Must already be ready to be read from.</param>
        public static void ReadValues(this WorldStatsUserLevelTable source, IDataRecord dataRecord)
        {
            Int32 i;

            i = dataRecord.GetOrdinal("character_id");

            source.CharacterID = (CharacterID)dataRecord.GetInt32(i);

            i = dataRecord.GetOrdinal("id");

            source.ID = dataRecord.GetUInt32(i);

            i = dataRecord.GetOrdinal("level");

            source.Level = dataRecord.GetByte(i);

            i = dataRecord.GetOrdinal("map_id");

            source.MapID = (Nullable<MapID>)(dataRecord.IsDBNull(i) ? (ushort?)null : dataRecord.GetUInt16(i));

            i = dataRecord.GetOrdinal("when");

            source.When = dataRecord.GetDateTime(i);

            i = dataRecord.GetOrdinal("x");

            source.X = dataRecord.GetUInt16(i);

            i = dataRecord.GetOrdinal("y");

            source.Y = dataRecord.GetUInt16(i);
        }

        /// <summary>
        /// Reads the values from an <see cref="IDataRecord"/> and assigns the read values to this
        /// object's properties. The database column's name is used to as the key, so the value
        /// will not be found if any aliases are used or not all columns were selected.
        /// </summary>
        /// <param name="source">The object to add the extension method to.</param>
        /// <param name="dataRecord">The <see cref="IDataRecord"/> to read the values from. Must already be ready to be read from.</param>
        public static void ReadValues(this AccountBanTable source, IDataRecord dataRecord)
        {
            Int32 i;

            i = dataRecord.GetOrdinal("account_id");

            source.AccountID = (AccountID)dataRecord.GetInt32(i);

            i = dataRecord.GetOrdinal("end_time");

            source.EndTime = dataRecord.GetDateTime(i);

            i = dataRecord.GetOrdinal("expired");

            source.Expired = dataRecord.GetBoolean(i);

            i = dataRecord.GetOrdinal("id");

            source.ID = dataRecord.GetInt32(i);

            i = dataRecord.GetOrdinal("issued_by");

            source.IssuedBy = (dataRecord.IsDBNull(i) ? null : dataRecord.GetString(i));

            i = dataRecord.GetOrdinal("reason");

            source.Reason = dataRecord.GetString(i);

            i = dataRecord.GetOrdinal("start_time");

            source.StartTime = dataRecord.GetDateTime(i);
        }

        internal Card(IDataRecord reader)
        {
            Id = reader.GetInt32(0);
            Ot = reader.GetInt32(1);
            Alias = reader.GetInt32(2);
            Setcode = reader.GetInt64(3);
            Type = reader.GetInt32(4);

            int levelInfo = reader.GetInt32(5);
            Level = levelInfo & 0xff;
            LScale = (levelInfo >> 24) & 0xff;
            RScale = (levelInfo >> 16) & 0xff;

            Race = reader.GetInt32(6);
            Attribute = reader.GetInt32(7);
            Attack = reader.GetInt32(8);
            Defense = reader.GetInt32(9);

            Data = new CardData()
            {
                Code = Id,
                Alias = Alias,
                Setcode = Setcode,
                Type = Type,
                Level = Level,
                Attribute = Attribute,
                Race = Race,
                Attack = Attack,
                Defense = Defense,
                LScale = LScale,
                RScale = RScale
            };
        }

 /// <summary>
 /// Reads a char array from the current <see cref="IDataRecord"/>.
 /// </summary>
 /// <param name="dataRecord">The target <see cref="IDataRecord"/>.</param>
 /// <param name="ordinal">The ordinal for the field that contains the stream data.</param>
 /// <returns>A new char array.</returns>
 public static char[] ReadCharArray(IDataRecord dataRecord, int ordinal)
 {
     long length = dataRecord.GetChars(ordinal, 0, null, 0, int.MaxValue);
     var buffer = new char[length];
     dataRecord.GetChars(ordinal, 0, buffer, 0, (int)length);
     return buffer;
 }

        /// <summary>
        /// Retrieve a Guid value from a data record with a default value.
        /// </summary>
        public override Guid GetGuid(IDataRecord dataRecord, int ordinal, Guid defaultValue)
        {
            if (dataRecord == null)
                throw new ArgumentNullException("dataRecord");

            if (dataRecord.IsDBNull(ordinal))
                return defaultValue;

            try
            {
                return new Guid(base.GetString(dataRecord, ordinal));
            }
            catch (ArgumentNullException)
            {
                return defaultValue;
            }
            catch (FormatException)
            {
                return defaultValue;
            }
            catch (OverflowException)
            {
                return defaultValue;
            }
        }

 /// <summary>
 /// Reads a byte array from the current <see cref="IDataRecord"/>.
 /// </summary>
 /// <param name="dataRecord">The target <see cref="IDataRecord"/>.</param>
 /// <param name="ordinal">The ordinal for the field that contains the stream data.</param>
 /// <returns>A new byte array.</returns>
 public static byte[] ReadByteArray(IDataRecord dataRecord, int ordinal)
 {
     long length = dataRecord.GetBytes(ordinal, 0, null, 0, int.MaxValue);
     var buffer = new byte[length];
     dataRecord.GetBytes(ordinal, 0, buffer, 0, (int)length);
     return buffer;
 }

        public LogoutEventLoaderInfo(IDataRecord record)
        {
            Contract.Requires(null != record, "The record object can not be null.");

            record.TryGetOrdinal("TextData", out _textDataOrdinal);
            record.TryGetOrdinal("DatabaseID", out _databaseIDOrdinal);
            record.TryGetOrdinal("NTUserName", out _nTUserNameOrdinal);
            record.TryGetOrdinal("NTDomainName", out _nTDomainNameOrdinal);
            record.TryGetOrdinal("HostName", out _hostNameOrdinal);
            record.TryGetOrdinal("ClientProcessID", out _clientProcessIDOrdinal);
            record.TryGetOrdinal("ApplicationName", out _applicationNameOrdinal);
            record.TryGetOrdinal("LoginName", out _loginNameOrdinal);
            record.TryGetOrdinal("SPID", out _sPIDOrdinal);
            record.TryGetOrdinal("Duration", out _durationOrdinal);
            record.TryGetOrdinal("StartTime", out _startTimeOrdinal);
            record.TryGetOrdinal("EndTime", out _endTimeOrdinal);
            record.TryGetOrdinal("Reads", out _readsOrdinal);
            record.TryGetOrdinal("Writes", out _writesOrdinal);
            record.TryGetOrdinal("CPU", out _cPUOrdinal);
            record.TryGetOrdinal("EventSubClass", out _eventSubClassOrdinal);
            record.TryGetOrdinal("Success", out _successOrdinal);
            record.TryGetOrdinal("ServerName", out _serverNameOrdinal);
            record.TryGetOrdinal("EventClass", out _eventClassOrdinal);
            record.TryGetOrdinal("DatabaseName", out _databaseNameOrdinal);
            record.TryGetOrdinal("LoginSid", out _loginSidOrdinal);
            record.TryGetOrdinal("RequestID", out _requestIDOrdinal);
            record.TryGetOrdinal("EventSequence", out _eventSequenceOrdinal);
            record.TryGetOrdinal("Type", out _typeOrdinal);
            record.TryGetOrdinal("IsSystem", out _isSystemOrdinal);
            record.TryGetOrdinal("SessionLoginName", out _sessionLoginNameOrdinal);
            record.TryGetOrdinal("GroupID", out _groupIDOrdinal);
        }

        internal DatabasePrincipalImpersonationEvent(IDataRecord record, DatabasePrincipalImpersonationEventLoaderInfo loaderInfo)
        {
            Contract.Requires(null != record, "The record must be valid.");
            Contract.Requires(null != loaderInfo, "The loaderInfo must be valid.");

            if (null != loaderInfo.TextDataOrdinal)
                _textData = record.GetNullableString(loaderInfo.TextDataOrdinal.Value);
            if (null != loaderInfo.DatabaseIDOrdinal)
                _databaseID = record.GetNullableInt32(loaderInfo.DatabaseIDOrdinal.Value);
            if (null != loaderInfo.TransactionIDOrdinal)
                _transactionID = record.GetNullableInt64(loaderInfo.TransactionIDOrdinal.Value);
            if (null != loaderInfo.NTUserNameOrdinal)
                _nTUserName = record.GetNullableString(loaderInfo.NTUserNameOrdinal.Value);
            if (null != loaderInfo.NTDomainNameOrdinal)
                _nTDomainName = record.GetNullableString(loaderInfo.NTDomainNameOrdinal.Value);
            if (null != loaderInfo.HostNameOrdinal)
                _hostName = record.GetNullableString(loaderInfo.HostNameOrdinal.Value);
            if (null != loaderInfo.ApplicationNameOrdinal)
                _applicationName = record.GetNullableString(loaderInfo.ApplicationNameOrdinal.Value);
            if (null != loaderInfo.LoginNameOrdinal)
                _loginName = record.GetNullableString(loaderInfo.LoginNameOrdinal.Value);
            if (null != loaderInfo.SPIDOrdinal)
                _sPID = record.GetNullableInt32(loaderInfo.SPIDOrdinal.Value);
            if (null != loaderInfo.StartTimeOrdinal)
                _startTime = record.GetNullableDateTime(loaderInfo.StartTimeOrdinal.Value);
            if (null != loaderInfo.PermissionsOrdinal)
                _permissions = record.GetNullableInt64(loaderInfo.PermissionsOrdinal.Value);
            if (null != loaderInfo.EventSubClassOrdinal)
                _eventSubClass = record.GetNullableInt32(loaderInfo.EventSubClassOrdinal.Value);
            if (null != loaderInfo.SuccessOrdinal)
                _success = record.GetNullableInt32(loaderInfo.SuccessOrdinal.Value);
            if (null != loaderInfo.ServerNameOrdinal)
                _serverName = record.GetNullableString(loaderInfo.ServerNameOrdinal.Value);
            if (null != loaderInfo.ObjectTypeOrdinal)
                _objectType = record.GetNullableInt32(loaderInfo.ObjectTypeOrdinal.Value);
            if (null != loaderInfo.NestLevelOrdinal)
                _nestLevel = record.GetNullableInt32(loaderInfo.NestLevelOrdinal.Value);
            if (null != loaderInfo.ObjectNameOrdinal)
                _objectName = record.GetNullableString(loaderInfo.ObjectNameOrdinal.Value);
            if (null != loaderInfo.DatabaseNameOrdinal)
                _databaseName = record.GetNullableString(loaderInfo.DatabaseNameOrdinal.Value);
            if (null != loaderInfo.OwnerNameOrdinal)
                _ownerName = record.GetNullableString(loaderInfo.OwnerNameOrdinal.Value);
            if (null != loaderInfo.RoleNameOrdinal)
                _roleName = record.GetNullableString(loaderInfo.RoleNameOrdinal.Value);
            if (null != loaderInfo.DBUserNameOrdinal)
                _dBUserName = record.GetNullableString(loaderInfo.DBUserNameOrdinal.Value);
            if (null != loaderInfo.LoginSidOrdinal)
                _loginSid = (Byte[])record.GetValue(loaderInfo.LoginSidOrdinal.Value);
            if (null != loaderInfo.RequestIDOrdinal)
                _requestID = record.GetNullableInt32(loaderInfo.RequestIDOrdinal.Value);
            if (null != loaderInfo.XactSequenceOrdinal)
                _xactSequence = record.GetNullableInt64(loaderInfo.XactSequenceOrdinal.Value);
            if (null != loaderInfo.EventSequenceOrdinal)
                _eventSequence = record.GetNullableInt64(loaderInfo.EventSequenceOrdinal.Value);
            if (null != loaderInfo.IsSystemOrdinal)
                _isSystem = record.GetNullableInt32(loaderInfo.IsSystemOrdinal.Value);
            if (null != loaderInfo.SessionLoginNameOrdinal)
                _sessionLoginName = record.GetNullableString(loaderInfo.SessionLoginNameOrdinal.Value);
        }

        private static BasicFinancialTransactionTagSetType ReadFinancialTransactionTagSetTypeFromDataReader(IDataRecord reader)
        {
            int financialTransactionTagSetTypeId = reader.GetInt32(0);
            string resourceName = reader.GetString(1);

            return new BasicFinancialTransactionTagSetType(financialTransactionTagSetTypeId, resourceName);
        }