System.Data.Common.DbParameterCollection.Add(object)

Here are the examples of the csharp api class System.Data.Common.DbParameterCollection.Add(object) taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.

200 Examples 7

151. Example

Project: Kalman.Studio
Source File: ParameterCache.cs
protected virtual void AddParametersFromCache(DbCommand command, Database database)
        {
			IDataParameter[] parameters = this.cache.GetCachedParameterSet(database.ConnectionString, command);

            foreach (IDataParameter p in parameters)
            {
				command.Parameters.Add(p);
            }
        }

152. Example

Project: Pscx
Source File: InvokeAdoCommandCommand.cs
private void AddCommandParameters(DbCommand command)
        {
            if ((this.CommandParameters != null) && this.CommandParameters.Count > 0)
            {
                foreach (DictionaryEntry entry in this.CommandParameters)
                {
                    // TODO: improve this - it doesn't support much
                    string name = (string) entry.Key;
                    DbParameter param = _factory.CreateParameter();
                    param.ParameterName = name;
                    param.Value = entry.Value;
                    command.Parameters.Add(param);
                }
            }
        }

153. Example

Project: Radarr
Source File: DataMapper.cs
public IDbDataParameter AddParameter(IDbDataParameter parameter)
        {
            // Convert null values to DBNull.Value
            if (parameter.Value == null)
                parameter.Value = DBNull.Value;

            Parameters.Add(parameter);
            return parameter;
        }

154. Example

Project: Sonarr
Source File: DataMapper.cs
public IDbDataParameter AddParameter(IDbDataParameter parameter)
        {
            // Convert null values to DBNull.Value
            if (parameter.Value == null)
                parameter.Value = DBNull.Value;

            Parameters.Add(parameter);
            return parameter;
        }

155. Example

Project: SubSonic-2.0
Source File: AccessDataProvider.cs
public override DbCommand GetDbCommand(QueryCommand qry)
        {
            AutomaticConnectionScope conn = new AutomaticConnectionScope(this);
            DbCommand cmd = conn.Connection.CreateCommand();
            cmd.CommandText = qry.CommandSql;
            cmd.CommandType = qry.CommandType;

            foreach(QueryParameter par in qry.Parameters)
            {
                cmd.Parameters.Add(par);
            }

            return cmd;
        }

156. Example

Project: SubSonic-2.0
Source File: VistaDBDataProvider.cs
public override DbCommand GetDbCommand(QueryCommand qry)
        {
            DbCommand cmd;
            //VistaDBConnection conn = new VistaDBConnection(connectionString);
            AutomaticConnectionScope conn = new AutomaticConnectionScope(this);

            cmd = conn.Connection.CreateCommand();
            cmd.CommandText = qry.CommandSql;
            cmd.CommandType = qry.CommandType;

            foreach (QueryParameter par in qry.Parameters)
            {
                cmd.Parameters.Add(par);
            }

            return cmd;
        }

157. Example

Project: EasyLOB
Source File: DbFactoryExtensions.cs
public static void AddParameterWithValue(this DbCommand command, string parameterName, object parameterValue)
        {
            var parameter = command.CreateParameter();
            parameter.ParameterName = parameterName;
            parameter.Value = parameterValue;
            command.Parameters.Add(parameter);
        }

158. Example

Project: EDDiscovery
Source File: SQLiteCommandED.cs
public static void AddParameterWithValue(this DbCommand cmd, string name, object val)
        {
            var par = cmd.CreateParameter();
            par.ParameterName = name;
            par.Value = val;
            cmd.Parameters.Add(par);
        }

159. Example

Project: EDDiscovery
Source File: SQLiteCommandED.cs
public static void AddParameter(this DbCommand cmd, string name, DbType type)
        {
            var par = cmd.CreateParameter();
            par.ParameterName = name;
            par.DbType = type;
            cmd.Parameters.Add(par);
        }

160. Example

Project: Akka.Persistence.PostgreSql
Source File: PostgreSqlQueryExecutor.cs
protected override void SetPayloadParameter(object snapshot, DbCommand command)
        {
            var serializationResult = _serialize(snapshot);
            command.Parameters.Add(new NpgsqlParameter("@Payload", serializationResult.DbType) { Value = serializationResult.Payload });
        }

161. Example

Project: 404handler
Source File: DataAccessBaseEx.cs
public DataSet ExecuteSQL(string sqlCommand, List<IDbDataParameter> parameters)
        {


            return Executor.Execute<DataSet>(delegate
            {
                using (DataSet ds = new DataSet())
                {
                    try
                    {
                        DbCommand command = CreateCommand(sqlCommand);
                        if (parameters != null)
                        {
                            foreach (SqlParameter parameter in parameters)
                            {
                                command.Parameters.Add(parameter);
                            }
                        }
                        command.CommandType = CommandType.Text;
                        base.CreateDataAdapter(command).Fill(ds);
                    }
                    catch (Exception ex)
                    {
                        Logger.Error(string.Format("An error occureding in the ExecuteSQL method with the following sql{0}. Exception:{1}", sqlCommand, ex));
                    }

                    return ds;
                }
            });

        }

162. Example

Project: maparound.core
Source File: SpatialDataProviders.cs
private void addParameter(DbCommand command, string paramName, object paramValue)
        {
            DbParameter param = command.CreateParameter();
            param.ParameterName = paramName;
            param.Value = paramValue;
            command.Parameters.Add(param);
        }

163. Example

Project: Goo-Micro-ORM
Source File: DBManager.cs
public void AddParameter<T>(string name, T value)
        {
            if (command != null)
            {
                var parameter = provider.Value.CreateParameter();
                parameter.ParameterName = name;
                parameter.Value = value;

                command.Parameters.Add(parameter);
            }
            else
                throw new Exception("DbCommand object can not be null.");
        }

164. Example

Project: Dos.ORM
Source File: BatchCommander.cs
private DbCommand MergeCommands()
        {
            DbCommand cmd = db.GetSqlStringCommand("init");
            StringBuilder sb = new StringBuilder();
            foreach (DbCommand item in batchCommands)
            {
                if (item.CommandType == CommandType.Text)
                {
                    foreach (DbParameter dbPara in item.Parameters)
                    {
                        DbParameter p = (DbParameter)((ICloneable)dbPara).Clone();
                        cmd.Parameters.Add(p);
                    }
                    sb.Append(item.CommandText);
                    sb.Append(";");
                }
            }

            if (sb.Length > 0)
            {
                if (db.DbProvider is Dos.ORM.Oracle.OracleProvider)
                {
                    sb.Insert(0, "begin ");
                    sb.Append(" end;");
                }
            }

            cmd.CommandText = sb.ToString();
            return cmd;
        }

165. Example

Project: Dos.ORM
Source File: Database.cs
public void AddParameter(DbCommand command, string name, DbType dbType, int size, ParameterDirection direction, bool nullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value)
        {
            DbParameter parameter = CreateParameter(name, dbType == DbType.Object ? DbType.String : dbType, size, direction, nullable, precision, scale, sourceColumn, sourceVersion, value);
            command.Parameters.Add(parameter);
        }

166. Example

Project: Dos.ORM
Source File: Database.cs
public void AddParameter(DbCommand command, params DbParameter[] parameters)
        {
            if (null == parameters || parameters.Length == 0)
                return;
            foreach (DbParameter p in parameters)
            {
                p.ParameterName = dbProvider.BuildParameterName(p.ParameterName);
                command.Parameters.Add(p);
            }

        }

167. Example

Project: Dos.ORM
Source File: Database.cs
internal DbCommand AddCommandParameter(DbCommand command, params Parameter[] parameters)
        {
            if (null == parameters || parameters.Length == 0)
                return command;
            //var i = 0;
            foreach (Parameter p in parameters)
            {
                DbParameter dbParameter = CreateParameter(p.ParameterName);// + i
                dbParameter.Value = p.ParameterValue;
                if (p.ParameterDbType.HasValue)
                    dbParameter.DbType = p.ParameterDbType.Value;
                if (p.ParameterSize.HasValue)
                    dbParameter.Size = p.ParameterSize.Value;
                command.Parameters.Add(dbParameter);
                //i++;
            }

            return command;
        }

168. Example

Project: Dos.ORM
Source File: BatchCommander.cs
private DbCommand MergeCommands()
        {
            DbCommand cmd = db.GetSqlStringCommand("init");
            StringBuilder sb = new StringBuilder();
            foreach (DbCommand item in batchCommands)
            {
                if (item.CommandType == CommandType.Text)
                {
                    foreach (DbParameter dbPara in item.Parameters)
                    {
                        DbParameter p = (DbParameter)((ICloneable)dbPara).Clone();
                        cmd.Parameters.Add(p);
                    }
                    sb.Append(item.CommandText);
                    sb.Append(";");
                }
            }

            if (sb.Length > 0)
            {
                if (db.DbProvider is Dos.ORM.Oracle.OracleProvider)
                {
                    sb.Insert(0, "begin ");
                    sb.Append(" end;");
                }
            }

            cmd.CommandText = sb.ToString();
            return cmd;
        }

169. Example

Project: Dos.ORM
Source File: Database.cs
public void AddParameter(DbCommand command, string name, DbType dbType, int size, ParameterDirection direction, bool nullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value)
        {
            DbParameter parameter = CreateParameter(name, dbType == DbType.Object ? DbType.String : dbType, size, direction, nullable, precision, scale, sourceColumn, sourceVersion, value);
            command.Parameters.Add(parameter);
        }

170. Example

Project: Dos.ORM
Source File: Database.cs
public void AddParameter(DbCommand command, params DbParameter[] parameters)
        {
            if (null == parameters || parameters.Length == 0)
                return;
            foreach (DbParameter p in parameters)
            {
                p.ParameterName = dbProvider.BuildParameterName(p.ParameterName);
                command.Parameters.Add(p);
            }

        }

171. Example

Project: Dos.ORM
Source File: Database.cs
internal DbCommand AddCommandParameter(DbCommand command, params Parameter[] parameters)
        {
            if (null == parameters || parameters.Length == 0)
                return command;

            foreach (Parameter p in parameters)
            {
                DbParameter dbParameter = CreateParameter(p.ParameterName);
                dbParameter.Value = p.ParameterValue;
                if (p.ParameterDbType.HasValue)
                    dbParameter.DbType = p.ParameterDbType.Value;
                if (p.ParameterSize.HasValue)
                    dbParameter.Size = p.ParameterSize.Value;
                command.Parameters.Add(dbParameter);
            }

            return command;
        }

172. Example

Project: Dos.ORM
Source File: BatchCommander.cs
private DbCommand MergeCommands()
        {
            DbCommand cmd = db.GetSqlStringCommand("init");
            StringBuilder sb = new StringBuilder();
            foreach (DbCommand item in batchCommands)
            {
                if (item.CommandType == CommandType.Text)
                {
                    foreach (DbParameter dbPara in item.Parameters)
                    {
                        DbParameter p = (DbParameter)((ICloneable)dbPara).Clone();
                        cmd.Parameters.Add(p);
                    }
                    sb.Append(item.CommandText);
                    sb.Append(";");
                }
            }

            if (sb.Length > 0)
            {
                if (db.DbProvider is Dos.ORM.Oracle.OracleProvider)
                {
                    sb.Insert(0, "begin ");
                    sb.Append(" end;");
                }
            }

            cmd.CommandText = sb.ToString();
            return cmd;
        }

173. Example

Project: Dos.ORM
Source File: Database.cs
public void AddParameter(DbCommand command, string name, DbType dbType, int size, ParameterDirection direction, bool nullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value)
        {
            DbParameter parameter = CreateParameter(name, dbType == DbType.Object ? DbType.String : dbType, size, direction, nullable, precision, scale, sourceColumn, sourceVersion, value);
            command.Parameters.Add(parameter);
        }

174. Example

Project: Dos.ORM
Source File: Database.cs
public void AddParameter(DbCommand command, params DbParameter[] parameters)
        {
            if (null == parameters || parameters.Length == 0)
                return;
            foreach (DbParameter p in parameters)
            {
                p.ParameterName = dbProvider.BuildParameterName(p.ParameterName);
                command.Parameters.Add(p);
            }

        }

175. Example

Project: Dos.ORM
Source File: Database.cs
internal DbCommand AddCommandParameter(DbCommand command, params Parameter[] parameters)
        {
            if (null == parameters || parameters.Length == 0)
                return command;

            foreach (Parameter p in parameters)
            {
                DbParameter dbParameter = CreateParameter(p.ParameterName);
                dbParameter.Value = p.ParameterValue;
                if (p.ParameterDbType.HasValue)
                    dbParameter.DbType = p.ParameterDbType.Value;
                if (p.ParameterSize.HasValue)
                    dbParameter.Size = p.ParameterSize.Value;
                command.Parameters.Add(dbParameter);
            }

            return command;
        }

176. Example

Project: SimpleLogger
Source File: DatabaseLoggerModule.cs
private void AddParameter(DbCommand command, string name, object value, DbType type)
        {
            command.Parameters.Add(GetParameter(command, name, value, type));
        }

177. Example

Project: Alluvial
Source File: SqlBrokeredDistributorDatabase.cs
private static void AddParameter(
            DbCommand cmd,
            string name,
            object value)
        {
            var parameter = cmd.CreateParameter();
            parameter.ParameterName = name;
            parameter.Value = value;
            cmd.Parameters.Add(parameter);
        }

178. Example

Project: MimeKit
Source File: DbExtensions.cs
public static int AddParameterWithValue (this DbCommand command, string name, object value)
		{
			var parameter = command.CreateParameter ();
			parameter.ParameterName = name;
			parameter.Value = value;

			return command.Parameters.Add (parameter);
		}

179. Example

Project: Restful
Source File: SessionProvider.cs
protected virtual void PrepareParameter( DbCommand command, IDictionary<string,object> parameters )
        {
            if( parameters == null || parameters.Count == 0 )
            {
                return;
            }

            foreach( var item in parameters )
            {
                DbParameter parameter = command.CreateParameter();

                parameter.ParameterName = item.Key;
                parameter.Value = item.Value == null ? DBNull.Value : item.Value;

                command.Parameters.Add( parameter );
            }
        }

180. Example

Project: sqlhelper2
Source File: DbCommandExtensions.cs
private static void AddParameter(DbCommand cmd, string name, object value) {
            var p = cmd.CreateParameter();
            p.ParameterName = name;
            p.Value = value ?? DBNull.Value;
            cmd.Parameters.Add(p);
        }

181. Example

Project: Kalman.Studio
Source File: SqlServerDatabase.cs
public virtual void AddParameter(DbCommand command, string name, SqlDbType dbType, int size, ParameterDirection direction, bool nullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value)
		{
			DbParameter parameter = CreateParameter(name, dbType, size, direction, nullable, precision, scale, sourceColumn, sourceVersion, value);
			command.Parameters.Add(parameter);
		}

182. Example

Project: Kalman.Studio
Source File: Database.cs
public virtual void AddParameter(DbCommand command, string name, DbType dbType, int size, ParameterDirection direction, bool nullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value)
        {
            //???????????????????????????DbType???Sql Server?SqlDbType?????????????
            DbParameter parameter = CreateParameter(name, dbType, size, direction, nullable, precision, scale, sourceColumn, sourceVersion, value);
            command.Parameters.Add(parameter);
        }

183. Example

Project: ALinq
Source File: DB2Provider.cs
internal override void AssignParameters(DbCommand cmd, ReadOnlyCollection<SqlParameterInfo> pa/n ..... /n //View Source file for more details /n }

184. Example

Project: ALinq
Source File: MySqlProvider.cs
internal override void AssignParameters(DbCommand cmd, ReadOnlyCollection<SqlParameterInfo> pa/n ..... /n //View Source file for more details /n }

185. Example

Project: ReliableDbProvider
Source File: Massive.cs
public static void AddParam(this DbCommand cmd, object item)
        {
            var p = cmd.CreateParameter();
            p.ParameterName = string.Format("@{0}", cmd.Parameters.Count);
            if (item == null)
            {
                p.Value = DBNull.Value;
            }
            else
            {
                if (item.GetType() == typeof(Guid))
                {
                    p.Value = item.ToString();
                    p.DbType = DbType.String;
                    p.Size = 4000;
                }
                else if (item.GetType() == typeof(ExpandoObject))
                {
                    var d = (IDictionary<string, object>)item;
                    p.Value = d.Values.FirstOrDefault();
                }
                else
                {
                    p.Value = item;
                }
                if (item.GetType() == typeof(string))
                    p.Size = ((string)item).Length > 4000 ? -1 : 4000;
            }
            cmd.Parameters.Add(p);
        }

186. Example

Project: openpetra
Source File: ProgressODBC.cs
public DbCommand NewCommand(ref string ACommandText, DbConnection AConnection, DbParameter[] AParametersArray, TDBTransaction ATransaction)
        {
            DbCommand ObjReturn = null;

            ACommandText = FormatQueryRDBMSSpecific(ACommandText);

            if (ATransaction == null)
            {
                ObjReturn = new OdbcCommand(ACommandText, (OdbcConnection)AConnection);
            }
            else
            {
                ObjReturn = new OdbcCommand(ACommandText, (OdbcConnection)AConnection, (OdbcTransaction)ATransaction.WrappedTransaction);
            }

            if (AParametersArray != null)
            {
                // add parameters
                foreach (DbParameter param in AParametersArray)
                {
                    ObjReturn.Parameters.Add(param);
                }
            }

            return ObjReturn;
        }

187. Example

Project: SubSonic-2.0
Source File: DataProvider.cs
public virtual DbCommand GetDbCommand(QueryCommand qry)
        {
            AutomaticConnectionScope conn = new AutomaticConnectionScope(this);

            DbCommand cmd = conn.Connection.CreateCommand();
            cmd.CommandText = qry.CommandSql;
            cmd.CommandType = qry.CommandType;

            foreach(QueryParameter par in qry.Parameters)
            {
                DbParameter newParam = cmd.CreateParameter();
                newParam.Direction = par.Mode;
                newParam.ParameterName = par.ParameterName;
                newParam.Value = par.ParameterValue;
                newParam.Size = par.Size;
                newParam.DbType = par.DataType;
                cmd.Parameters.Add(newParam);
            }

            return cmd;
        }

188. Example

Project: PdfReport.Core
Source File: SqlParametersParser.cs
public static void ApplySafeParameters(DbCommand cmd, string sqlWithAtSignParameters, params object[] parametersValues)
        {
            if (string.IsNullOrEmpty(sqlWithAtSignParameters)) return;
            if (parametersValues == null || parametersValues.Length < 0) return;
            var parms = createParameters(cmd, sqlWithAtSignParameters, parametersValues);
            if (parms == null) return;
            foreach (var param in parms)
                cmd.Parameters.Add(param);
        }

189. Example

Project: PdfReport
Source File: SqlParametersParser.cs
public static void ApplySafeParameters(DbCommand cmd, string sqlWithAtSignParameters, params object[] parametersValues)
        {
            if (string.IsNullOrEmpty(sqlWithAtSignParameters)) return;
            if (parametersValues == null || parametersValues.Length < 0) return;
            var parms = createParameters(cmd, sqlWithAtSignParameters, parametersValues);
            if (parms == null) return;
            foreach (var param in parms)
                cmd.Parameters.Add(param);
        }

190. Example

Project: CIAPI.CS
Source File: SQLiteStore.cs
private static void SetParameter(DbCommand command, string paramName, object paramValue)
        {
            DbParameter param = command.CreateParameter();
            param.DbType = DbType.String;
            param.Direction = ParameterDirection.Input;
            param.ParameterName = paramName;
            param.Value = paramValue;
            command.Parameters.Add(param);
        }

191. Example

Project: NDF.Infrastructure
Source File: DatabaseExtensions.DiscoverParameters.cs
public static void DiscoverParameters(Database database, DbCommand command)
        {
            if (command.CommandType == CommandType.StoredProcedure)
            {
                database.DiscoverParameters(command);
                return;
            }
            Check.NotEmpty(command.CommandText, "command.CommandText");
            var parser = NDF.Data.Common.DbProviderFactoryExtensions.GetScriptParameterParser(database.DbProviderFactory);
            string[] parameterNames = parser.GetParameterNames(command.CommandText);
            foreach (var paremeterName in parameterNames)
            {
                DbParameter parameter = CreateParameter(database, paremeterName);
                command.Parameters.Add(parameter);
            }
        }

192. Example

Project: NDF.Infrastructure
Source File: DB2Database.cs
public virtual void AddParameter(DbCommand command, string name, DB2Type dbType, int size, ParameterDirection direction, bool nullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value)
        {
            DbParameter parameter = this.CreateParameter(name, dbType, size, direction, nullable, precision, scale, sourceColumn, sourceVersion, value);
            command.Parameters.Add(parameter);
        }

193. Example

Project: NDF.Infrastructure
Source File: MySqlDatabase.cs
public virtual void AddParameter(DbCommand command, string name, MySqlDbType dbType, int size, ParameterDirection direction, bool nullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value)
        {
            DbParameter parameter = this.CreateParameter(name, dbType, size, direction, nullable, precision, scale, sourceColumn, sourceVersion, value);
            command.Parameters.Add(parameter);
        }

194. Example

Project: NDF.Infrastructure
Source File: OracleDatabase.cs
public void AddParameter(DbCommand command, string name, OracleDbType oracleType, int size,
            ParameterDirection direction, bool nullable, byte precision, byte scale, string sourceColumn,
            DataRowVersion sourceVersion, object value)
        {
            if (command == null) throw new ArgumentNullException("command");

            OracleParameter param = CreateParameter(name, DbType.AnsiString, size, direction, nullable, precision, scale, sourceColumn, sourceVersion, value) as OracleParameter;
            param.OracleDbType = oracleType;
            command.Parameters.Add(param);
        }

195. Example

Project: ClearCanvas
Source File: Utilities.cs
public static void SetParameter(this DbCommand command, string name, object value)
		{
			var parameter = command.CreateParameter();
			parameter.ParameterName = name;
			parameter.Value = value ?? DBNull.Value;
			command.Parameters.Add(parameter);
		}

196. Example

Project: OrigoDB
Source File: SqlCommandStore.cs
public virtual DbCommand CreateAppendCommand()
        {
            var dbCommand = _providerFactory.CreateCommand();
            dbCommand.CommandText = _statements.AppendEntry;
            
            var param = _providerFactory.CreateParameter();
            param.ParameterName = "@Id";
            param.DbType = DbType.Int64;
            dbCommand.Parameters.Add(param);

            param = _providerFactory.CreateParameter();
            param.ParameterName = "@Created";
            param.DbType = DbType.DateTime;
            dbCommand.Parameters.Add(param);

            param = _providerFactory.CreateParameter();
            param.ParameterName = "@Type";
            param.DbType = DbType.String;
            param.Size = 1024;
            dbCommand.Parameters.Add(param);

            param = _providerFactory.CreateParameter();
            param.ParameterName = "@Data";
            param.DbType = DbType.Binary;
            dbCommand.Parameters.Add(param);


            return dbCommand;
        }

197. Example

Project: RiotControl
Source File: DatabaseCommand.cs
public void Add(string name, DbType type)
		{
			DbParameter parameter = Command.CreateParameter();
			parameter.ParameterName = string.Format("{0}{1}", ParameterPrefix, name);
			parameter.DbType = type;
			Command.Parameters.Add(parameter);
		}

198. Example

Project: Craig-s-Utility-Library
Source File: DbCommandExtensions.cs
public static DbParameter GetOrCreateParameter(this DbCommand Command, string ID)
        {
            if (Command == null)
                return null;
            if (Command.Parameters.Contains(ID))
                return Command.Parameters[ID];
            var Parameter = Command.CreateParameter();
            Parameter.ParameterName = ID;
            Command.Parameters.Add(Parameter);
            return Parameter;
        }

199. Example

Project: Craig-s-Utility-Library
Source File: DbCommandExtensions.cs
public static DbParameter GetOrCreateParameter(this DbCommand Command, string ID)
        {
            if (Command == null)
                return null;
            if (Command.Parameters.Contains(ID))
                return Command.Parameters[ID];
            var Parameter = Command.CreateParameter();
            Parameter.ParameterName = ID;
            Command.Parameters.Add(Parameter);
            return Parameter;
        }

200. Example

Project: Sequelocity.NET
Source File: SequelocityDotNet.cs
public static DbCommand AddParameter( this DbCommand dbCommand, string parameterName, object parameterValue )
        {
            if ( String.IsNullOrWhiteSpace( parameterName ) )
            {
                throw new ArgumentNullException( "parameterName" );
            }

            if ( parameterValue == null )
            {
                parameterValue = DBNull.Value;
            }

            DbParameter parameter = dbCommand.CreateParameter( parameterName, parameterValue );

            dbCommand.Parameters.Add( parameter );

            return dbCommand;
        }