本文整理汇总了C#中System.Data.Common.DbDataReader.GetByte方法的典型用法代码示例。如果您正苦于以下问题:C# DbDataReader.GetByte方法的具体用法?C# DbDataReader.GetByte怎么用?C# DbDataReader.GetByte使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Common.DbDataReader
的用法示例。
在下文中一共展示了DbDataReader.GetByte方法的12个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: WorkoutPlan
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);
}
示例2: GetByte
public static byte? GetByte(DbDataReader reader, int index)
{
if (reader.IsDBNull(index))
return null;
else
return reader.GetByte(index);
}
示例3: FillCompatibleSettersFromReader
// Copy multiple fields from reader to SmiTypedGetterSetter
// Supports V200 code path, without damaging backward compat for V100 code.
// Main differences are supporting DbDataReader, and for binary, character, decimal and Udt types.
// Assumes caller enforces that reader and setter metadata are compatible
internal static void FillCompatibleSettersFromReader(SmiEventSink_Default sink, SmiTypedGetterSetter setters, IList<SmiExtendedMetaData> metaData, DbDataReader reader) {
for (int i = 0; i < metaData.Count; i++) {
if (reader.IsDBNull(i)) {
ValueUtilsSmi.SetDBNull_Unchecked(sink, setters, i);
}
else {
switch (metaData[i].SqlDbType) {
case SqlDbType.BigInt:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Int64));
SetInt64_Unchecked(sink, setters, i, reader.GetInt64(i));
break;
case SqlDbType.Binary:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray));
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.Bit:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Boolean));
SetBoolean_Unchecked(sink, setters, i, reader.GetBoolean(i));
break;
case SqlDbType.Char:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.CharArray));
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.DateTime:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTime));
SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i));
break;
case SqlDbType.Decimal: { // block to scope sqlReader local to avoid conflicts
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlDecimal));
// Support full fidelity for SqlDataReader
SqlDataReader sqlReader = reader as SqlDataReader;
if (null != sqlReader) {
SetSqlDecimal_Unchecked(sink, setters, i, sqlReader.GetSqlDecimal(i));
}
else {
SetSqlDecimal_Unchecked(sink, setters, i, new SqlDecimal(reader.GetDecimal(i)));
}
}
break;
case SqlDbType.Float:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Double));
SetDouble_Unchecked(sink, setters, i, reader.GetDouble(i));
break;
case SqlDbType.Image:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray));
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.Int:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Int32));
SetInt32_Unchecked(sink, setters, i, reader.GetInt32(i));
break;
case SqlDbType.Money:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlMoney));
SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i)));
break;
case SqlDbType.NChar:
case SqlDbType.NText:
case SqlDbType.NVarChar:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.CharArray));
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.Real:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Single));
SetSingle_Unchecked(sink, setters, i, reader.GetFloat(i));
break;
case SqlDbType.UniqueIdentifier:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Guid));
SetGuid_Unchecked(sink, setters, i, reader.GetGuid(i));
break;
case SqlDbType.SmallDateTime:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTime));
SetDateTime_Checked(sink, setters, i,metaData[i], reader.GetDateTime(i));
break;
case SqlDbType.SmallInt:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Int16));
SetInt16_Unchecked(sink, setters, i, reader.GetInt16(i));
break;
case SqlDbType.SmallMoney:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlMoney));
SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i)));
break;
case SqlDbType.Text:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.CharArray));
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.Timestamp:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray));
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
break;
case SqlDbType.TinyInt:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Byte));
SetByte_Unchecked(sink, setters, i, reader.GetByte(i));
break;
case SqlDbType.VarBinary:
Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray));
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
//.........这里部分代码省略.........
示例4: Option
/// <summary>
/// Конструктор класса Option
/// </summary>
public Option(DbDataReader reader)
{
this._id = reader.GetByte(0);
this._name = reader.GetString(1);
this._value = reader.GetString(2);
}
示例5: WorkType
/// <summary>
/// Конструктор класса WorkType
/// </summary>
public WorkType(DbDataReader reader)
{
this._id = reader.GetInt16(0);
this._sportTypeId = reader.GetByte(1);
this._userId = reader.GetInt64(2);
this._count = reader.GetInt32(3);
this._value = reader.GetString(4);
}
示例6: Workout
/// <summary>
/// Конструктор класса Workout
/// </summary>
public Workout(DbDataReader reader)
{
this._id = reader.GetValue(0).ToString() == "" ? (long)0 : reader.GetInt64(0);
this._date = reader.GetValue(1).ToString() == "" ? (long)0 : reader.GetInt64(1);
this._timeBegin = reader.GetValue(2).ToString() == "" ? (long)0 : reader.GetInt64(2);
this._timeEnd = reader.GetValue(3).ToString() == "" ? (long)0 : reader.GetInt64(3);
this._warmUp = reader.GetValue(4).ToString() == "" ? (byte)0 : reader.GetByte(4);
this._musclesGroupId = reader.GetValue(5).ToString() == "" ? (Int16)0 : reader.GetInt16(5);
this._workoutPlanId = reader.GetValue(6).ToString() == "" ? (long)0 : reader.GetInt64(6);
this._workoutTypeId = reader.GetValue(7).ToString() == "" ? (Int16)0 : reader.GetInt16(7);
this._athleteId = reader.GetValue(8).ToString() == "" ? (long)0 : reader.GetInt64(8);
this._createDate = reader.GetValue(9).ToString() == "" ? (long)0 : reader.GetInt64(9);
this._workoutPlanTypeId = reader.GetValue(10).ToString() == "" ? (Int16)0 : reader.GetInt16(10);
}
示例7: ReadInternal
protected override object ReadInternal(DbDataReader reader, int ordinal, SqlRandomTableColumn columnInfo, Type asType)
{
ValidateReadType(typeof(byte), asType);
if (reader.IsDBNull(ordinal))
return DBNull.Value;
return reader.GetByte(ordinal);
}
示例8: FillCompatibleSettersFromReader
//.........这里部分代码省略.........
}
case SqlDbType.UniqueIdentifier:
{
SetGuid_Unchecked(sink, setters, i, reader.GetGuid(i));
continue;
}
case SqlDbType.SmallDateTime:
{
SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i));
continue;
}
case SqlDbType.SmallInt:
{
SetInt16_Unchecked(sink, setters, i, reader.GetInt16(i));
continue;
}
case SqlDbType.SmallMoney:
{
SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i)));
continue;
}
case SqlDbType.Text:
{
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
continue;
}
case SqlDbType.Timestamp:
{
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
continue;
}
case SqlDbType.TinyInt:
{
SetByte_Unchecked(sink, setters, i, reader.GetByte(i));
continue;
}
case SqlDbType.VarBinary:
{
SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0);
continue;
}
case SqlDbType.VarChar:
{
SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0);
continue;
}
case SqlDbType.Variant:
{
SqlDataReader reader4 = reader as SqlDataReader;
if (reader4 == null)
{
goto Label_0311;
}
sqlValue = reader4.GetSqlValue(i);
goto Label_0319;
}
case SqlDbType.Xml:
{
SqlDataReader reader5 = reader as SqlDataReader;
if (reader5 == null)
{
goto Label_02E4;
}
SetSqlXml_Unchecked(sink, setters, i, reader5.GetSqlXml(i));
continue;
}
示例9: SportType
/// <summary>
/// Конструктор класса SportType
/// </summary>
public SportType(DbDataReader reader)
{
this._id = reader.GetByte(0);
this._value = reader.GetString(1);
}
示例10: SportCategory
/// <summary>
/// Конструктор класса SportCategory
/// </summary>
public SportCategory(DbDataReader reader)
{
this._id = reader.GetByte(0);
this._value = reader.GetString(1);
this._shortValue = reader.GetString(2);
}
示例11: CreatePermissionSet
private PermissionSet CreatePermissionSet(DbDataReader reader)
{
var allowBits = 0;
var denyBits = 0;
for (var i = 0; i < 16; i++)
{
var value = (PermissionValue)reader.GetByte(i + 8);
if (value == PermissionValue.Allow)
allowBits |= 1 << i;
else if (value == PermissionValue.Deny)
denyBits |= 1 << i;
}
return new PermissionSet(reader.GetInt32(6), reader.GetByte(7) == 1, allowBits, denyBits);
}
示例12: Athlete
/// <summary>
/// Конструктор класса Athlete
/// </summary>
/// <param name="record"></param>
public Athlete(DbDataReader record)
{
this._id = record.GetInt64(0);
this._sportTypeId = record.GetValue(1).ToString() == "" ? (byte)0 : record.GetByte(1);
this._sportCategoryId = record.GetValue(2).ToString() == "" ? (byte)0 : record.GetByte(2);
this._address = record.GetValue(3).ToString() == "" ? "" : record.GetString(3);
this._place = record.GetValue(4).ToString() == "" ? "" : record.GetString(4);
this._userId = record.GetValue(5).ToString() == "" ? 0 : record.GetInt64(5);
this._createDate = record.GetValue(6).ToString() == "" ? 0 : record.GetInt64(6);
}