Is it necessary to add a @ in front of an SqlParameter name?

by

According to the documentation, the name must start with an @:

The ParameterName is specified in the form @paramname.

According to the source code (have a look at SqlCommand and SqlParameter.ParameterNameFixed in the reference source), an @ is added automatically, if needed.

So yes, it works, but it’s an undocumented feature. Best practice recommends that you do not rely on this and manually prefix your parameter name with an @.

More Related Contents:

  1. How can I query for null values in entity framework?
  2. How to loop through all the properties of a class?
  3. Case insensitive string compare in LINQ-to-SQL
  4. Does XSLT have a Split() function?
  5. Pick unique Random numbers
  6. Update primary key value using entity framework
  7. Difference with Parameters.Add and Parameters.AddWithValue
  8. Can I set Option Explicit and Option Strict on a Project/Solution level?
  9. Mixed mode assembly is built against version ‘v2.0.50727′ of the runtime
  10. Controlling Application’s Volume: By Process-ID
  11. How do I validate email address formatting with the .NET Framework?
  12. Does this code prevent SQL injection?
  13. Option Strict On and .NET for VB6 programmers
  14. RestSharp serialization to JSON, object is not using SerializeAs attribute as expected
  15. How to print datagridview table with its header in vb.net?
  16. How to draw a signature and save it to disc as a Bitmap?
  17. Correct way to escape characters in a DataTable Filter Expression
  18. How to convert date format in vb.net?
  19. Redirect Trace output to Console
  20. How to make a Windows Forms .NET application display as tray icon?
  21. LinqToSql declare and instantiate DataContext best practice?
  22. Assigning a value to ComboBox Items
  23. Should I always use the AndAlso and OrElse operators?
  24. Is there a way to define an implicit conversion operator in VB.NET?
  25. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  26. Do you think it’s advantageous to switch to Entity Framework? [closed]
  27. .NET — Textbox control – wait till user is done typing
  28. How to post a file via HTTP post in vb.net
  29. How to securely store a connection string in a WinForms application?
  30. How to serialize a large graph of .NET objects into a SQL Server BLOB without creating a large buffer?

Leave a Comment