本文整理汇总了C#中System.Data.Common.DbDataReader类的典型用法代码示例。如果您正苦于以下问题:C# DbDataReader类的具体用法?C# DbDataReader怎么用?C# DbDataReader使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
DbDataReader类属于System.Data.Common命名空间,在下文中一共展示了DbDataReader类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的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>();
}
示例2: GlimpseDbDataReader
public GlimpseDbDataReader(DbDataReader dataReader, DbCommand command, Guid connectionId, Guid commandId)
{
InnerDataReader = dataReader;
InnerCommand = command;
ConnectionId = connectionId;
CommandId = commandId;
}
示例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"]);
}
示例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);
}
示例5: DataReaderInspectorDataReader
public DataReaderInspectorDataReader(DbDataReader wrappedDataReader, IResultSetComposer composer)
{
this.wrappedDataReader = wrappedDataReader;
this.composer = composer;
this.commitNext = false;
this.needCommit = false;
}
示例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);
}
}
示例7: DynamicEntityValue
public DynamicEntityValue(DbDataReader reader)
{
for(int i = 0; i < reader.FieldCount; i++)
{
this._nameValues.Add(reader.GetName(i), reader.GetValue(i));
}
}
示例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;
}
示例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);
}
示例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);
}
示例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();
}
示例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;
}
示例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;
}
示例14: ReadHeaders
Dictionary<string, string> ReadHeaders(DbDataReader reader)
{
using (var textReader = reader.GetTextReader(4))
{
return Serializer.Deserialize<Dictionary<string, string>>(textReader);
}
}
示例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");
}
}