private string GetConnectionString(string fileOrServerOrConnectionString)
{
if(fileOrServerOrConnectionString.IndexOf('=') >= 0)
{
return fileOrServerOrConnectionString;
}
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
if(fileOrServerOrConnectionString.EndsWith(".mdf", StringComparison.OrdinalIgnoreCase))
{
// if just a database file is specified, default to local SqlExpress instance
builder.Add("AttachDBFileName", fileOrServerOrConnectionString);
builder.Add("Server", "localhost\\sqlexpress");
builder.Add("Integrated Security", "SSPI");
builder.Add("User Instance", "true");
builder.Add("MultipleActiveResultSets", "true");
}
else if(fileOrServerOrConnectionString.EndsWith(".sdf", StringComparison.OrdinalIgnoreCase))
{
// A SqlCE database file has been specified
builder.Add("Data Source", fileOrServerOrConnectionString);
}
else
{
builder.Add("Server", fileOrServerOrConnectionString);
builder.Add("Database", _services.Model.DatabaseName);
builder.Add("Integrated Security", "SSPI");
}
return builder.ToString();
}