Here are the examples of the csharp api class System.Data.Common.DbCommand.CreateParameter() taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.
116 Examples
0
1. Example
View licenseprotected override DbParameter CreateDbParameter() { return InnerCommand.CreateParameter(); }0
2. Example
View licenseprotected override DbParameter CreateDbParameter()
{
return InnerCommand.CreateParameter();
}0
3. Example
View licensepublic static DbParameter CreateParameter( this DbCommand dbCommand, string parameterName, object parameterValue )
{
DbParameter parameter = dbCommand.CreateParameter();
parameter.ParameterName = parameterName;
parameter.Value = parameterValue;
return parameter;
}0
4. Example
View licensepublic static DbParameter CreateParameter( this DbCommand dbCommand, string parameterName, object parameterValue, DbType dbType )
{
DbParameter parameter = dbCommand.CreateParameter();
parameter.ParameterName = parameterName;
parameter.Value = parameterValue;
parameter.DbType = dbType;
return parameter;
}0
5. Example
View licensepublic static DbParameter CreateParameter( this DbCommand dbCommand, string parameterName, object parameterValue, DbType dbType, ParameterDirection parameterDirection )
{
DbParameter parameter = dbCommand.CreateParameter();
parameter.ParameterName = parameterName;
parameter.Value = parameterValue;
parameter.DbType = dbType;
parameter.Direction = parameterDirection;
return parameter;
}0
6. Example
View licenseprivate DbParameter GetParameter(DbCommand command, string name, object value, DbType type)
{
var parameter = command.CreateParameter();
parameter.DbType = type;
parameter.ParameterName = (_databaseType.Equals(DatabaseType.Oracle) ? ":" : "@") + name;
parameter.Value = value;
return parameter;
}0
7. Example
View licenseprotected override DbParameter CreateDbParameter()
{
return _command.CreateParameter();
}0
8. Example
View licenseprotected override DbParameter CreateDbParameter()
{
return source.CreateParameter();
}0
9. Example
View licenseprotected override DbParameter CreateDbParameter()
{
return source.CreateParameter();
}0
10. Example
View licenseprotected override DbParameter CreateDbParameter()
{
return _cmd.CreateParameter();
}0
11. Example
View licenseprotected override DbParameter CreateDbParameter()
{
return _command.CreateParameter();
}0
12. Example
View licenseprotected override DbParameter CreateDbParameter()
{
return this.wrappedCommand.CreateParameter();
}0
13. Example
View licenseprotected override DbParameter CreateDbParameter()
{
return InternalCommand.CreateParameter();
}0
14. 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
15. 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
16. 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
17. Example
View licenseprotected override DbParameter CreateDbParameter()
{
if (_dbCommand != null)
{
return _dbCommand.CreateParameter();
}
return new DbParameterWrapper(_command.CreateParameter());
}0
18. 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
19. 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
20. 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
21. 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
22. 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
23. Example
View licenseinternal override void AssignParameters(DbCommand cmd, ReadOnlyCollection<SqlParameterInfo> pa/n ..... /n //View Source file for more details /n }
0
24. Example
View licenseinternal override void AssignParameters(DbCommand cmd, ReadOnlyCollection<SqlParameterInfo> pa/n ..... /n //View Source file for more details /n }
0
25. 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
26. Example
View licensepublic DbParameter GenerateParameter(DbCommand command, string name, SqlType sqlType)
{
var dbParam = command.CreateParameter();
InitializeParameter(dbParam, name, sqlType);
return dbParam;
}0
27. 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
28. 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
29. 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
30. Example
View licensepublic 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);
}0
31. Example
View licensepublic 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;
}0
32. Example
View licensepublic 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;
}0
33. Example
View licenseprivate IDbCommand CreateNew()
{
var conn = new TConnection { ConnectionString = _template.Connection.ConnectionString };
var newItem = conn.CreateCommand();
newItem.CommandText = _template.CommandText;
foreach (IDbDataParameter parameter in _template.Parameters)
{
IDbDataParameter pNew = newItem.CreateParameter();
pNew.DbType = parameter.DbType;
pNew.Direction = parameter.Direction;
//pNew.IsNullable = parameter.IsNullable;
pNew.ParameterName = parameter.ParameterName;
pNew.Precision = parameter.Precision;
pNew.Scale = parameter.Scale;
pNew.Size = parameter.Size;
pNew.SourceColumn = parameter.SourceColumn;
#if !(SILVERLIGHT || WINDOWS_PHONE)
pNew.SourceVersion = parameter.SourceVersion;
#endif
//pNew.Value = ()parameter.Value.
newItem.Parameters.Add(pNew);
}
_maxStore++;
return newItem;
}0
34. Example
View license[Fact]
public void UsingUInt64AsParam()
{
if (st.Version < new Version(5, 0)) return;
st.execSQL(@"CREATE TABLE Test(f1 bigint(20) unsigned NOT NULL,
PRIMARY KEY(f1)) ENGINE=InnoDB DEFAULT CHARSET=utf8");
st.execSQL(@"CREATE PROCEDURE spTest(in _val bigint unsigned)
BEGIN insert into Test set f1=_val; END");
#if RT
MySqlCommand cmd = new MySqlCommand();
MySqlParameter param = cmd.CreateParameter();
param.MySqlDbType = MySqlDbType.UInt64;
#else
DbCommand cmd = new MySqlCommand();
DbParameter param = cmd.CreateParameter();
param.DbType = DbType.UInt64;
#endif
cmd.Connection = st.conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spTest";
param.Direction = ParameterDirection.Input;
param.ParameterName = "?_val";
ulong bigval = long.MaxValue;
bigval += 1000;
param.Value = bigval;
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();
}0
35. Example
View licensepublic virtual DbParameter CreateParameter()
{
return Provider?.CreateParameter() ?? Connection.CreateCommand().CreateParameter();
}0
36. Example
View licenseprotected override DbCommand BuildCommand<T>(String commandText, T src)
{
var command = createCommand();
command.CommandText = commandText;
command.CommandType = CommandType.Text;
if (null != src)
{
var type = typeof(T);
foreach (var pinfo in getColumns(type))
{
var p = command.CreateParameter();
p.ParameterName = "@" + pinfo.Name;
p.Value = pinfo.GetValue(src, null);
command.Parameters.Add(p);
}
}
return command;
}0
37. Example
View licensepublic virtual int FindCountWithPostalCodeWithDelegate(string postalCode)
{
// Using anonymous delegates allows you to easily reference the
// surrounding parameters for use with the DbCommand processing.
return AdoTemplate.Execute<int>(delegate(DbCommand command)
{
// Do whatever you like with the DbCommand... downcast to get
// provider specific funtionality if necesary.
command.CommandText = cmdText;
DbParameter p = command.CreateParameter();
p.ParameterName = "@PostalCode";
p.Value = postalCode;
command.Parameters.Add(p);
return (int)command.ExecuteScalar();
});
}0
38. Example
View licensepublic T DoInCommand(DbCommand command)
{
T resultObject = new T();
DbParameter p = command.CreateParameter();
p.ParameterName = "@PostalCode";
p.Value = postalCode;
command.Parameters.Add(p);
resultObject.count = (int)command.ExecuteScalar();
return resultObject;
}0
39. Example
View licensepublic static void SetParameter(this DbCommand command, string name, object value)
{
if (command == null) throw new ArgumentNullException("command");
if (string.IsNullOrWhiteSpace(name)) throw new ArgumentNullException("name");
var parameter = command.CreateParameter();
parameter.ParameterName = name;
if (value == null)
{
parameter.Value = DBNull.Value;
}
else if (value is TimeSpan)
{
parameter.Value = (long) ((TimeSpan) value).TotalMilliseconds;
}
else
{
parameter.Value = value;
}
command.Parameters.Add(parameter);
}0
40. Example
View licenseDbCommand CreateReadCommand(DbConnection connection)
{
var cmd = connection.CreateCommand();
cmd.CommandText = "SELECT id, randomnumber FROM world WHERE id = @Id";
var id = cmd.CreateParameter();
id.ParameterName = "@Id";
id.DbType = DbType.Int32;
id.Value = _random.Next(1, 10001);
cmd.Parameters.Add(id);
return cmd;
}0
41. Example
View licenseprivate DbCommand PrepareCommand(Statement statement)
{
DbCommand command = m_Da/n ..... /n //View Source file for more details /n }0
42. Example
View licensepublic void CreateDbParameters(DbCommand command, IEnumerable<String> parameterNames)
{
int parameterCount = 0;
command.Parameters.Clear();
foreach (string parameterName in parameterNames)
{
if (m_style == ParameterStyle.Positional)
{
DbParameter paramObj = command.CreateParameter();
command.Parameters.Add(paramObj);
}
else if (m_style == ParameterStyle.Named)
{
DbParameter paramObj = command.CreateParameter();
paramObj.ParameterName = GetNamedParameter(parameterCount++);
command.Parameters.Add(paramObj);
}
}
}0
43. Example
View licensepublic void CreateDbParameters( DbCommand command, IEnumerable<PlaceholderParser.Fragment> parseFragments )
{
int parameterCount = 0;
command.Parameters.Clear();
foreach (PlaceholderParser.Fragment fragment in parseFragments)
{
if (!fragment.IsParameter)
{
}
else if (m_style == ParameterStyle.Positional)
{
DbParameter paramObj = command.CreateParameter();
command.Parameters.Add(paramObj);
}
else if (m_style == ParameterStyle.Named)
{
DbParameter paramObj = command.CreateParameter();
paramObj.ParameterName = GetNamedParameter(parameterCount++);
command.Parameters.Add(paramObj);
}
}
}0
44. Example
View licenseprivate DbCommand CreateCommand(DbConnection dbConnection, bool honorTimeout)
{
DbCommand myCommand;
// Create the command
myCommand = dbConnection.CreateCommand();
myCommand.CommandType = CommandType.Text;
myCommand.CommandText = _dbCommandText;
if (_dbCommandTimeout.HasValue && honorTimeout) {
myCommand.CommandTimeout = _dbCommandTimeout.Value;
}
// Bind the parameters
myCommand.Parameters.Clear();
foreach (string parameterName in _inputParameters)
{
DbParameter myParam = myCommand.CreateParameter();
myParam.IsNullable = true;
myParam.ParameterName = parameterName;
myCommand.Parameters.Add(myParam);
}
return myCommand;
}0
45. Example
View licensepublic void CreateDbParameters(DbCommand command, IEnumerable<String> parameterNames)
{
int parameterCount = 0;
command.Parameters.Clear();
foreach (string parameterName in parameterNames)
{
if (m_style == ParameterStyle.Positional)
{
DbParameter paramObj = command.CreateParameter();
command.Parameters.Add(paramObj);
}
else if (m_style == ParameterStyle.Named)
{
DbParameter paramObj = command.CreateParameter();
paramObj.ParameterName = GetNamedParameter(parameterCount++);
command.Parameters.Add(paramObj);
}
}
}0
46. Example
View licensepublic void CreateDbParameters( DbCommand command, IEnumerable<PlaceholderParser.Fragment> parseFragments )
{
int parameterCount = 0;
command.Parameters.Clear();
foreach (PlaceholderParser.Fragment fragment in parseFragments)
{
if (!fragment.IsParameter)
{
}
else if (m_style == ParameterStyle.Positional)
{
DbParameter paramObj = command.CreateParameter();
command.Parameters.Add(paramObj);
}
else if (m_style == ParameterStyle.Named)
{
DbParameter paramObj = command.CreateParameter();
paramObj.ParameterName = GetNamedParameter(parameterCount++);
command.Parameters.Add(paramObj);
}
}
}0
47. Example
View licenseprivate DbCommand CreateCommand(DbConnection dbConnection, bool honorTimeout)
{
DbCommand myCommand;
// Create the command
myCommand = dbConnection.CreateCommand();
myCommand.CommandType = CommandType.Text;
myCommand.CommandText = _dbCommandText;
if (_dbCommandTimeout.HasValue && honorTimeout) {
myCommand.CommandTimeout = _dbCommandTimeout.Value;
}
// Bind the parameters
myCommand.Parameters.Clear();
foreach (string parameterName in _inputParameters)
{
DbParameter myParam = myCommand.CreateParameter();
myParam.IsNullable = true;
myParam.ParameterName = parameterName;
myCommand.Parameters.Add(myParam);
}
return myCommand;
}0
48. Example
View licenseList<ForeignKey> LoadFKeys(string tblSchema, string tblName)
{
using (var /n ..... /n //View Source file for more details /n }0
49. Example
View licensepublic virtual void ExecuteStoredProcedure( string storedProcedureName, IList<CommandParameter> parameters )
{
using( DbCommand command = connection.CreateCommand() )
{
command.CommandText = storedProcedureName;
command.CommandType = CommandType.StoredProcedure;
command.Transaction = this.transaction;
command.CommandTimeout = this.CommandTimeout;
if( parameters != null && parameters.Count > 0 )
{
foreach( var item in parameters )
{
DbParameter parameter = command.CreateParameter();
parameter.ParameterName = item.ParameterName;
parameter.Size = item.Size;
parameter.Direction = item.Direction;
parameter.Value = item.Value;
command.Parameters.Add( parameter );
}
}
command.ExecuteNonQuery();
}
}0
50. Example
View licenseprivate DbCommand CreateCommand(DbConnection connection, string sql, IReadOnlyList<Parameter> parameters)
{
var command = connection.CreateCommand();
command.CommandText = sql;
foreach (var parameter in parameters)
{
var dbParameter = command.CreateParameter();
this.PopulateParameter(dbParameter, parameter);
command.Parameters.Add(dbParameter);
}
return command;
}