C# IDataRecord.GetGuid方法代码示例

 public EntityInitialState(IDataRecord record)
 {
     this.id = record.GetGuid("Id");
     this.timeStamp = record.GetDateTime("TimeStamp");
     this.parent = record.GetOrdinal("Parent") > -1 ? record.GetGuid("Parent") : Guid.Empty;
     this.sequence = record.GetOrdinal("Sequence") > -1 ? record.GetUInt32("Sequence") : 0;
     this.isNew = false;
     this.record = record;
 }

        public ValueInitialState(IDataRecord record)
        {
            if (record == null)
                throw new ArgumentNullException("record");

            this.id = record.GetGuid("Id");
            this.parent = record.GetGuid("Parent");
            this.sequence = record.GetUInt32("Sequence");
            this.isNew = false;
            this.record = record;
        }

 private static MessageEnvelope Fill(IDataRecord reader)
 {
     var conversationId = reader.GetGuid(0);
 	var messageEnvelope = ((byte[]) reader.GetValue(1)).ToMessageEnvelope();
 	messageEnvelope.ConversationId = conversationId;
 	return messageEnvelope;
 }

        /* @"select se.conversation_handle, se.conversation_group_id, s.name [service],
               sc.name [contract], se.state_desc, se.far_service, se.is_initiator,
               se.lifetime,se.far_broker_instance, from sys.conversation_endpoints se
                          join sys.services s on se.service_id = s.service_id
                          join sys.service_contracts sc on se.service_contract_id = sc.service_contract_id
                          where se.state in ('SO','SI','CO')";*/
        public SSBIConversation(BrokerService bServ, IDataRecord rec)
        {
            _handle = rec.GetGuid(0);
              _grpId = rec.GetGuid(1);
              _fromService = rec.GetString(2);
              _toService = rec.GetString(5);
              _state = rec.GetString(4);
              _contract = rec.GetString(3);
              _initiator = rec.GetBoolean(6);
              _lifeTime = rec.GetDateTime(7);
              string o = rec[8].ToString();
              _farBrokerGuid = Guid.Empty;
              if(o != string.Empty)
            _farBrokerGuid = new Guid(rec.GetString(8));
              _serv = bServ;

              //_msgColl = smo.GetMessageCollection(bServ, bServ.Parent.Parent, _handle, null);
        }

 /// <summary>
 /// Gets the value.
 /// </summary>
 /// <param name="index">The index.</param>
 /// <param name="dataRecord">The data record.</param>
 /// <returns></returns>
 private object GetValue(int index, IDataRecord dataRecord)
 {
     if (dataRecord.IsDBNull(index))
     {
         return DBNull.Value;
     }
     if (dataRecord.GetFieldType(index) == typeof(Guid))
     {
         return dataRecord.GetGuid(index);
     }
     return new Guid(Convert.ToString(dataRecord[index]));
 }

 public static ExceptionLog Create(IDataRecord reader)
 {
     return new ExceptionLog
     {
         Id = reader.GetGuid(reader.GetOrdinal("Id")),
         BaseDirectory = reader.GetNullableString("BaseDirectory"),
         Process = reader.GetNullableString("Process"),
         Machine = reader.GetNullableString("Machine"),
         Level = reader.GetNullableString("Level"),
         Logger = reader.GetNullableString("Logger"),
         LogOn = reader.GetDateTime(reader.GetOrdinal("LogOn")),
         Message = reader.GetNullableString("Message"),
         Thread = reader.GetNullableString("Thread"),
         Exception = reader.GetNullableString("Exception")
     };
 }

        /// <summary>
        /// Creates a new <see cref="Saga"/>.
        /// </summary>
        /// <param name="record">The record from which to create the new <see cref="Saga"/>.</param>
        private SagaTimeout CreateSagaTimeout(IDataRecord record)
        {
            var id = record.GetGuid(Column.Id);
            var typeId = record.GetGuid(Column.TypeId);
            var timeout = record.GetDateTime(Column.Timeout);

            return new SagaTimeout(GetSagaType(typeId), id, timeout);
        }

 public static OperationLog Create(IDataRecord reader)
 {
     return new OperationLog
     {
         Id = reader.GetGuid(reader.GetOrdinal("Id")),
         AccountId = reader.GetGuid(reader.GetOrdinal("AccountId")),
         FunctionId = reader.GetGuid(reader.GetOrdinal("FunctionId")),
         EntityTypeId = reader.GetGuid(reader.GetOrdinal("EntityTypeId")),
         EntityTypeName = reader.GetNullableString("EntityTypeName"),
         AppSystemId = reader.GetGuid(reader.GetOrdinal("AppSystemId")),
         AppSystemName = reader.GetNullableString("AppSystemName"),
         ResourceTypeId = reader.GetGuid(reader.GetOrdinal("ResourceTypeId")),
         ResourceName = reader.GetNullableString("ResourceName"),
         Description = reader.GetNullableString("Description"),
         LoginName = reader.GetNullableString("LoginName"),
         UserName = reader.GetNullableString("UserName"),
         CreateOn = reader.GetDateTime(reader.GetOrdinal("CreateOn")),
         IpAddress = reader.GetNullableString("IpAddress"),
         TargetId = reader.GetGuid(reader.GetOrdinal("TargetId"))
     };
 }

        /// <summary>
        /// Creates a new <see cref="Commit"/>.
        /// </summary>
        /// <param name="record">The record from which to create the new <see cref="Commit"/>.</param>
        private Commit CreateCommit(IDataRecord record)
        {
            var id = record.GetInt64(Column.Id);
            var timestamp = record.GetDateTime(Column.Timestamp);
            var correlationId = record.GetGuid(Column.CorrelationId);
            var streamId = record.GetGuid(Column.StreamId);
            var version = record.GetInt32(Column.Version);
            var data = serializer.Deserialize<CommitData>(record.GetBytes(Column.Data));

            return new Commit(id, timestamp, correlationId, streamId, version, data.Headers, data.Events);
        }

 private MessageEnvelope Fill( IDataRecord reader )
 {
     var conversationId = reader.GetGuid( 0 );
        var messageEnvelope = serializationService.Deserialize( (byte[]) reader.GetValue( 1 ) );
        messageEnvelope.ConversationId = conversationId;
        return messageEnvelope;
 }

 public static Guid GetFromReader(IDataRecord record, int pos)
 {
     return record.GetGuid(pos);
 }

 public TxStatus(IDataRecord rec)
 {
     _cnvHandle = rec.GetGuid(0);
       _remService = rec.GetString(1);
       _service = rec.GetString(2);
       _contract = rec.GetString(3);
       _msgType = rec.GetString(4);
       _isCnvError = rec.GetBoolean(5);
       _isEndDialog = rec.GetBoolean(6);
       _txStatus = rec.GetString(7);
 }

 public static void ReadFrom(this ICdlValueWriter writer, IDataRecord record, int index)
 {
     if (record.IsDBNull(index))
     {
         writer.SetNull();
         return;
     }
     Type type = record.GetFieldType(index);
     try
     {
         switch (Type.GetTypeCode(type))
         {
             case TypeCode.Boolean:
                 writer.SetBoolean(record.GetBoolean(index));
                 break;
             case TypeCode.Byte:
                 writer.SetByte(record.GetByte(index));
                 break;
             case TypeCode.Int16:
                 writer.SetInt16(record.GetInt16(index));
                 break;
             case TypeCode.Int32:
                 writer.SetInt32(record.GetInt32(index));
                 break;
             case TypeCode.Int64:
                 writer.SetInt64(record.GetInt64(index));
                 break;
             case TypeCode.SByte:
                 unchecked
                 {
                     writer.SetSByte((sbyte) record.GetByte(index));
                 }
                 break;
             case TypeCode.UInt16:
                 unchecked
                 {
                     writer.SetUInt16((ushort) record.GetInt16(index));
                 }
                 break;
             case TypeCode.UInt32:
                 unchecked
                 {
                     writer.SetUInt32((uint) record.GetInt32(index));
                 }
                 break;
             case TypeCode.UInt64:
                 unchecked
                 {
                     writer.SetUInt64((ulong) record.GetInt64(index));
                 }
                 break;
             case TypeCode.DateTime:
                 writer.SetDateTime(record.GetDateTime(index));
                 break;
             case TypeCode.Decimal:
                 writer.SetDecimal(record.GetDecimal(index));
                 break;
             case TypeCode.Single:
                 writer.SetFloat(record.GetFloat(index));
                 break;
             case TypeCode.Double:
                 writer.SetDouble(record.GetDouble(index));
                 break;
             case TypeCode.String:
                 writer.SetString(record.GetString(index));
                 break;
             default:
                 if (type == typeof (Guid))
                 {
                     writer.SetGuid(record.GetGuid(index));
                 }
                 else if (type == typeof (byte[]))
                 {
                     writer.SetByteArray((byte[]) record.GetValue(index));
                 }
                 else
                 {
                     writer.SetString(record.GetValue(index).ToString());
                 }
                 break;
         }
     }
     catch (Exception err)
     {
         try
         {
             object val = record[index];
             // try to read from boxed value (not very effective)
             writer.ReadFrom(val);
         }
         catch
         {
             try
             {
                 writer.SetString(record.GetString(index));
             }
             catch
             {
                 // add information to exception
                 try
//.........这里部分代码省略.........

        /// <summary>
        /// Creates a new <see cref="Saga"/>.
        /// </summary>
        /// <param name="record">The record from which to create the new <see cref="Saga"/>.</param>
        private Saga CreateSaga(IDataRecord record)
        {
            var id = record.GetGuid(Column.Id);
            var version = record.GetInt32(Column.Version);
            var timeout = record.GetNullableDateTime(Column.Timeout);
            var saga = serializer.Deserialize<Saga>(record.GetBytes(Column.State));

            saga.CorrelationId = id;
            saga.Version = version;
            saga.Timeout = timeout;

            return saga;
        }

        private static EventInStorage readEventInStorage(IDataRecord reader, int startingOrdinal)
        {
            const int eventIdOrdinal = 0;
            const int streamIdOrdinal = 1;
            const int contextNameOrdinal = 2;
            const int sequenceOrdinal = 3;
            const int globalSequenceOrdinal = 4;
            const int timestampOrdinal = 5;
            const int eventTypeOrdinal = 6;
            const int headerOrdinal = 7;
            const int bodyOrdinal = 8;

            var eventId = reader.GetGuid(eventIdOrdinal + startingOrdinal);
            var stream = reader.GetString(streamIdOrdinal + startingOrdinal);
            var contextName = reader.GetString(contextNameOrdinal + startingOrdinal);
            var sequence = (long)reader.GetValue(sequenceOrdinal + startingOrdinal);
            var globalSequence = (long)reader.GetValue(globalSequenceOrdinal + startingOrdinal);
            var timestamp = reader.GetDateTime(timestampOrdinal + startingOrdinal);
            var typeKey = reader.GetString(eventTypeOrdinal + startingOrdinal);
            var header = reader[headerOrdinal + startingOrdinal] as string;
            var body = reader.GetString(bodyOrdinal + startingOrdinal);

            var @event = new EventInStorage(eventId, contextName, stream, sequence, globalSequence, timestamp, typeKey,
                header, body);

            return @event;
        }