/// <summary> /// Sets the character. /// </summary> /// <param name="record">The record.</param> /// <param name="fieldName">Name of the field.</param> /// <param name="value">The value.</param> public static void SetChar(this SqlDataRecord record, string fieldName, char?value) { int ordinal = GetOrdinal(record, fieldName); if (value.HasValue) { record.SetChar(ordinal, value.Value); } }
void SetValue(SqlDataRecord record, int position, Type type, object value) { switch (type.Name) { case "Int16": record.SetInt16(position, (short)value); break; case "Int32": record.SetInt32(position, (int)value); break; case "Int64": record.SetInt64(position, (long)value); break; case "Boolean": record.SetBoolean(position, (bool)value); break; case "Byte": record.SetByte(position, (byte)value); break; case "Bytes[]": record.SetBytes(position, 0, (byte[])value, 0, ((byte[])value).Length); break; case "Char": record.SetChar(position, (char)value); break; case "Char[]": record.SetChars(position, 0, (char[])value, 0, ((char[])value).Length); break; case "DateTime": record.SetDateTime(position, (DateTime)value); break; case "Decimal": record.SetDecimal(position, (decimal)value); break; case "Double": record.SetDouble(position, (double)value); break; case "Guid": record.SetGuid(position, (Guid)value); break; case "String": record.SetSqlString(position, (string)value); break; default: record.SetValue(position, value); break; } }