private static string GetConnectionString(string fileOrServerOrConnectionString)
{
if (fileOrServerOrConnectionString.IndexOf('=') >= 0)
{
return(fileOrServerOrConnectionString);
}
var builder = new OleDbConnectionStringBuilder();
if (!fileOrServerOrConnectionString.StartsWith("Provider", StringComparison.OrdinalIgnoreCase) ||
!fileOrServerOrConnectionString.EndsWith(".mdb", StringComparison.OrdinalIgnoreCase))
{
builder.DataSource = fileOrServerOrConnectionString;
builder.Provider = "Microsoft.Jet.OLEDB.4.0";
return(builder.ConnectionString);
}
if (!fileOrServerOrConnectionString.StartsWith("Provider", StringComparison.OrdinalIgnoreCase) ||
!fileOrServerOrConnectionString.EndsWith(".accdb", StringComparison.OrdinalIgnoreCase))
{
builder.DataSource = fileOrServerOrConnectionString;
builder.Provider = "Microsoft.ACE.OLEDB.12.0";
return(builder.ConnectionString);
}
return(fileOrServerOrConnectionString);
}
private static string GetDatabaseName(string connectionString)
{
var builder = new OleDbConnectionStringBuilder(connectionString);
return(builder.DataSource);
}
