views:

168

answers:

1

SQL code that connects to different databases
say dbs= a,b,c
Also a big SQL query whose name should be prefixed by database name. So its essentially a string operations on the big query to replace all the above mentioned database names. Whats the most optimal way of writing this in C#

+1  A: 

I don't think your question is very clear but I think you are looking for this:

Use the StringBuilder class for all string operations that include more than 3 strings.

Gerrie Schenck
I used something much simpler. String.Format() and it works like a charm!
Ritesh M Nayak