In C# VS2008 how to replace new SqlParameter("@values", SqlDbType.SomeType, 1500)) to ("@values", SqlDbType.SomeType, 1500

Answer 1

Read the question that I posted here.

http://stackoverflow.com/questions/2299450/more-efficient-way-of-adding-parameters-to-a-sqlcommand-net

Regardless of how you do it, it will still create a SqlParameter object. It's all about personal preference. The question i posted has a few different ways of doing it.

Answer 2

If you are looking for a simple search/replace, then try

1. Ctrl+Shift+H (Replace in files)
2. Select 'Use regular expressions'
3. Enter this regex in the 'Find what' field: new SqlParameter({.*})
4. Enter this in the 'Replace with' field: \1
5. Hit 'Replace All'

Answer 3

Do a replace all on new SqlParameter( with blank.
Then, do a replace all on ) with blank.

Answer 4

You can write a script that use regular expression to handle the parsing and replacing.