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
0
1. Example
View licenseprivate static void AddParameter(DbCommand cmd, string parameterName, SqlDbType type, int length, ParameterDirection direction, object value)
{
cmd.Parameters.Add(new SqlParameter(parameterName, type, length) { Direction = direction, Value = value });
}0
2. Example
View licensepublic TParameter AddParameter(String Name, SqlDbType Type, int Size,
Object Value, Para/n ..... /n //View Source file for more details /n }0
3. Example
View licensepublic static DbCommand AddParameter( this DbCommand dbCommand, DbParameter dbParameter )
{
if ( dbParameter == null )
{
throw new ArgumentNullException( "dbParameter" );
}
dbCommand.Parameters.Add( dbParameter );
return dbCommand;
}0
4. Example
View licensepublic IDbDataParameter AddParameter(IDbDataParameter parameter)
{
// Convert null values to DBNull.Value
if (parameter.Value == null)
parameter.Value = DBNull.Value;
Parameters.Add(parameter);
return parameter;
}0
5. Example
View licenseprotected virtual void AddParametersFromCache(DbCommand command, Database database)
{
IDataParameter[] parameters = this.cache.GetCachedParameterSet(database.ConnectionString, command);
foreach (IDataParameter p in parameters)
{
command.Parameters.Add(p);
}
}0
6. Example
View licenseprivate 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);
}
}
}0
7. Example
View licensepublic IDbDataParameter AddParameter(IDbDataParameter parameter)
{
// Convert null values to DBNull.Value
if (parameter.Value == null)
parameter.Value = DBNull.Value;
Parameters.Add(parameter);
return parameter;
}0
8. Example
View licensepublic IDbDataParameter AddParameter(IDbDataParameter parameter)
{
// Convert null values to DBNull.Value
if (parameter.Value == null)
parameter.Value = DBNull.Value;
Parameters.Add(parameter);
return parameter;
}0
9. Example
View licensepublic 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;
}0
10. Example
View licensepublic 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;
}0
11. Example
View licensepublic static void AddParameterWithValue(this DbCommand command, string parameterName, object parameterValue)
{
var parameter = command.CreateParameter();
parameter.ParameterName = parameterName;
parameter.Value = parameterValue;
command.Parameters.Add(parameter);
}0
12. Example
View licensepublic static void AddParameterWithValue(this DbCommand cmd, string name, object val)
{
var par = cmd.CreateParameter();
par.ParameterName = name;
par.Value = val;
cmd.Parameters.Add(par);
}0
13. Example
View licensepublic static void AddParameter(this DbCommand cmd, string name, DbType type)
{
var par = cmd.CreateParameter();
par.ParameterName = name;
par.DbType = type;
cmd.Parameters.Add(par);
}0
14. Example
View licenseprotected override void SetPayloadParameter(object snapshot, DbCommand command)
{
var serializationResult = _serialize(snapshot);
command.Parameters.Add(new NpgsqlParameter("@Payload", serializationResult.DbType) { Value = serializationResult.Payload });
}0
15. Example
View licensepublic 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;
}
});
}0
16. Example
View licenseprivate void addParameter(DbCommand command, string paramName, object paramValue)
{
DbParameter param = command.CreateParameter();
param.ParameterName = paramName;
param.Value = paramValue;
command.Parameters.Add(param);
}0
17. Example
View licensepublic 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.");
}0
18. Example
View licenseprivate 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;
}0
19. Example
View licensepublic 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);
}0
20. Example
View licensepublic 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);
}
}0
21. Example
View licenseinternal 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;
}0
22. Example
View licenseprivate 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;
}0
23. Example
View licensepublic 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);
}0
24. Example
View licensepublic 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);
}
}0
25. Example
View licenseinternal 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;
}0
26. Example
View licenseprivate 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;
}0
27. Example
View licensepublic 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);
}0
28. Example
View licensepublic 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);
}
}0
29. Example
View licenseinternal 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;
}0
30. Example
View licenseprivate void AddParameter(DbCommand command, string name, object value, DbType type)
{
command.Parameters.Add(GetParameter(command, name, value, type));
}0
31. Example
View licenseprivate static void AddParameter(
DbCommand cmd,
string name,
object value)
{
var parameter = cmd.CreateParameter();
parameter.ParameterName = name;
parameter.Value = value;
cmd.Parameters.Add(parameter);
}0
32. Example
View licensepublic 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);
}0
33. Example
View licenseprotected 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 );
}
}0
34. Example
View licenseprivate 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);
}0
35. Example
View licensepublic 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);
}0
36. Example
View licensepublic 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);
}0
37. Example
View licenseinternal override void AssignParameters(DbCommand cmd, ReadOnlyCollection<SqlParameterInfo> pa/n ..... /n //View Source file for more details /n }
0
38. Example
View licenseinternal override void AssignParameters(DbCommand cmd, ReadOnlyCollection<SqlParameterInfo> pa/n ..... /n //View Source file for more details /n }
0
39. Example
View licensepublic 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);
}0
40. Example
View licensepublic 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;
}0
41. Example
View licensepublic 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;
}0
42. Example
View licensepublic 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);
}0
43. Example
View licensepublic 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);
}0
44. Example
View licenseprivate 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);
}0
45. Example
View licensepublic 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);
}
}0
46. Example
View licensepublic 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);
}0
47. Example
View licensepublic 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);
}0
48. Example
View licensepublic 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);
}0
49. Example
View licensepublic 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);
}0
50. Example
View licensepublic 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;
}