Difference between Parameters.Add(string, object) and Parameters.AddWithValue

by

There is no difference in terms of functionality. In fact, both do this:

return this.Add(new SqlParameter(parameterName, value));

The reason they deprecated the old one in favor of AddWithValue is to add additional clarity, as well as because the second parameter is object, which makes it not immediately obvious to some people which overload of Add was being called, and they resulted in wildly different behavior.

Take a look at this example:

 SqlCommand command = new SqlCommand();
 command.Parameters.Add("@name", 0);

At first glance, it looks like it is calling the Add(string name, object value) overload, but it isn’t. It’s calling the Add(string name, SqlDbType type) overload! This is because 0 is implicitly convertible to enum types. So these two lines:

 command.Parameters.Add("@name", 0);

and

 command.Parameters.Add("@name", 1);

Actually result in two different methods being called. 1 is not convertible to an enum implicitly, so it chooses the object overload. With 0, it chooses the enum overload.

More Related Contents:

  1. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  2. C# SQL Server – Passing a list to a stored procedure
  3. Passing List to SQL Stored Procedure
  4. Entity Framework – stored procedure return value
  5. C# constructing parameter query SQL – LIKE %
  6. What is passing parameters to SQL and why do I need it?
  7. Oracle Parameters with IN statement?
  8. Add WHERE clauses to SQL dynamically / programmatically
  9. problem using Oracle parameters in SELECT IN
  10. How to pass a null variable to a SQL Stored Procedure from C#.net code
  11. Automated checking of database connection and query in same database [closed]
  12. ‘UserControl’ constructor with parameters in C#
  13. Get return value from stored procedure
  14. Is it necessary to manually close and dispose of SqlDataReader?
  15. MySqlCommand Command.Parameters.Add is obsolete
  16. LINQ to SQL multiple tables left outer join
  17. DropdownList DataSource
  18. How to retrieve data from a SQL Server database in C#?
  19. SQL update statement in C#
  20. Any way to SQLBulkCopy “insert or update if exists”?
  21. thread with multiple parameters
  22. encrypt SQL connectionstring c#
  23. Table name and table field on SqlParameter C#?
  24. How to make LINQ execute a (SQL) LIKE range search
  25. How does C# choose with ambiguity and params
  26. Checking for empty or null JToken in a JObject
  27. SQL/C# – Best method for executing a query
  28. Index (zero based) must be greater than or equal to zero
  29. Issues Doing a String Comparison in LINQ
  30. How do I extract data from a DataTable?

Leave a Comment