Avoid using database-specific tokens with stored procedure parameter names. ADO.NET classes for specific providers include code to adjust parameter names as required. This will ease migration existing ADO.NET programs to other DBMSs.
Huh? Can you give a code example please? Are you saying that the following could be written without the @ sign? SqlParameter p_Id = new SqlParameter("@p_Id", SqlDbType.Int);
Paul 11/27/2007 3:17:13 AM
Exactly!
kostya.ly 11/27/2007 11:46:10 AM
Although this tip isn't that helpful, when you are explicitly creating a SqlParameter :)
Sami 12/12/2007 5:55:08 PM
As long as you use interface (IDbDataParameter) to work with instance of SqlParameter class the tip is helpful.
kostya.ly 12/14/2007 8:48:32 PM