Difference Between Add() and AddWithValue() in ASP.NET,STORED PROCEDURE

shyam_oec's Avatar, Join Date: Nov 2007
please explain me what is the main difference between Parameters.Add() method and Parameters.AddWithValue() mathod while using StoredProcedure in ASP.NET using C#.I am using Oracle database.as both of them is used to insert value into database.
urstop's Avatar, Join Date: Oct 2007
You can use any of the methods to add a parameter along with its value, but Add is deprecated because it has a similar overloaded method. So when using Add, you will have to be careful to make sure that the compiler understands that it is a value and not a SQLDBType. So its always better to use AddWithValue method. Check out this link from MSDN for reference.