• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

C# Common.DbDataReader类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了C#中System.Data.Common.DbDataReader的典型用法代码示例。如果您正苦于以下问题:C# DbDataReader类的具体用法?C# DbDataReader怎么用?C# DbDataReader使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



DbDataReader类属于System.Data.Common命名空间,在下文中一共展示了DbDataReader类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: Summoner

        public Summoner(DbDataReader dataReader)
        {
            Reader reader = new Reader(dataReader);

            Id = reader.Integer();

            Region = reader.String().ToRegionType();

            AccountId = reader.Integer();
            SummonerId = reader.Integer();

            SummonerName = reader.String();
            InternalName = reader.String();

            SummonerLevel = reader.Integer();
            ProfileIcon = reader.Integer();

            UpdateAutomatically = reader.Boolean();

            TimeCreated = reader.Time();
            TimeUpdated = reader.Time();

            reader.SanityCheck(Fields);

            Ratings = new List<SummonerRating>();
            RatingDictionary = new Dictionary<MapType, Dictionary<GameModeType, SummonerRating>>();
            RankedStatistics = new List<SummonerRankedStatistics>();
        }
开发者ID:nolanlum,项目名称:MyRiotControl,代码行数:28,代码来源:Summoner.cs


示例2: GlimpseDbDataReader

 public GlimpseDbDataReader(DbDataReader dataReader, DbCommand command, Guid connectionId, Guid commandId)
 {
     InnerDataReader = dataReader;
     InnerCommand = command;        
     ConnectionId = connectionId;
     CommandId = commandId; 
 }
开发者ID:GitObjects,项目名称:Glimpse,代码行数:7,代码来源:GlimpseDbDataReader.cs


示例3: NewsSubscriber

 public NewsSubscriber(DbDataReader r)
 {
     this.ID = Convert.ToInt32(r["ID"]);
     this.Name = Convert.ToString(r["Name"]);
     this.Email = Convert.ToString(r["Email"]);
     this.DateCreated = Convert.ToDateTime(r["DateCreated"]);
 }
开发者ID:trifonov-mikhail,项目名称:Site1,代码行数:7,代码来源:NewsSubscriber.cs


示例4: Create

        /// <summary>
        ///     This API supports the Entity Framework Core infrastructure and is not intended to be used 
        ///     directly from your code. This API may change or be removed in future releases.
        /// </summary>
        public virtual ValueBuffer Create(DbDataReader dataReader)
        {
            Debug.Assert(dataReader != null); // hot path

            var fieldCount = dataReader.FieldCount;

            if (fieldCount == 0)
            {
                return ValueBuffer.Empty;
            }

            var values = new object[fieldCount];

            dataReader.GetValues(values);

            _processValuesAction?.Invoke(values);

            for (var i = 0; i < fieldCount; i++)
            {
                if (ReferenceEquals(values[i], DBNull.Value))
                {
                    values[i] = null;
                }
            }

            return new ValueBuffer(values);
        }
开发者ID:RickyLin,项目名称:EntityFramework,代码行数:31,代码来源:UntypedRelationalValueBufferFactory.cs


示例5: DataReaderInspectorDataReader

 public DataReaderInspectorDataReader(DbDataReader wrappedDataReader, IResultSetComposer composer)
 {
     this.wrappedDataReader = wrappedDataReader;
     this.composer = composer;
     this.commitNext = false;
     this.needCommit = false;
 }
开发者ID:CodingGorilla,项目名称:effort,代码行数:7,代码来源:DataReaderInspectorDataReader.cs


示例6: Print

 public static void Print(string sql, DbDataReader reader)
 {
     log.Info("Results of [" + sql + "]");
     string results = "\n";
     if (reader.HasRows)
     {
         for (int j = 0; j < reader.FieldCount; j++)
         {
             results += reader.GetName(j);
             if (j < reader.FieldCount - 1)
             {
                 results += "|";
             }
         }
         results += "\n";
         while (reader.Read())
         {
             for (int i = 0; i < reader.FieldCount; i++)
             {
                 results += reader.GetValue(i);
                 if (i < reader.FieldCount - 1)
                 {
                     results += "|";
                 }
             }
             results += "\n";
         }
         results = results.Substring(0, results.Length - 1);
         log.Info(results);
     }
 }
开发者ID:cperler,项目名称:FT_Processing,代码行数:31,代码来源:Program.cs


示例7: DynamicEntityValue

 public DynamicEntityValue(DbDataReader reader)
 {
     for(int i = 0; i < reader.FieldCount; i++)
     {
         this._nameValues.Add(reader.GetName(i), reader.GetValue(i));
     }
 }
开发者ID:glorylee,项目名称:Aoite,代码行数:7,代码来源:DynamicEntityValue.cs


示例8: ReadDouble

        public double? ReadDouble(DbDataReader reader, int index)
        {
            double d = double.NaN;

            if (reader.IsDBNull(index))
                return 0;

            Object obj = reader.GetValue(index);
            if (obj.GetType() == typeof(Decimal))
            {
                d = Decimal.ToDouble((Decimal)obj);
            }
            else if (obj.GetType() == typeof(double))
            {
                d = (double)obj;
            }
            else if (obj.GetType() == typeof(float))
            {
                d = (float)obj;
            }
            else if (obj.GetType() == typeof(string))
            {
                d = double.Parse((string)obj);
            }
            else
                return null;
            return d;
        }
开发者ID:iS3-Project,项目名称:iS3,代码行数:28,代码来源:DbDataLoader.cs


示例9: ReadOutboundInvoiceFromDataReader

        private BasicOutboundInvoice ReadOutboundInvoiceFromDataReader(DbDataReader reader)
        {
            int outboundInvoiceId = reader.GetInt32(0);
            string customerName = reader.GetString(1);
            string invoiceAddressPaper = reader.GetString(2);
            string invoiceAddressMail = reader.GetString(3);
            int currencyId = reader.GetInt32(4);
            // double amount = reader.GetDouble(5);
            int organizationId = reader.GetInt32(6);
            int budgetId = reader.GetInt32(7);
            DateTime createdDateTime = reader.GetDateTime(8);
            int createdByPersonId = reader.GetInt32(9);
            DateTime dueDate = reader.GetDateTime(10);
            int reminderCount = reader.GetInt32(11);
            string reference = reader.GetString(12);
            bool domestic = reader.GetBoolean(13);
            bool open = reader.GetBoolean(14);
            bool sent = reader.GetBoolean(15);
            string securityCode = reader.GetString(16);
            string theirReference = reader.GetString(17);

            return new BasicOutboundInvoice(outboundInvoiceId, customerName, invoiceAddressPaper, invoiceAddressMail,
                                            currencyId, organizationId, budgetId, createdDateTime,
                                            createdByPersonId, dueDate, reminderCount, reference, domestic, open, sent, securityCode, theirReference);
        }
开发者ID:SwarmCorp,项目名称:Swarmops,代码行数:25,代码来源:Database-OutboundInvoices.cs


示例10: MapRow

		private static void MapRow(DbDataReader dr, int numberOfColumns, ResultSet table) {
			var row = new object[numberOfColumns];
			for (int i = 0; i < numberOfColumns; i++) {
				row[i] = (DBNull.Value.Equals(dr[i])) ? null : dr[i];
			}
			table.AddRow(row);
		}
开发者ID:SharpTools,项目名称:sharpdata,代码行数:7,代码来源:DataReaderToResultSetMapper.cs


示例11: GetColumnNames

		private static string[] GetColumnNames(DbDataReader dr, int numberOfColumns) {
			var colNames = new List<string>();
			for (int i = 0; i < numberOfColumns; i++) {
				colNames.Add(dr.GetName(i));
			}
			return colNames.ToArray();
		}
开发者ID:SharpTools,项目名称:sharpdata,代码行数:7,代码来源:DataReaderToResultSetMapper.cs


示例12: Map

        public override object Map(DbDataReader dataReader, RowMapperContext context)
        {
            if (context.Instance == null)
            {
                context.Instance = context.PocoData.CreateObject(dataReader);
                if (context.Instance == null)
                    throw new Exception(string.Format("Cannot create POCO '{0}'. It may have no parameterless constructor or be an interface or abstract class without a Mapper factory.", context.Type.FullName));
            }
            else
            {
                _mappingOntoExistingInstance = true;
            }

            object[] values = new object[dataReader.FieldCount];
            dataReader.GetValues(values);
            _mapPlan(dataReader, values, context.Instance);

            var result = context.Instance as IOnLoaded;
            if (result != null)
            {
                result.OnLoaded();
            }

            return context.Instance;
        }
开发者ID:schotime,项目名称:NPoco,代码行数:25,代码来源:PropertyMapper.cs


示例13: GetSqlValue

 public static string GetSqlValue(DbDataReader reader, int column, string dateTimePattern = "")
 {
     object val = reader[column];
     var s = string.Empty;
     if (val == DBNull.Value) {
         s = "NULL";
     }
     else {
         if (val is DateTime) {
             if (string.IsNullOrEmpty(dateTimePattern)) {
                 dateTimePattern = "yyyy/MM/dd";
             }
             if (((DateTime)val).Year == 1900) {
                 s = "NULL";
             }
             else {
                 s = "'" + ((DateTime)val).ToString(dateTimePattern) + "'";
             }
         }
         else if (val is double) {
             s = Math.Round((double)val, 4).ToString();
         }
         else {
             s = "'" + val.ToString().Trim().Replace("'", "''") + "'";
         }
     }
     return s;
 }
开发者ID:weihongji,项目名称:YuLin,代码行数:28,代码来源:DataUtility.cs


示例14: ReadHeaders

 Dictionary<string, string> ReadHeaders(DbDataReader reader)
 {
     using (var textReader = reader.GetTextReader(4))
     {
         return Serializer.Deserialize<Dictionary<string, string>>(textReader);
     }
 }
开发者ID:SimonCropp,项目名称:NsbSqlPersistence,代码行数:7,代码来源:TimeoutPersister.cs


示例15: Create

        /// <summary>
        /// Assigns its properties with a record from a database.
        /// </summary>
        /// <param name="oDataReader">Data reader that holds the elements to populate itself with. Uses the abstract class <see cref="DbDataReader"/> to work with data readers for different DBMSs.</param>
        public void Create(DbDataReader oDataReader)
        {
            int iId;

            if (Int32.TryParse(oDataReader["id"].ToString(), out iId))
            {
                Id = iId;
            }
            else
            {
                throw new InvalidCastException("Error converting id to an integer");
            }

            Name = oDataReader["name"].ToString();

            if (Int32.TryParse(oDataReader["locality_id"].ToString(), out iId))
            {
                LocalityId = iId;
            }
            else
            {
                throw new InvalidCastException("Error converting locality id to an integer");
            }

            if (Int32.TryParse(oDataReader["polling_location_id"].ToString(), out iId))
            {
                PollingLocationId = iId;
            }
            else
            {
                throw new InvalidCastException("Error converting polling location id to an integer");
            }
        }
开发者ID:votinginfoproject,项目名称:mongoose,代码行数:37,代码来源:Precinct.cs


示例16: CreateValueBuffer

        public virtual ValueBuffer CreateValueBuffer(DbDataReader dataReader)
        {
            Debug.Assert(dataReader != null); // hot path
            Debug.Assert(dataReader.FieldCount >= _indexMap.Count);

            if (_indexMap.Count == 0)
            {
                return ValueBuffer.Empty;
            }

            var values = new object[dataReader.FieldCount];

            dataReader.GetValues(values);

            var remappedValues = new object[_indexMap.Count];

            for (var i = 0; i < _indexMap.Count; i++)
            {
                remappedValues[i]
                    = ReferenceEquals(values[_indexMap[i]], DBNull.Value)
                        ? null
                        : values[_indexMap[i]];
            }

            return new ValueBuffer(remappedValues);
        }
开发者ID:aishaloshik,项目名称:EntityFramework,代码行数:26,代码来源:RemappingUntypedValueBufferFactory.cs


示例17: Fill

 private void Fill(DbDataReader reader, Call call)
 {
     call.Start = DateUtils.ConvertFromLinuxStamp(reader.GetValueObject<long>("begin_timestamp"));
     call.Duration = TimeSpan.FromSeconds(reader.GetValueObject<long>("duration"));
     call.Host_Identity = reader.GetObject<string>("host_identity");
     call.Id = reader.GetValueObject<long>("id");
 }
开发者ID:ggiraudon,项目名称:skype-history-reporter,代码行数:7,代码来源:SqliteCallRepository.cs


示例18: Postprocess

        public void Postprocess(DbDataReader reader, IList<Exception> exceptions)
        {
            reader.Read();
            var values = reader.GetFieldValue<int[]>(0);

            applyDataFromSproc(values);
        }
开发者ID:danielmarbach,项目名称:marten,代码行数:7,代码来源:EventStreamVersioningCallback.cs


示例19: LoadDb

        public static DbTable LoadDb(DbDataReader reader)
        {
            if (!reader.Read()) {
                return null;
            }

            var tbl = new DbTable((string)reader["TABLE_NAME"]);

            var firstColumn = new DbColumn(
                (string)reader["COLUMN_NAME"],
                (string)reader["DATA_TYPE"]
            );
            tbl.Columns = new List<DbColumn>() { firstColumn };

            while (reader.Read()) {
                if (tbl.Name != (string)reader["TABLE_NAME"]) {
                    break;
                }
                tbl.Columns.Add(new DbColumn(
                    (string)reader["COLUMN_NAME"],
                    (string)reader["DATA_TYPE"]
                ));

            }
            return tbl;
        }
开发者ID:GrowingData,项目名称:Mung,代码行数:26,代码来源:DbTable.cs


示例20: VisitedSystemsClass

        public VisitedSystemsClass(DbDataReader reader)
        {
            id = (long)reader["id"];
            Name = (string)reader["Name"];
            Time = (DateTime)reader["Time"];
            Commander = (int)(long)reader["Commander"];
            Source = (long)reader["Source"];
            Unit = (string)reader["Unit"];
            EDSM_sync = (bool)reader["edsm_sync"];
            MapColour = (int)(long)reader["Map_colour"];

            if (reader["X"] == DBNull.Value)
            {
                X = double.NaN;
                Y = double.NaN;
                Z = double.NaN;
            }
            else
            {
                X = (double)reader["X"];
                Y = (double)reader["Y"];
                Z = (double)reader["Z"];
            }

            if (reader["id_edsm_assigned"] != DBNull.Value)
            {
                id_edsm_assigned = (long)reader["id_edsm_assigned"];
            }
        }
开发者ID:mwerle,项目名称:EDDiscovery,代码行数:29,代码来源:VisitedSystemsClass.cs



注:本文中的System.Data.Common.DbDataReader类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# Common.DbParameter类代码示例发布时间:2022-05-26
下一篇:
C# Common.DbDataAdapter类代码示例发布时间:2022-05-26
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap