Smart Paster Visual Studio Addin
Pete and I were working on a project this afternoon, and it involved building queries in Sql Server Query Analyzer, then copying them over into our code.
As you can imagine, the process of pasting a multi-line query into our code then converting it to a multi-line literal string was quite a chore, so I decided to go looking for a way to speed it up.
Before long I found Alex Papadimoulis' Smart Paster addin for Visual Studio. It lets you paste the clipboard contents in a variety of formats, including a literal string. You can even define whether you want carriage returns and indentation preserved in the string! This was a real time saver, so go grab it if you find yourself repeating that tiresome "insert quotes and plus-signs" chore.
One addition I'd like to see: The ability to specify whether the plus-signs appear at the end or beginning of the lines. Alex seems to prefer that they appear at the end, whereas I like 'em at the begining of the subsequent line.
Comments
# Kevin
20/04/2006 11:04 PM
I realize this is not the point of your post but by why aren't you using stored procedures? :)
# Dave Burke
21/04/2006 4:25 AM
Smart PASTER, oh, I thought you meant smart PASTOR and that the Addin quoted Bible verses or something. Now we could use something like that, don't ya think?
# mabster
21/04/2006 6:55 AM
G'day Kevin,
We will eventually move to stored procs - this is just a preliminary run where we want to get the thing working with queries. When we're happy with what we've got we'll see about moving the queries into SPs.
One of the databases, though, is a third-party db that I don't wanna touch, so even if we do move to SPs, it would have to be in a new database, so that's a bit ugly.
Dave: Sceppa's "ADO.NET Core Reference" is my bible, and I quote verses from that all the time! ;)