C# DbDataReader.GetString方法代码示例

 public ResourceRecord(DbDataReader reader)
 {
     Page = reader.GetString(reader.GetOrdinal("resourcepage"));
     CultureCode = reader.GetString(reader.GetOrdinal("culturecode"));
     Key = reader.GetString(reader.GetOrdinal("resourcekey"));
     Value = reader.GetString(reader.GetOrdinal("resourcevalue"));
 }

        private static BasicExceptionLog ExceptionLogFromDataReader (DbDataReader reader)
        {

            int ExceptionId = reader.GetInt32(0);
            DateTime ExceptionDateTime = reader.GetDateTime(1);
            string Source = reader.GetString(2);
            string ExceptionText = reader.GetString(3);
            return new BasicExceptionLog(ExceptionId, ExceptionDateTime, Source, ExceptionText);
        }

        private BasicExternalCredential ReadExternalCredentialFromDataReader (DbDataReader reader)
        {
            int externalCredentialId = reader.GetInt32(0);
            string serviceName = reader.GetString(1);
            string login = reader.GetString(2);
            string password = reader.GetString(3);

            return new BasicExternalCredential(externalCredentialId, serviceName, login, password);
        }

        private static BasicCountry ReadCountryFromDataReader(DbDataReader reader)
        {
            int countryId = reader.GetInt32(0);
            string name = reader.GetString(1);
            string code = reader.GetString(2).ToUpperInvariant();
            string culture = reader.GetString(3);
            int geographyId = reader.GetInt32(4);

            return new BasicCountry(countryId, name, code, culture, geographyId);
        }

        public IPersistentRepresentation Map(DbDataReader reader, IActorRef sender = null)
        {
            var persistenceId = reader.GetString(PersistenceIdIndex);
            var sequenceNr = reader.GetInt64(SequenceNrIndex);
            var isDeleted = reader.GetBoolean(IsDeletedIndex);
            var manifest = reader.GetString(ManifestIndex);

            // timestamp is SQL-journal specific field, it's not a part of casual Persistent instance  
            var payload = GetPayload(reader, manifest);

            return new Persistent(payload, sequenceNr, persistenceId, manifest, isDeleted, sender);
        }

        private static BasicAutoMail ReadAutoMailFromDataReader (DbDataReader reader)
        {
            int autoMailId = reader.GetInt32(0);
            AutoMailType type = (AutoMailType) Enum.Parse(typeof (AutoMailType), reader.GetString(1));
            int geographyId = reader.GetInt32(3);
            int organizationId = reader.GetInt32(2);
            int authorPersonId = reader.GetInt32(4); // appear to be unused?
            string title = reader.GetString(5);
            string body = reader.GetString(6);

            return new BasicAutoMail(autoMailId, type, organizationId, geographyId, authorPersonId,
                                     title, body);
        }

 public WorkoutPlan(DbDataReader reader)
 {
     _id = reader.GetInt64(0);
     _title = reader.GetValue(1).ToString() == "" ? "" : reader.GetString(1);
     _period = reader.GetValue(2).ToString() == "" ? (byte)0 : reader.GetByte(2);
     _creatorId = reader.GetValue(3).ToString() == "" ? 0 : reader.GetInt64(3);
 }

        private static BasicGeography ReadGeographyFromDataReader (DbDataReader reader)
        {
            int geographyId = reader.GetInt32(0);
            int parentGeographyId = reader.GetInt32(1);
            string name = reader.GetString(2);

            return new BasicGeography(geographyId, parentGeographyId, name);
        }

        private static BasicPerson ReadPersonFromDataReader (DbDataReader reader)
        {
            int personId = reader.GetInt32(0);
            string passwordHash = reader.GetString(1);
            string name = reader.GetString(2);
            string email = reader.GetString(3);
            string street = reader.GetString(4);
            string postalCode = reader.GetString(5);
            string cityName = reader.GetString(6);
            int countryId = reader.GetInt32(7);
            string phone = reader.GetString(8);
            int geographyId = reader.GetInt32(9);
            DateTime birthdate = reader.GetDateTime(10);
            int genderId = reader.GetInt32(11);


            // Fix broken names, emails

            email = email.ToLower().Trim();
            name = name.Trim();

            while (name.Contains("  "))
            {
                name = name.Replace("  ", " ");
            }


            return new BasicPerson(personId, passwordHash, name, email, street, postalCode, cityName, countryId, phone,
                                   geographyId, birthdate, (PersonGender)genderId);
        }

        private static BasicOrganization ReadOrganizationFromDataReader (DbDataReader reader)
        {
            int organizationId = reader.GetInt32(0);
            int parentOrganizationId = reader.GetInt32(1);
            string name = reader.GetString(2);
            string nameInternational = reader.GetString(3);
            string nameShort = reader.GetString(4);
            string domain = reader.GetString(5);
            string mailPrefix = reader.GetString(6);
            int anchorGeographyId = reader.GetInt32(7);
            bool acceptsMembers = reader.GetBoolean(8);
            bool autoAssignNewMembers = reader.GetBoolean(9);
            int defaultCountryId = reader.GetInt32(10);

            return new BasicOrganization(organizationId, parentOrganizationId, name, nameInternational, nameShort,
                                         domain, mailPrefix, anchorGeographyId, acceptsMembers, autoAssignNewMembers,
                                         defaultCountryId);
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="reader"></param>
        /// <returns></returns>
        protected static string GetTableType(DbDataReader reader)
        {
            const string TABLE_TYPE = @"TABLE_TYPE";

            var ordinal = reader.GetOrdinal(TABLE_TYPE);
            var type = reader.GetString(ordinal);

            return type;
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="reader"></param>
        /// <returns></returns>
        protected static string GetTableName(DbDataReader reader)
        {
            const string TABLE_NAME = @"TABLE_NAME";

            var ordinal = reader.GetOrdinal(TABLE_NAME);
            var name = reader.GetString(ordinal);

            return name;
        }

        private static BasicCity ReadCityFromDataReader (DbDataReader reader)
        {
            int cityId = reader.GetInt32(0);
            int countryId = reader.GetInt32(1);
            string cityName = reader.GetString(2);
            int geographyId = reader.GetInt32(3);

            return new BasicCity(cityId, cityName, countryId, geographyId);
        }

        private BasicOutboundInvoiceItem ReadOutboundInvoiceItemFromDataReader (DbDataReader reader)
        {
            int outboundInvoiceItemId = reader.GetInt32(0);
            int outboundInvoiceId = reader.GetInt32(1);
            string description = reader.GetString(2);
            Int64 amountCents = reader.GetInt64(3);

            return new BasicOutboundInvoiceItem(outboundInvoiceItemId, outboundInvoiceId, description, amountCents);
        }

        private BasicPWEvent ReadPWEventFromDataReader (DbDataReader reader)
        {
            int eventId = reader.GetInt32(0);
            EventType eventType = (EventType)Enum.Parse(typeof(EventType), reader.GetString(1));
            EventSource eventSource = (EventSource)Enum.Parse(typeof(EventSource), reader.GetString(2));
            int actingPersonId = reader.GetInt32(3);
            int affectedPersonId = reader.GetInt32(4);
            DateTime eventDateTime = reader.GetDateTime(5);
            DateTime processedDateTime = reader.GetDateTime(6);
            bool open = reader.GetBoolean(7);
            int organizationId = reader.GetInt32(8);
            int geographyId = reader.GetInt32(9);
            int parameterInt = reader.GetInt32(10);
            string parameterText = reader.GetString(11);

            return new BasicPWEvent(eventId, eventDateTime, open, processedDateTime, eventType, eventSource, actingPersonId,
                affectedPersonId, organizationId, geographyId, parameterInt, parameterText);
        }