-//
-// Mono.Data.Sqlite.SQLiteParameter.cs
-//
-// Author(s):
-// Robert Simpson (robert@blackcastlesoft.com)
-//
-// Adapted and modified for the Mono Project by
-// Marek Habersack (grendello@gmail.com)
-//
-//
-// Copyright (C) 2006 Novell, Inc (http://www.novell.com)
-// Copyright (C) 2007 Marek Habersack
-//
-// Permission is hereby granted, free of charge, to any person obtaining
-// a copy of this software and associated documentation files (the
-// "Software"), to deal in the Software without restriction, including
-// without limitation the rights to use, copy, modify, merge, publish,
-// distribute, sublicense, and/or sell copies of the Software, and to
-// permit persons to whom the Software is furnished to do so, subject to
-// the following conditions:
-//
-// The above copyright notice and this permission notice shall be
-// included in all copies or substantial portions of the Software.
-//
-// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
-// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
-// MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
-// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
-// LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
-// OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
-// WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
-//
-
-/********************************************************
- * ADO.NET 2.0 Data Provider for Sqlite Version 3.X
- * Written by Robert Simpson (robert@blackcastlesoft.com)
- *
- * Released to the public domain, use at your own risk!
- ********************************************************/
-#if NET_2_0
-namespace Mono.Data.Sqlite
-{
- using System;
- using System.Data;
- using System.Data.Common;
- using System.ComponentModel;
-
- /// <summary>
- /// Sqlite implementation of DbParameter.
- /// </summary>
- public sealed class SqliteParameter : DbParameter, ICloneable
- {
- /// <summary>
- /// The data type of the parameter
- /// </summary>
- internal int _dbType;
- /// <summary>
- /// The version information for mapping the parameter
- /// </summary>
- private DataRowVersion _rowVersion;
- /// <summary>
- /// The value of the data in the parameter
- /// </summary>
- private Object _objValue;
- /// <summary>
- /// The source column for the parameter
- /// </summary>
- private string _sourceColumn;
- /// <summary>
- /// The column name
- /// </summary>
- private string _parameterName;
- /// <summary>
- /// The data size, unused by Sqlite
- /// </summary>
- private int _dataSize;
-
- 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>
- /// <param name="parameterName">The parameter name</param>
- /// <param name="dbType">The datatype of the parameter</param>
- public SqliteParameter(string parameterName, DbType dbType)
- : this(parameterName, dbType, 0, null, DataRowVersion.Current)
- {
- }
-
- /// <summary>
- /// Constructs a named parameter of the specified type and source column reference
- /// </summary>
- /// <param name="parameterName">The parameter name</param>
- /// <param name="dbType">The data type</param>
- /// <param name="sourceColumn">The source column</param>
- public SqliteParameter(string parameterName, DbType dbType, string sourceColumn)
- : this(parameterName, dbType, 0, sourceColumn, DataRowVersion.Current)
- {
- }
-
- /// <summary>
- /// Constructs a named parameter of the specified type, source column and row version
- /// </summary>
- /// <param name="parameterName">The parameter name</param>
- /// <param name="dbType">The data type</param>
- /// <param name="sourceColumn">The source column</param>
- /// <param name="rowVersion">The row version information</param>
- public SqliteParameter(string parameterName, DbType dbType, string sourceColumn, DataRowVersion rowVersion)
- : this(parameterName, dbType, 0, sourceColumn, rowVersion)
- {
- }
-
- /// <summary>
- /// Constructs an unnamed parameter of the specified data type
- /// </summary>
- /// <param name="dbType">The datatype of the parameter</param>
- public SqliteParameter(DbType dbType)
- : this(null, dbType, 0, null, DataRowVersion.Current)
- {
- }
-
- /// <summary>
- /// Constructs an unnamed parameter of the specified data type and sets the initial value
- /// </summary>
- /// <param name="dbType">The datatype of the parameter</param>
- /// <param name="value">The initial value of the parameter</param>
- public SqliteParameter(DbType dbType, object value)
- : this(null, dbType, 0, null, DataRowVersion.Current)
- {
- Value = value;
- }
-
- /// <summary>
- /// Constructs an unnamed parameter of the specified data type and source column
- /// </summary>
- /// <param name="dbType">The datatype of the parameter</param>
- /// <param name="sourceColumn">The source column</param>
- public SqliteParameter(DbType dbType, string sourceColumn)
- : this(null, dbType, 0, sourceColumn, DataRowVersion.Current)
- {
- }
-
- /// <summary>
- /// Constructs an unnamed parameter of the specified data type, source column and row version
- /// </summary>
- /// <param name="dbType">The data type</param>
- /// <param name="sourceColumn">The source column</param>
- /// <param name="rowVersion">The row version information</param>
- public SqliteParameter(DbType dbType, string sourceColumn, DataRowVersion rowVersion)
- : this(null, dbType, 0, sourceColumn, rowVersion)
- {
- }
-
- /// <summary>
- /// Constructs a named parameter of the specified type and size
- /// </summary>
- /// <param name="parameterName">The parameter name</param>
- /// <param name="parameterType">The data type</param>
- /// <param name="parameterSize">The size of the parameter</param>
- public SqliteParameter(string parameterName, DbType parameterType, int parameterSize)
- : this(parameterName, parameterType, parameterSize, null, DataRowVersion.Current)
- {
- }
-
- /// <summary>
- /// Constructs a named parameter of the specified type, size and source column
- /// </summary>
- /// <param name="parameterName">The name of the parameter</param>
- /// <param name="parameterType">The data type</param>
- /// <param name="parameterSize">The size of the parameter</param>
- /// <param name="sourceColumn">The source column</param>
- public SqliteParameter(string parameterName, DbType parameterType, int parameterSize, string sourceColumn)
- : this(parameterName, parameterType, parameterSize, sourceColumn, DataRowVersion.Current)
- {
- }
-
- /// <summary>
- /// Constructs a named parameter of the specified type, size, source column and row version
- /// </summary>
- /// <param name="parameterName">The name of the parameter</param>
- /// <param name="parameterType">The data type</param>
- /// <param name="parameterSize">The size of the parameter</param>
- /// <param name="sourceColumn">The source column</param>
- /// <param name="rowVersion">The row version information</param>
- public SqliteParameter(string parameterName, DbType parameterType, int parameterSize, string sourceColumn, DataRowVersion rowVersion)
- {
- _parameterName = parameterName;
- _dbType = (int)parameterType;
- _sourceColumn = sourceColumn;
- _rowVersion = rowVersion;
- _objValue = null;
- _dataSize = parameterSize;
- _nullMapping = false;
- _nullable = true;
- }
-
- private SqliteParameter(SqliteParameter source)
- : this(source.ParameterName, (DbType)source._dbType, 0, source.Direction, source.IsNullable, 0, 0, source.SourceColumn, source.SourceVersion, source.Value)
- {
- _nullMapping = source._nullMapping;
- }
-
- /// <summary>
- /// Constructs a named parameter of the specified type, size, source column and row version
- /// </summary>
- /// <param name="parameterName">The name of the parameter</param>
- /// <param name="parameterType">The data type</param>
- /// <param name="parameterSize">The size of the parameter</param>
- /// <param name="direction">Only input parameters are supported in Sqlite</param>
- /// <param name="isNullable">Ignored</param>
- /// <param name="precision">Ignored</param>
- /// <param name="scale">Ignored</param>
- /// <param name="sourceColumn">The source column</param>
- /// <param name="rowVersion">The row version information</param>
- /// <param name="value">The initial value to assign the parameter</param>
-#if !PLATFORM_COMPACTFRAMEWORK
- [EditorBrowsable(EditorBrowsableState.Advanced)]
-#endif
- public SqliteParameter(string parameterName, DbType parameterType, int parameterSize, ParameterDirection direction, bool isNullable, byte precision, byte scale, string sourceColumn, DataRowVersion rowVersion, object value)
- : this(parameterName, parameterType, parameterSize, sourceColumn, rowVersion)
- {
- Direction = direction;
- IsNullable = isNullable;
- Value = value;
- }
-
- /// <summary>
- /// Constructs a named parameter, yet another flavor
- /// </summary>
- /// <param name="parameterName">The name of the parameter</param>
- /// <param name="parameterType">The data type</param>
- /// <param name="parameterSize">The size of the parameter</param>
- /// <param name="direction">Only input parameters are supported in Sqlite</param>
- /// <param name="precision">Ignored</param>
- /// <param name="scale">Ignored</param>
- /// <param name="sourceColumn">The source column</param>
- /// <param name="rowVersion">The row version information</param>
- /// <param name="sourceColumnNullMapping">Whether or not this parameter is for comparing NULL's</param>
- /// <param name="value">The intial value to assign the parameter</param>
-#if !PLATFORM_COMPACTFRAMEWORK
- [EditorBrowsable(EditorBrowsableState.Advanced)]
-#endif
- public SqliteParameter(string parameterName, DbType parameterType, int parameterSize, ParameterDirection direction, byte precision, byte scale, string sourceColumn, DataRowVersion rowVersion, bool sourceColumnNullMapping, object value)
- : this(parameterName, parameterType, parameterSize, sourceColumn, rowVersion)
- {
- Direction = direction;
- SourceColumnNullMapping = sourceColumnNullMapping;
- Value = value;
- }
-
- /// <summary>
- /// Constructs an unnamed parameter of the specified type and size
- /// </summary>
- /// <param name="parameterType">The data type</param>
- /// <param name="parameterSize">The size of the parameter</param>
- public SqliteParameter(DbType parameterType, int parameterSize)
- : this(null, parameterType, parameterSize, null, DataRowVersion.Current)
- {
- }
-
- /// <summary>
- /// Constructs an unnamed parameter of the specified type, size, and source column
- /// </summary>
- /// <param name="parameterType">The data type</param>
- /// <param name="parameterSize">The size of the parameter</param>
- /// <param name="sourceColumn">The source column</param>
- public SqliteParameter(DbType parameterType, int parameterSize, string sourceColumn)
- : this(null, parameterType, parameterSize, sourceColumn, DataRowVersion.Current)
- {
- }
-
- /// <summary>
- /// Constructs an unnamed parameter of the specified type, size, source column and row version
- /// </summary>
- /// <param name="parameterType">The data type</param>
- /// <param name="parameterSize">The size of the parameter</param>
- /// <param name="sourceColumn">The source column</param>
- /// <param name="rowVersion">The row version information</param>
- public SqliteParameter(DbType parameterType, int parameterSize, string sourceColumn, DataRowVersion rowVersion)
- : this(null, parameterType, parameterSize, sourceColumn, rowVersion)
- {
- }
-
- /// <summary>
- /// Whether or not the parameter can contain a null value
- /// </summary>
- public override bool IsNullable
- {
- get
- {
- return _nullable;
- }
- set
- {
- _nullable = value;
- }
- }
-
- /// <summary>
- /// Returns the datatype of the parameter
- /// </summary>
-#if !PLATFORM_COMPACTFRAMEWORK
- [DbProviderSpecificTypeProperty(true)]
- [RefreshProperties(RefreshProperties.All)]
-#endif
- public override DbType DbType
- {
- get
- {
- if (_dbType == -1) return DbType.String; // Unassigned default value is String
- return (DbType)_dbType;
- }
- set
- {
- _dbType = (int)value;
- }
- }
-
- /// <summary>
- /// Supports only input parameters
- /// </summary>
- public override ParameterDirection Direction
- {
- get
- {
- return ParameterDirection.Input;
- }
- set
- {
- if (value != ParameterDirection.Input)
- throw new NotSupportedException();
- }
- }
-
- /// <summary>
- /// Returns the parameter name
- /// </summary>
- public override string ParameterName
- {
- get
- {
- return _parameterName;
- }
- set
- {
- _parameterName = value;
- }
- }
-
- /// <summary>
- /// Not implemented
- /// </summary>
- public override void ResetDbType()
- {
- }
-
- /// <summary>
- /// Returns the size of the parameter
- /// </summary>
-#if !PLATFORM_COMPACTFRAMEWORK
- [DefaultValue((int)0)]
-#endif
- public override int Size
- {
- get
- {
- return _dataSize;
- }
- set
- {
- _dataSize = value;
- }
- }
-
- /// <summary>
- /// Gets/sets the source column
- /// </summary>
- public override string SourceColumn
- {
- get
- {
- return _sourceColumn;
- }
- set
- {
- _sourceColumn = value;
- }
- }
-
- /// <summary>
- /// Used by DbCommandBuilder to determine the mapping for nullable fields
- /// </summary>
- public override bool SourceColumnNullMapping
- {
- get
- {
- return _nullMapping;
- }
- set
- {
- _nullMapping = value;
- }
- }
-
- /// <summary>
- /// Gets and sets the row version
- /// </summary>
- public override DataRowVersion SourceVersion
- {
- get
- {
- return _rowVersion;
- }
- set
- {
- _rowVersion = value;
- }
- }
-
- /// <summary>
- /// Gets and sets the parameter value. If no datatype was specified, the datatype will assume the type from the value given.
- /// </summary>
-#if !PLATFORM_COMPACTFRAMEWORK
- [TypeConverter(typeof(StringConverter)), RefreshProperties(RefreshProperties.All)]
-#endif
- public override object Value
- {
- get
- {
- return _objValue;
- }
- set
- {
- _objValue = value;
- if (_dbType == -1 && _objValue != null && _objValue != DBNull.Value) // If the DbType has never been assigned, try to glean one from the value's datatype
- _dbType = (int)SqliteConvert.TypeToDbType(_objValue.GetType());
- }
- }
-
- /// <summary>
- /// Clones a parameter
- /// </summary>
- /// <returns>A new, unassociated SqliteParameter</returns>
- public object Clone()
- {
- SqliteParameter newparam = new SqliteParameter(this);
-
- return newparam;
- }
- }
-}
-#endif
+/********************************************************\r
+ * ADO.NET 2.0 Data Provider for SQLite Version 3.X\r
+ * Written by Robert Simpson (robert@blackcastlesoft.com)\r
+ * \r
+ * Released to the public domain, use at your own risk!\r
+ ********************************************************/\r
+\r
+namespace Mono.Data.Sqlite\r
+{\r
+ using System;\r
+ using System.Data;\r
+ using System.Data.Common;\r
+ using System.ComponentModel;\r
+\r
+ /// <summary>\r
+ /// SQLite implementation of DbParameter.\r
+ /// </summary>\r
+ public sealed class SqliteParameter : DbParameter, ICloneable\r
+ {\r
+ /// <summary>\r
+ /// The data type of the parameter\r
+ /// </summary>\r
+ internal int _dbType;\r
+ /// <summary>\r
+ /// The version information for mapping the parameter\r
+ /// </summary>\r
+ private DataRowVersion _rowVersion;\r
+ /// <summary>\r
+ /// The value of the data in the parameter\r
+ /// </summary>\r
+ private Object _objValue;\r
+ /// <summary>\r
+ /// The source column for the parameter\r
+ /// </summary>\r
+ private string _sourceColumn;\r
+ /// <summary>\r
+ /// The column name\r
+ /// </summary>\r
+ private string _parameterName;\r
+ /// <summary>\r
+ /// The data size, unused by SQLite\r
+ /// </summary>\r
+ private int _dataSize;\r
+\r
+ private bool _nullable;\r
+ private bool _nullMapping;\r
+\r
+ /// <summary>\r
+ /// Default constructor\r
+ /// </summary>\r
+ public SqliteParameter() \r
+ : this(null, (DbType)(-1), 0, null, DataRowVersion.Current)\r
+ {\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs a named parameter given the specified parameter name\r
+ /// </summary>\r
+ /// <param name="parameterName">The parameter name</param>\r
+ public SqliteParameter(string parameterName)\r
+ : this(parameterName, (DbType)(-1), 0, null, DataRowVersion.Current)\r
+ {\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs a named parameter given the specified parameter name and initial value\r
+ /// </summary>\r
+ /// <param name="parameterName">The parameter name</param>\r
+ /// <param name="value">The initial value of the parameter</param>\r
+ public SqliteParameter(string parameterName, object value)\r
+ : this(parameterName, (DbType)(-1), 0, null, DataRowVersion.Current)\r
+ {\r
+ Value = value;\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs a named parameter of the specified type\r
+ /// </summary>\r
+ /// <param name="parameterName">The parameter name</param>\r
+ /// <param name="dbType">The datatype of the parameter</param>\r
+ public SqliteParameter(string parameterName, DbType dbType)\r
+ : this(parameterName, dbType, 0, null, DataRowVersion.Current)\r
+ {\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs a named parameter of the specified type and source column reference\r
+ /// </summary>\r
+ /// <param name="parameterName">The parameter name</param>\r
+ /// <param name="dbType">The data type</param>\r
+ /// <param name="sourceColumn">The source column</param>\r
+ public SqliteParameter(string parameterName, DbType dbType, string sourceColumn)\r
+ : this(parameterName, dbType, 0, sourceColumn, DataRowVersion.Current)\r
+ {\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs a named parameter of the specified type, source column and row version\r
+ /// </summary>\r
+ /// <param name="parameterName">The parameter name</param>\r
+ /// <param name="dbType">The data type</param>\r
+ /// <param name="sourceColumn">The source column</param>\r
+ /// <param name="rowVersion">The row version information</param>\r
+ public SqliteParameter(string parameterName, DbType dbType, string sourceColumn, DataRowVersion rowVersion)\r
+ : this(parameterName, dbType, 0, sourceColumn, rowVersion)\r
+ {\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs an unnamed parameter of the specified data type\r
+ /// </summary>\r
+ /// <param name="dbType">The datatype of the parameter</param>\r
+ public SqliteParameter(DbType dbType)\r
+ : this(null, dbType, 0, null, DataRowVersion.Current)\r
+ {\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs an unnamed parameter of the specified data type and sets the initial value\r
+ /// </summary>\r
+ /// <param name="dbType">The datatype of the parameter</param>\r
+ /// <param name="value">The initial value of the parameter</param>\r
+ public SqliteParameter(DbType dbType, object value)\r
+ : this(null, dbType, 0, null, DataRowVersion.Current)\r
+ {\r
+ Value = value;\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs an unnamed parameter of the specified data type and source column\r
+ /// </summary>\r
+ /// <param name="dbType">The datatype of the parameter</param>\r
+ /// <param name="sourceColumn">The source column</param>\r
+ public SqliteParameter(DbType dbType, string sourceColumn)\r
+ : this(null, dbType, 0, sourceColumn, DataRowVersion.Current)\r
+ {\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs an unnamed parameter of the specified data type, source column and row version\r
+ /// </summary>\r
+ /// <param name="dbType">The data type</param>\r
+ /// <param name="sourceColumn">The source column</param>\r
+ /// <param name="rowVersion">The row version information</param>\r
+ public SqliteParameter(DbType dbType, string sourceColumn, DataRowVersion rowVersion)\r
+ : this(null, dbType, 0, sourceColumn, rowVersion)\r
+ {\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs a named parameter of the specified type and size\r
+ /// </summary>\r
+ /// <param name="parameterName">The parameter name</param>\r
+ /// <param name="parameterType">The data type</param>\r
+ /// <param name="parameterSize">The size of the parameter</param>\r
+ public SqliteParameter(string parameterName, DbType parameterType, int parameterSize)\r
+ : this(parameterName, parameterType, parameterSize, null, DataRowVersion.Current)\r
+ {\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs a named parameter of the specified type, size and source column\r
+ /// </summary>\r
+ /// <param name="parameterName">The name of the parameter</param>\r
+ /// <param name="parameterType">The data type</param>\r
+ /// <param name="parameterSize">The size of the parameter</param>\r
+ /// <param name="sourceColumn">The source column</param>\r
+ public SqliteParameter(string parameterName, DbType parameterType, int parameterSize, string sourceColumn)\r
+ : this(parameterName, parameterType, parameterSize, sourceColumn, DataRowVersion.Current)\r
+ {\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs a named parameter of the specified type, size, source column and row version\r
+ /// </summary>\r
+ /// <param name="parameterName">The name of the parameter</param>\r
+ /// <param name="parameterType">The data type</param>\r
+ /// <param name="parameterSize">The size of the parameter</param>\r
+ /// <param name="sourceColumn">The source column</param>\r
+ /// <param name="rowVersion">The row version information</param>\r
+ public SqliteParameter(string parameterName, DbType parameterType, int parameterSize, string sourceColumn, DataRowVersion rowVersion) \r
+ {\r
+ _parameterName = parameterName;\r
+ _dbType = (int)parameterType;\r
+ _sourceColumn = sourceColumn;\r
+ _rowVersion = rowVersion;\r
+ _objValue = null;\r
+ _dataSize = parameterSize;\r
+ _nullMapping = false;\r
+ _nullable = true;\r
+ }\r
+\r
+ private SqliteParameter(SqliteParameter source)\r
+ : this(source.ParameterName, (DbType)source._dbType, 0, source.Direction, source.IsNullable, 0, 0, source.SourceColumn, source.SourceVersion, source.Value)\r
+ {\r
+ _nullMapping = source._nullMapping;\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs a named parameter of the specified type, size, source column and row version\r
+ /// </summary>\r
+ /// <param name="parameterName">The name of the parameter</param>\r
+ /// <param name="parameterType">The data type</param>\r
+ /// <param name="parameterSize">The size of the parameter</param>\r
+ /// <param name="direction">Only input parameters are supported in SQLite</param>\r
+ /// <param name="isNullable">Ignored</param>\r
+ /// <param name="precision">Ignored</param>\r
+ /// <param name="scale">Ignored</param>\r
+ /// <param name="sourceColumn">The source column</param>\r
+ /// <param name="rowVersion">The row version information</param>\r
+ /// <param name="value">The initial value to assign the parameter</param> \r
+#if !PLATFORM_COMPACTFRAMEWORK\r
+ [EditorBrowsable(EditorBrowsableState.Advanced)]\r
+#endif\r
+ public SqliteParameter(string parameterName, DbType parameterType, int parameterSize, ParameterDirection direction, bool isNullable, byte precision, byte scale, string sourceColumn, DataRowVersion rowVersion, object value)\r
+ : this(parameterName, parameterType, parameterSize, sourceColumn, rowVersion)\r
+ {\r
+ Direction = direction;\r
+ IsNullable = isNullable;\r
+ Value = value;\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs a named parameter, yet another flavor\r
+ /// </summary>\r
+ /// <param name="parameterName">The name of the parameter</param>\r
+ /// <param name="parameterType">The data type</param>\r
+ /// <param name="parameterSize">The size of the parameter</param>\r
+ /// <param name="direction">Only input parameters are supported in SQLite</param>\r
+ /// <param name="precision">Ignored</param>\r
+ /// <param name="scale">Ignored</param>\r
+ /// <param name="sourceColumn">The source column</param>\r
+ /// <param name="rowVersion">The row version information</param>\r
+ /// <param name="sourceColumnNullMapping">Whether or not this parameter is for comparing NULL's</param>\r
+ /// <param name="value">The intial value to assign the parameter</param>\r
+#if !PLATFORM_COMPACTFRAMEWORK\r
+ [EditorBrowsable(EditorBrowsableState.Advanced)]\r
+#endif\r
+ public SqliteParameter(string parameterName, DbType parameterType, int parameterSize, ParameterDirection direction, byte precision, byte scale, string sourceColumn, DataRowVersion rowVersion, bool sourceColumnNullMapping, object value)\r
+ : this(parameterName, parameterType, parameterSize, sourceColumn, rowVersion)\r
+ {\r
+ Direction = direction;\r
+ SourceColumnNullMapping = sourceColumnNullMapping;\r
+ Value = value;\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs an unnamed parameter of the specified type and size\r
+ /// </summary>\r
+ /// <param name="parameterType">The data type</param>\r
+ /// <param name="parameterSize">The size of the parameter</param>\r
+ public SqliteParameter(DbType parameterType, int parameterSize)\r
+ : this(null, parameterType, parameterSize, null, DataRowVersion.Current)\r
+ {\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs an unnamed parameter of the specified type, size, and source column\r
+ /// </summary>\r
+ /// <param name="parameterType">The data type</param>\r
+ /// <param name="parameterSize">The size of the parameter</param>\r
+ /// <param name="sourceColumn">The source column</param>\r
+ public SqliteParameter(DbType parameterType, int parameterSize, string sourceColumn)\r
+ : this(null, parameterType, parameterSize, sourceColumn, DataRowVersion.Current)\r
+ {\r
+ }\r
+\r
+ /// <summary>\r
+ /// Constructs an unnamed parameter of the specified type, size, source column and row version\r
+ /// </summary>\r
+ /// <param name="parameterType">The data type</param>\r
+ /// <param name="parameterSize">The size of the parameter</param>\r
+ /// <param name="sourceColumn">The source column</param>\r
+ /// <param name="rowVersion">The row version information</param>\r
+ public SqliteParameter(DbType parameterType, int parameterSize, string sourceColumn, DataRowVersion rowVersion)\r
+ : this(null, parameterType, parameterSize, sourceColumn, rowVersion)\r
+ {\r
+ }\r
+\r
+ /// <summary>\r
+ /// Whether or not the parameter can contain a null value\r
+ /// </summary>\r
+ public override bool IsNullable\r
+ {\r
+ get\r
+ {\r
+ return _nullable;\r
+ }\r
+ set \r
+ {\r
+ _nullable = value;\r
+ }\r
+ }\r
+\r
+ /// <summary>\r
+ /// Returns the datatype of the parameter\r
+ /// </summary>\r
+#if !PLATFORM_COMPACTFRAMEWORK\r
+ [DbProviderSpecificTypeProperty(true)]\r
+ [RefreshProperties(RefreshProperties.All)]\r
+#endif\r
+ public override DbType DbType\r
+ {\r
+ get\r
+ {\r
+ if (_dbType == -1)\r
+ {\r
+ if (_objValue != null && _objValue != DBNull.Value)\r
+ {\r
+ return SqliteConvert.TypeToDbType(_objValue.GetType());\r
+ }\r
+ return DbType.String; // Unassigned default value is String\r
+ }\r
+ return (DbType)_dbType;\r
+ }\r
+ set\r
+ {\r
+ _dbType = (int)value;\r
+ }\r
+ }\r
+\r
+ /// <summary>\r
+ /// Supports only input parameters\r
+ /// </summary>\r
+ public override ParameterDirection Direction\r
+ {\r
+ get\r
+ {\r
+ return ParameterDirection.Input;\r
+ }\r
+ set\r
+ {\r
+ if (value != ParameterDirection.Input)\r
+ throw new NotSupportedException();\r
+ }\r
+ }\r
+\r
+ /// <summary>\r
+ /// Returns the parameter name\r
+ /// </summary>\r
+ public override string ParameterName\r
+ {\r
+ get\r
+ {\r
+ return _parameterName;\r
+ }\r
+ set\r
+ {\r
+ _parameterName = value;\r
+ }\r
+ }\r
+\r
+ /// <summary>\r
+ /// Resets the DbType of the parameter so it can be inferred from the value\r
+ /// </summary>\r
+ public override void ResetDbType()\r
+ {\r
+ _dbType = -1;\r
+ }\r
+\r
+ /// <summary>\r
+ /// Returns the size of the parameter\r
+ /// </summary>\r
+#if !PLATFORM_COMPACTFRAMEWORK\r
+ [DefaultValue((int)0)]\r
+#endif\r
+ public override int Size\r
+ {\r
+ get\r
+ {\r
+ return _dataSize;\r
+ }\r
+ set\r
+ {\r
+ _dataSize = value;\r
+ }\r
+ }\r
+\r
+ /// <summary>\r
+ /// Gets/sets the source column\r
+ /// </summary>\r
+ public override string SourceColumn\r
+ {\r
+ get\r
+ {\r
+ return _sourceColumn;\r
+ }\r
+ set\r
+ {\r
+ _sourceColumn = value;\r
+ }\r
+ }\r
+\r
+ /// <summary>\r
+ /// Used by DbCommandBuilder to determine the mapping for nullable fields\r
+ /// </summary>\r
+ public override bool SourceColumnNullMapping\r
+ {\r
+ get\r
+ {\r
+ return _nullMapping;\r
+ }\r
+ set\r
+ {\r
+ _nullMapping = value;\r
+ }\r
+ }\r
+\r
+ /// <summary>\r
+ /// Gets and sets the row version\r
+ /// </summary>\r
+ public override DataRowVersion SourceVersion\r
+ {\r
+ get\r
+ {\r
+ return _rowVersion;\r
+ }\r
+ set\r
+ {\r
+ _rowVersion = value;\r
+ }\r
+ }\r
+\r
+ /// <summary>\r
+ /// Gets and sets the parameter value. If no datatype was specified, the datatype will assume the type from the value given.\r
+ /// </summary>\r
+#if !PLATFORM_COMPACTFRAMEWORK\r
+ [TypeConverter(typeof(StringConverter)), RefreshProperties(RefreshProperties.All)]\r
+#endif\r
+ public override object Value\r
+ {\r
+ get\r
+ {\r
+ return _objValue;\r
+ }\r
+ set\r
+ {\r
+ _objValue = value;\r
+ if (_dbType == -1 && _objValue != null && _objValue != DBNull.Value) // If the DbType has never been assigned, try to glean one from the value's datatype \r
+ _dbType = (int)SqliteConvert.TypeToDbType(_objValue.GetType());\r
+ }\r
+ }\r
+\r
+ /// <summary>\r
+ /// Clones a parameter\r
+ /// </summary>\r
+ /// <returns>A new, unassociated SqliteParameter</returns>\r
+ public object Clone()\r
+ {\r
+ SqliteParameter newparam = new SqliteParameter(this);\r
+\r
+ return newparam;\r
+ }\r
+ }\r
+}\r