本文整理汇总了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;未经允许,请勿转载。 |
请发表评论