Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Parameter fixups |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | sourceforge |
| Files: | files | file ages | folders |
| SHA1: |
f1ab070a900e34daa039624c1a9fd189 |
| User & Date: | rmsimpson 2006-04-14 04:30:15 |
Context
|
2006-04-14
| ||
| 05:53 | 1.0.28.0 check-in: bd01d5ebbe user: rmsimpson tags: sourceforge | |
| 04:30 | Parameter fixups check-in: f1ab070a90 user: rmsimpson tags: sourceforge | |
| 04:29 | Fix incorrect type check-in: bf78037aa9 user: rmsimpson tags: sourceforge | |
Changes
Changes to System.Data.SQLite/SQLiteParameter.cs.
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ... 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 ... 406 407 408 409 410 411 412 413 414 |
namespace System.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>
private int _dbType;
/// <summary>
/// The version information for mapping the parameter
/// </summary>
private DataRowVersion _rowVersion;
/// <summary>
/// The value of the data in the parameter
/// </summary>
................................................................................
/// <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>
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 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)
................................................................................
/// <returns>A new, unassociated SQLiteParameter</returns>
public object Clone()
{
SQLiteParameter newparam = new SQLiteParameter(ParameterName, this.DbType, Size, Direction, IsNullable, 0, 0, SourceColumn, SourceVersion, Value);
return newparam;
}
}
}
|
> > > > | | > > > > > > > > > > > > > > > > > > > > > > > > > > > | > > > > > | > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 ... 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 ... 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 |
namespace System.Data.SQLite
{
using System;
using System.Data;
using System.Data.Common;
using System.ComponentModel;
using System.Globalization;
/// <summary>
/// SQLite implementation of DbParameter.
/// </summary>
#if !PLATFORM_COMPACTFRAMEWORK
[TypeConverter(typeof(SQLiteParameterConverter))]
#endif
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>
................................................................................
/// <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)
................................................................................
/// <returns>A new, unassociated SQLiteParameter</returns>
public object Clone()
{
SQLiteParameter newparam = new SQLiteParameter(ParameterName, this.DbType, Size, Direction, IsNullable, 0, 0, SourceColumn, SourceVersion, Value);
return newparam;
}
#if !PLATFORM_COMPACT_FRAMEWORK
internal sealed class SQLiteParameterConverter : ExpandableObjectConverter
{
public SQLiteParameterConverter()
{
}
public override bool CanConvertTo(ITypeDescriptorContext context, Type destinationType)
{
if (typeof(System.ComponentModel.Design.Serialization.InstanceDescriptor) == destinationType)
{
return true;
}
return base.CanConvertTo(context, destinationType);
}
public override object ConvertTo(ITypeDescriptorContext context, CultureInfo culture, object value, Type destinationType)
{
if (destinationType == null)
{
throw new ArgumentNullException();
}
if ((typeof(System.ComponentModel.Design.Serialization.InstanceDescriptor) == destinationType) && (value is SQLiteParameter))
{
return ConvertToInstanceDescriptor(value as SQLiteParameter);
}
return base.ConvertTo(context, culture, value, destinationType);
}
private System.ComponentModel.Design.Serialization.InstanceDescriptor ConvertToInstanceDescriptor(SQLiteParameter parameter)
{
Type[] types = null;
object[] parms = null;
if (parameter.SourceColumnNullMapping == true)
{
// (string parameterName, DbType parameterType, int parameterSize, ParameterDirection direction, byte precision, byte scale, string sourceColumn, DataRowVersion rowVersion, bool sourceColumnNullMapping, object value)
types = new Type[] { typeof(string), typeof(DbType), typeof(int), typeof(ParameterDirection), typeof(byte), typeof(byte), typeof(string), typeof(DataRowVersion), typeof(bool), typeof(object) };
parms = new object[] { parameter.ParameterName, (DbType)parameter._dbType, 0, parameter.Direction, 0, 0, parameter.SourceColumn, parameter.SourceVersion, parameter.SourceColumnNullMapping, parameter.Value };
}
else
{
// (string parameterName, DbType parameterType, int parameterSize, ParameterDirection direction, bool isNullable, byte precision, byte scale, string sourceColumn, DataRowVersion rowVersion, object value)
types = new Type[] { typeof(string), typeof(DbType), typeof(int), typeof(ParameterDirection), typeof(bool), typeof(byte), typeof(byte), typeof(string), typeof(DataRowVersion), typeof(object) };
parms = new object[] { parameter.ParameterName, (DbType)parameter._dbType, parameter.Direction, parameter.IsNullable, 0, 0, parameter.SourceColumn, parameter.SourceVersion, parameter.Value };
}
System.Reflection.ConstructorInfo info = typeof(SQLiteParameter).GetConstructor(types);
return new System.ComponentModel.Design.Serialization.InstanceDescriptor(info, parms);
}
}
#endif
}
}
|
Changes to System.Data.SQLite/SQLiteParameterCollection.cs.
134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 ... 159 160 161 162 163 164 165 166 167 168 169 170 171 172 ... 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 |
}
/// <summary>
/// Adds a parameter to the collection
/// </summary>
/// <param name="parameter">The parameter to add</param>
/// <returns>A zero-based index of where the parameter is located in the array</returns>
public int Add(DbParameter parameter)
{
int n = -1;
if (parameter.ParameterName != null)
{
n = IndexOf(parameter.ParameterName);
}
................................................................................
}
/// <summary>
/// Adds a parameter to the collection
/// </summary>
/// <param name="value">The parameter to add</param>
/// <returns>A zero-based index of where the parameter is located in the array</returns>
public override int Add(object value)
{
return Add((SQLiteParameter)value);
}
/// <summary>
/// Adds a named/unnamed parameter and its value to the parameter collection.
................................................................................
return param;
}
/// <summary>
/// Adds an array of parameters to the collection
/// </summary>
/// <param name="values">The array of parameters to add</param>
public void AddRange(DbParameter[] values)
{
int x = values.Length;
for (int n = 0; n < x; n++)
Add(values[n]);
}
/// <summary>
|
| > > > | |
134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 ... 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 ... 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 |
}
/// <summary>
/// Adds a parameter to the collection
/// </summary>
/// <param name="parameter">The parameter to add</param>
/// <returns>A zero-based index of where the parameter is located in the array</returns>
public int Add(SQLiteParameter parameter)
{
int n = -1;
if (parameter.ParameterName != null)
{
n = IndexOf(parameter.ParameterName);
}
................................................................................
}
/// <summary>
/// Adds a parameter to the collection
/// </summary>
/// <param name="value">The parameter to add</param>
/// <returns>A zero-based index of where the parameter is located in the array</returns>
#if !PLATFORM_COMPACTFRAMEWORK
[EditorBrowsable(EditorBrowsableState.Never)]
#endif
public override int Add(object value)
{
return Add((SQLiteParameter)value);
}
/// <summary>
/// Adds a named/unnamed parameter and its value to the parameter collection.
................................................................................
return param;
}
/// <summary>
/// Adds an array of parameters to the collection
/// </summary>
/// <param name="values">The array of parameters to add</param>
public void AddRange(SQLiteParameter[] values)
{
int x = values.Length;
for (int n = 0; n < x; n++)
Add(values[n]);
}
/// <summary>
|