/// <summary>
/// Creates a connection for SQL Server Compact Edition based on the given database name or connection string.
/// If the given string contains an '=' character then it is treated as a full connection string,
/// otherwise it is treated as a database name only.
/// </summary>
/// <param name="nameOrConnectionString"> The database name or connection string. </param>
/// <returns> An initialized DbConnection. </returns>
public DbConnection CreateConnection(string nameOrConnectionString)
{
Check.NotEmpty(nameOrConnectionString, "nameOrConnectionString");
var factory = DbProviderFactories.GetFactory(ProviderInvariantName);
Debug.Assert(factory != null, "Expected DbProviderFactories.GetFactory to throw if provider not found.");
var connection = factory.CreateConnection();
if (connection == null)
{
throw Error.DbContext_ProviderReturnedNullConnection();
}
if (DbHelpers.TreatAsConnectionString(nameOrConnectionString))
{
connection.ConnectionString = nameOrConnectionString;
}
else
{
if (!nameOrConnectionString.EndsWith(".sdf", ignoreCase: true, culture: null))
{
nameOrConnectionString += ".sdf";
}
var dataPath = (DatabaseDirectory.StartsWith("|", StringComparison.Ordinal) &&
DatabaseDirectory.EndsWith("|", StringComparison.Ordinal))
? DatabaseDirectory + nameOrConnectionString
: Path.Combine(DatabaseDirectory, nameOrConnectionString);
connection.ConnectionString = String.Format(
CultureInfo.InvariantCulture, "Data Source={0}; {1}", dataPath, BaseConnectionString);
}
return(connection);
}
private void CloseDatabase_Executed(object sender, ExecutedRoutedEventArgs e)
{
Analysis = null;
Loading = false;
HasAnalysis = false;
DatabaseDirectory.SelectAll();
}
private void NavigateTo_Executed(object sender, ExecutedRoutedEventArgs e)
{
DatabaseDirectory.SetCurrentValue(TextBox.TextProperty, e.Parameter);
DatabaseDirectory.Focus();
DatabaseDirectory.SelectAll();
e.Handled = true;
}
static Services()
{
ApplicationProfileService = new ApplicationProfileService("Mallenom", "FaceRecognizer");
LogDirectory = DefaultLogger.LogDirectory;
LoggingService = new LoggingService(LogDirectory);
DatabaseDirectory = ApplicationProfileService
.LocalMachine
.RegisterDirectory("Database", ApplicationProfileDirectoryUsage.Database);
DatabaseDirectory.EnsureExists();
DatabaseService = new DatabaseService(new SqlServerConnectionFactory(new SqlServerConnectionConfiguration()));
}
private void DatabaseDirectory_SubDirs_PreviewGotKeyboardFocus(object sender, KeyboardFocusChangedEventArgs e)
{
DatabaseDirectory.Focus();
e.Handled = true;
}
