|
using System;
using System.Text;
namespace AlterCollation
{
class Utils
{
private Utils()
{
}
/// <summary>
/// build up a connection string for given some connection parameters
/// </summary>
/// <param name="server"></param>
/// <param name="userId"></param>
/// <param name="password"></param>
/// <returns></returns>
public static string ConnectionString(string server, string userId, string password)
{
if (userId == null || userId.Length == 0)
return string.Format("Data Source={0};Trusted_Connection=SSPI;Initial Catalog=master;Application Name=CSL Change Collation;Connect Timeout=5;Pooling=false;", server);
else
return string.Format("Application Name={1};Connect Timeout=8;Persist Security Info=False;Database=master;User ID={2};Password={3};Data Source={0};Connect Timeout=5;Pooling=false;", server, "Collation Changer", userId, password);
}
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.