Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Make the DbType value of (-1) a constant in the parameter class. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
30d638f582ec808e58ae17c096370205 |
| User & Date: | mistachkin 2015-03-26 20:20:25 |
Context
|
2015-03-26
| ||
| 20:38 | When creating a parameter associated with a specific command, keep track of that command. check-in: 64d7e6903e user: mistachkin tags: trunk | |
| 20:20 | Make the DbType value of (-1) a constant in the parameter class. check-in: 30d638f582 user: mistachkin tags: trunk | |
| 20:15 | Remove superfluous conversions between int and DbType. check-in: 69ed1c6104 user: mistachkin tags: trunk | |
Changes
Changes to System.Data.SQLite/SQLiteParameter.cs.
13 14 15 16 17 18 19 20 21 22 23 24 25 26 .. 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 ... 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 ... 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 ... 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 |
using System.ComponentModel;
/// <summary>
/// SQLite implementation of DbParameter.
/// </summary>
public sealed class SQLiteParameter : DbParameter, ICloneable
{
/// <summary>
/// The data type of the parameter
/// </summary>
internal DbType _dbType;
/// <summary>
/// The version information for mapping the parameter
/// </summary>
................................................................................
private bool _nullable;
private bool _nullMapping;
/// <summary>
/// Default constructor
/// </summary>
public SQLiteParameter()
: this(null, (DbType)(-1), 0, null, DataRowVersion.Current)
{
}
/// <summary>
/// Constructs a named parameter given the specified parameter name
/// </summary>
/// <param name="parameterName">The parameter name</param>
public SQLiteParameter(string parameterName)
: this(parameterName, (DbType)(-1), 0, null, DataRowVersion.Current)
{
}
/// <summary>
/// Constructs a named parameter given the specified parameter name and initial value
/// </summary>
/// <param name="parameterName">The parameter name</param>
/// <param name="value">The initial value of the parameter</param>
public SQLiteParameter(string parameterName, object value)
: this(parameterName, (DbType)(-1), 0, null, DataRowVersion.Current)
{
Value = value;
}
/// <summary>
/// Constructs a named parameter of the specified type
/// </summary>
................................................................................
[DbProviderSpecificTypeProperty(true)]
[RefreshProperties(RefreshProperties.All)]
#endif
public override DbType DbType
{
get
{
if (_dbType == (DbType)-1)
{
if (_objValue != null && _objValue != DBNull.Value)
{
return SQLiteConvert.TypeToDbType(_objValue.GetType());
}
return DbType.String; // Unassigned default value is String
}
................................................................................
}
/// <summary>
/// Resets the DbType of the parameter so it can be inferred from the value
/// </summary>
public override void ResetDbType()
{
_dbType = (DbType)-1;
}
/// <summary>
/// Returns the size of the parameter
/// </summary>
#if !PLATFORM_COMPACTFRAMEWORK
[DefaultValue((int)0)]
................................................................................
get
{
return _objValue;
}
set
{
_objValue = value;
if (_dbType == (DbType)-1 && _objValue != null && _objValue != DBNull.Value) // If the DbType has never been assigned, try to glean one from the value's datatype
_dbType = SQLiteConvert.TypeToDbType(_objValue.GetType());
}
}
/// <summary>
/// Clones a parameter
/// </summary>
|
> > > > > | | | | | | |
13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 .. 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 ... 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 ... 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 ... 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 |
using System.ComponentModel;
/// <summary>
/// SQLite implementation of DbParameter.
/// </summary>
public sealed class SQLiteParameter : DbParameter, ICloneable
{
/// <summary>
/// This value represents an "unknown" <see cref="DbType" />.
/// </summary>
private const DbType UnknownDbType = (DbType)(-1);
/// <summary>
/// The data type of the parameter
/// </summary>
internal DbType _dbType;
/// <summary>
/// The version information for mapping the parameter
/// </summary>
................................................................................
private bool _nullable;
private bool _nullMapping;
/// <summary>
/// Default constructor
/// </summary>
public SQLiteParameter()
: this(null, UnknownDbType, 0, null, DataRowVersion.Current)
{
}
/// <summary>
/// Constructs a named parameter given the specified parameter name
/// </summary>
/// <param name="parameterName">The parameter name</param>
public SQLiteParameter(string parameterName)
: this(parameterName, UnknownDbType, 0, null, DataRowVersion.Current)
{
}
/// <summary>
/// Constructs a named parameter given the specified parameter name and initial value
/// </summary>
/// <param name="parameterName">The parameter name</param>
/// <param name="value">The initial value of the parameter</param>
public SQLiteParameter(string parameterName, object value)
: this(parameterName, UnknownDbType, 0, null, DataRowVersion.Current)
{
Value = value;
}
/// <summary>
/// Constructs a named parameter of the specified type
/// </summary>
................................................................................
[DbProviderSpecificTypeProperty(true)]
[RefreshProperties(RefreshProperties.All)]
#endif
public override DbType DbType
{
get
{
if (_dbType == UnknownDbType)
{
if (_objValue != null && _objValue != DBNull.Value)
{
return SQLiteConvert.TypeToDbType(_objValue.GetType());
}
return DbType.String; // Unassigned default value is String
}
................................................................................
}
/// <summary>
/// Resets the DbType of the parameter so it can be inferred from the value
/// </summary>
public override void ResetDbType()
{
_dbType = UnknownDbType;
}
/// <summary>
/// Returns the size of the parameter
/// </summary>
#if !PLATFORM_COMPACTFRAMEWORK
[DefaultValue((int)0)]
................................................................................
get
{
return _objValue;
}
set
{
_objValue = value;
if (_dbType == UnknownDbType && _objValue != null && _objValue != DBNull.Value) // If the DbType has never been assigned, try to glean one from the value's datatype
_dbType = SQLiteConvert.TypeToDbType(_objValue.GetType());
}
}
/// <summary>
/// Clones a parameter
/// </summary>
|