Here are the examples of the csharp api class System.Data.Common.DbParameterCollection.Clear() taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.
59 Examples
0
1. Example
View licensepublic static DbCommand ClearParameters(this DbCommand Command)
{
if (Command != null && Command.Parameters != null)
Command.Parameters.Clear();
return Command;
}0
2. Example
View licensepublic static DbCommand ClearParameters(this DbCommand Command)
{
if (Command != null && Command.Parameters != null)
Command.Parameters.Clear();
return Command;
}0
3. Example
View licensepublic DataTable ExecuteDataTable(string commandText, params DbParameter[] parameters)
{
DbCommand cmd =null;
DataTable results;
try
{
results = ExecuteDataTable(out cmd, commandText, parameters);
}
finally
{
cmd.Parameters.Clear();
cmd.Dispose();
}
return results;
}0
4. Example
View licensepublic DataSet ExecuteDataSet(string commandText, params DbParameter[] parameters)
{
DbCommand cmd;
DataSet results = ExecuteDataSet(out cmd, commandText, parameters);
cmd.Parameters.Clear();
cmd.Dispose();
return results;
}0
5. Example
View licensepublic XmlReader ExecuteXmlReader(string commandText, params DbParameter[] parameters)
{
DbCommand cmd;
XmlReader result = ExecuteXmlReader(out cmd, commandText, parameters);
cmd.Parameters.Clear();
cmd.Dispose();
return result;
}0
6. Example
View licenseprivate T Execute<T>(Func<SqlCommand, T> commandToExecute, string commandText, params DbParameter[] parameters)
{
DbCommand cmd = null;
T result;
try
{
result = Execute(commandToExecute, out cmd, commandText, parameters);
}
finally
{
cmd.Parameters.Clear();
cmd.Dispose();
}
return result;
}0
7. Example
View licensepublic int ExecuteNonQuery(string commandText, params DbParameter[] parameters)
{
DbCommand cmd =null;
int rowsAffected = 0;
try
{
rowsAffected = ExecuteNonQuery(out cmd, commandText, parameters);
}
finally
{
cmd.Parameters.Clear();
cmd.Dispose();
}
return rowsAffected;
}0
8. Example
View licensepublic object ExecuteScalar(string commandText, params DbParameter[] parameters)
{
DbCommand cmd;
object result = ExecuteScalar(out cmd, commandText, parameters);
cmd.Parameters.Clear();
cmd.Dispose();
return result;
}0
9. Example
View licensepublic DataTable ExecuteDataTable(string commandText, params DbParameter[] parameters)
{
DbCommand cmd =null;
DataTable results;
try
{
results = ExecuteDataTable(out cmd, commandText, parameters);
}
finally
{
cmd.Parameters.Clear();
cmd.Dispose();
}
return results;
}0
10. Example
View licensepublic DataSet ExecuteDataSet(string commandText, params DbParameter[] parameters)
{
DbCommand cmd;
DataSet results = ExecuteDataSet(out cmd, commandText, parameters);
cmd.Parameters.Clear();
cmd.Dispose();
return results;
}0
11. Example
View licensepublic XmlReader ExecuteXmlReader(string commandText, params DbParameter[] parameters)
{
DbCommand cmd;
XmlReader result = ExecuteXmlReader(out cmd, commandText, parameters);
cmd.Parameters.Clear();
cmd.Dispose();
return result;
}0
12. Example
View licensepublic int ExecuteNonQuery(string storedProcedureName, params DbParameter[] parameters)
{
DbCommand cmd;
int rowsAffected = ExecuteNonQuery(out cmd, storedProcedureName, parameters);
cmd.Parameters.Clear();
cmd.Dispose();
return rowsAffected;
}0
13. Example
View licensepublic object ExecuteScalar(string storedProcedureName, params DbParameter[] parameters)
{
DbCommand cmd;
object result = ExecuteScalar(out cmd, storedProcedureName, parameters);
cmd.Parameters.Clear();
cmd.Dispose();
return result;
}0
14. Example
View licensepublic DataTable ExecuteDataTable(string storedProcedureName, params DbParameter[] parameters)
{
DbCommand cmd;
DataTable results = ExecuteDataTable(out cmd, storedProcedureName, parameters);
cmd.Parameters.Clear();
cmd.Dispose();
return results;
}0
15. Example
View licensepublic DataSet ExecuteDataSet(string storedProcedureName, params DbParameter[] parameters)
{
DbCommand cmd;
DataSet results = ExecuteDataSet(out cmd, storedProcedureName, parameters);
cmd.Parameters.Clear();
cmd.Dispose();
return results;
}0
16. Example
View licensepublic XmlReader ExecuteXmlReader(string storedProcedureName, params DbParameter[] parameters)
{
DbCommand cmd;
XmlReader result = ExecuteXmlReader(out cmd, storedProcedureName, parameters);
cmd.Parameters.Clear();
cmd.Dispose();
return result;
}0
17. 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
18. 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
19. 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
20. 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
21. 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
22. 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
23. Example
View licenseprotected internal void CloseConnection()
{
OnClosingConnection();
Command.Parameters.Clear();
Command.CommandText = string.Empty;
if (Command.Transaction == null)
Command.Connection.Close(); // Only close if no transaction is present
UnbindEvents();
}0
24. Example
View licensepublic virtual void ExpandQueryParameters(DbCommand cmd, SqlString sqlString, SqlType[] parameterTypes)
{
if (UseNamedPrefixInSql)
return; // named parameters are ok
var expandedParameters = new List<DbParameter>();
foreach (object part in sqlString)
{
var parameter = part as Parameter;
if (parameter != null)
{
var index = parameter.ParameterPosition.Value;
var originalParameter = cmd.Parameters[index];
var originalType = parameterTypes[index];
expandedParameters.Add(CloneParameter(cmd, originalParameter, originalType));
}
}
cmd.Parameters.Clear();
foreach (var parameter in expandedParameters)
cmd.Parameters.Add(parameter);
}0
25. Example
View licenseprotected internal void CloseConnection()
{
OnClosingConnection();
Command.Parameters.Clear();
Command.CommandText = string.Empty;
if (Command.Transaction == null)
Command.Connection.Close(); // Only close if no transaction is present
UnbindEvents();
}0
26. Example
View licenseprotected internal void CloseConnection()
{
OnClosingConnection();
Command.Parameters.Clear();
Command.CommandText = string.Empty;
if (Command.Transaction == null)
Command.Connection.Close(); // Only close if no transaction is present
UnbindEvents();
}0
27. Example
View licensepublic int ExecuteNonQuery(IEnumerable<SqlNonQueryCommand> commands)
{
if (commands == null) throw new ArgumentNullException("commands");
using (var dbCommand = _dbConnection.CreateCommand())
{
dbCommand.Connection = _dbConnection;
dbCommand.CommandTimeout = _commandTimeout;
var count = 0;
foreach (var command in commands)
{
dbCommand.CommandType = command.Type;
dbCommand.CommandText = command.Text;
dbCommand.Parameters.Clear();
dbCommand.Parameters.AddRange(command.Parameters);
dbCommand.ExecuteNonQuery();
count++;
}
return count;
}
}0
28. Example
View licensepublic async Task<int> ExecuteNonQueryAsync(IEnumerable<SqlNonQueryCommand> commands, CancellationToken cancellationToken)
{
if (commands == null)
throw new ArgumentNullException("commands");
var count = 0;
using (var dbCommand = _dbConnection.CreateCommand())
{
dbCommand.Connection = _dbConnection;
dbCommand.CommandTimeout = _commandTimeout;
foreach (var command in commands)
{
dbCommand.CommandType = command.Type;
dbCommand.CommandText = command.Text;
dbCommand.Parameters.Clear();
dbCommand.Parameters.AddRange(command.Parameters);
await dbCommand.ExecuteNonQueryAsync(cancellationToken);
count++;
}
}
return count;
}0
29. Example
View licensepublic void ExecuteNonQuery(SqlNonQueryCommand command)
{
if (command == null)
throw new ArgumentNullException("command");
using (var dbCommand = _dbTransaction.Connection.CreateCommand())
{
dbCommand.Connection = _dbTransaction.Connection;
dbCommand.Transaction = _dbTransaction;
dbCommand.CommandTimeout = _commandTimeout;
dbCommand.CommandType = command.Type;
dbCommand.CommandText = command.Text;
dbCommand.Parameters.Clear();
dbCommand.Parameters.AddRange(command.Parameters);
dbCommand.ExecuteNonQuery();
}
}0
30. Example
View licensepublic int ExecuteNonQuery(IEnumerable<SqlNonQueryCommand> commands)
{
if (commands == null)
throw new ArgumentNullException("commands");
var count = 0;
using (var dbCommand = _dbTransaction.Connection.CreateCommand())
{
dbCommand.Connection = _dbTransaction.Connection;
dbCommand.Transaction = _dbTransaction;
dbCommand.CommandTimeout = _commandTimeout;
foreach (var command in commands)
{
dbCommand.CommandType = command.Type;
dbCommand.CommandText = command.Text;
dbCommand.Parameters.Clear();
dbCommand.Parameters.AddRange(command.Parameters);
dbCommand.ExecuteNonQuery();
count++;
}
}
return count;
}0
31. Example
View licensepublic async Task<int> ExecuteNonQueryAsync(IEnumerable<SqlNonQueryCommand> commands, CancellationToken cancellationToken)
{
if (commands == null)
throw new ArgumentNullException("commands");
var count = 0;
using (var dbCommand = _dbTransaction.Connection.CreateCommand())
{
dbCommand.Connection = _dbTransaction.Connection;
dbCommand.Transaction = _dbTransaction;
dbCommand.CommandTimeout = _commandTimeout;
foreach (var command in commands)
{
dbCommand.CommandType = command.Type;
dbCommand.CommandText = command.Text;
dbCommand.Parameters.Clear();
dbCommand.Parameters.AddRange(command.Parameters);
await dbCommand.ExecuteNonQueryAsync(cancellationToken);
count++;
}
}
return count;
}0
32. Example
View licenseprivate void insertFeatureIntoDataTable(Feature feature, DbCommand command)
{
st/n ..... /n //View Source file for more details /n }0
33. Example
View licensepublic static void ParameterizeAndLoadQuery<TParameterType>(String QueryText, DbCommand DbComm/n ..... /n //View Source file for more details /n }
0
34. Example
View licensepublic static void SetParameters(this DbCommand cmd, object parameters) {
cmd.Parameters.Clear();
if (parameters == null)
return;
//if (parameters is IDictionary<string, object>) {
// foreach (var kvp in (IDictionary<string, object>)parameters) {
// AddParameter(cmd, kvp.Key, kvp.Value);
// }
//}
if (parameters is IList) {
var listed = (IList) parameters;
for (var i = 0; i < listed.Count; i++) {
AddParameter(cmd, string.Format("@{0}", i), listed[i]);
}
}
else {
var t = parameters.GetType();
var parameterInfos = t.GetProperties();
foreach (var pi in parameterInfos) {
AddParameter(cmd, pi.Name, pi.GetValue(parameters, null));
}
}
}0
35. Example
View licensepublic int ExecuteNonQuery(IEnumerable<SqlNonQueryCommand> commands)
{
if (commands == null)
throw new ArgumentNullException("commands");
using (var dbConnection = _dbProviderFactory.CreateConnection())
{
dbConnection.ConnectionString = _settings.ConnectionString;
dbConnection.Open();
try
{
using (var dbCommand = dbConnection.CreateCommand())
{
dbCommand.Connection = dbConnection;
dbCommand.CommandTimeout = _commandTimeout;
var count = 0;
foreach (var command in commands)
{
dbCommand.CommandType = command.Type;
dbCommand.CommandText = command.Text;
dbCommand.Parameters.Clear();
dbCommand.Parameters.AddRange(command.Parameters);
dbCommand.ExecuteNonQuery();
count++;
}
return count;
}
}
finally
{
dbConnection.Close();
}
}
}0
36. Example
View licensepublic async Task<int> ExecuteNonQueryAsync(IEnumerable<SqlNonQueryCommand> commands, CancellationToken cancellationToken)
{
if (commands == null) throw new ArgumentNullException("commands");
using (var dbConnection = _dbProviderFactory.CreateConnection())
{
dbConnection.ConnectionString = _settings.ConnectionString;
await dbConnection.OpenAsync(cancellationToken);
try
{
using (var dbCommand = dbConnection.CreateCommand())
{
dbCommand.Connection = dbConnection;
dbCommand.CommandTimeout = _commandTimeout;
var count = 0;
foreach (var command in commands)
{
dbCommand.CommandType = command.Type;
dbCommand.CommandText = command.Text;
dbCommand.Parameters.Clear();
dbCommand.Parameters.AddRange(command.Parameters);
await dbCommand.ExecuteNonQueryAsync(cancellationToken);
count++;
}
return count;
}
}
finally
{
dbConnection.Close();
}
}
}0
37. Example
View licensepublic async Task<object> ExecuteScalarAsync(SqlQueryCommand command, CancellationToken cancellationToken)
{
if (command == null)
throw new ArgumentNullException("command");
using (var dbConnection = _dbProviderFactory.CreateConnection())
{
dbConnection.ConnectionString = _settings.ConnectionString;
await dbConnection.OpenAsync(cancellationToken);
try
{
using (var dbCommand = dbConnection.CreateCommand())
{
dbCommand.Connection = dbConnection;
dbCommand.CommandTimeout = _commandTimeout;
dbCommand.CommandType = command.Type;
dbCommand.CommandText = command.Text;
dbCommand.Parameters.Clear();
dbCommand.Parameters.AddRange(command.Parameters);
return dbCommand.ExecuteScalarAsync(cancellationToken);
}
}
finally
{
dbConnection.Close();
}
}
}0
38. Example
View licenseprivate static async Task<int> ExecuteMultiImplAsync(IDbConnection cnn, CommandDefinition comm/n ..... /n //View Source file for more details /n }
0
39. Example
View licenseprotected virtual void DoDelete<T>(ISpecification<T> specification, DbConnection connect/n ..... /n //View Source file for more details /n }
0
40. Example
View licenseprotected override bool _internal_Write()
{
//Look if the Connection is still op/n ..... /n //View Source file for more details /n }0
41. Example
View licenseprotected override object Execute(
IRelationalConnection connection,
/n ..... /n //View Source file for more details /n }0
42. Example
View licenseprotected virtual int DoGetRecordCount<T>(ISpecification<T> specification, DbConnection /n ..... /n //View Source file for more details /n }
0
43. Example
View licenseprotected virtual void DoInsert<T>(PropertyBag allFields, DbConnection connection, DbTransaction transaction = null)
where T : class, new()
{
if (connection == null)
throw new ArgumentNullException("connection");
if (connection.State != ConnectionState.Open)
throw new ArgumentException(@"The database connection is not in an Open state.", "connection");
var sql = string.Format("INSERT INTO {0} ({1}) VALUES ({2})",
GetTableName<T>(), GetInsertFieldNameList<T>(allFields), GetInsertParameterNameList<T>(allFields));
using (var command = CreateCommand(sql, connection))
{
if (transaction != null)
command.Transaction = transaction;
command.Parameters.Clear();
var parameters = GetInsertDbParameterList<T>(allFields);
foreach (var param in parameters)
{
command.Parameters.Add(param);
}
command.ExecuteNonQuery();
}
}0
44. Example
View licensepublic int ExecuteNonQuery(IEnumerable<SqlNonQueryCommand> commands)
{
if /n ..... /n //View Source file for more details /n }0
45. Example
View licensepublic async Task<int> ExecuteNonQueryAsync(IEnumerable<SqlNonQueryCommand> commands, Ca/n ..... /n //View Source file for more details /n }
0
46. Example
View licenseprivate async Task DoUpdateAsync<TTableObject>(DbConnection connection, DbTransaction transact/n ..... /n //View Source file for more details /n }
0
47. Example
View licenseprotected override async Task<object> ExecuteAsync(
IRelationalConnection /n ..... /n //View Source file for more details /n }0
48. Example
View licenseprotected virtual void DoUpdate<T>(PropertyBag newValues, ISpecification<T> specificatio/n ..... /n //View Source file for more details /n }
0
49. Example
View licenseprotected override bool _internal_Write()
{
//Look if the Connection is still op/n ..... /n //View Source file for more details /n }0
50. Example
View licenseprotected virtual T DoSelectFirstOnly<T>(ISpecification<T> specification, DbConnection c/n ..... /n //View Source file for more details /n }
