public DbConnection CreateDbConnection(DbConnectionParameters dbConnectionParameters)
{
var connectionStringBuilder = new SqlConnectionStringBuilder
{
DataSource = dbConnectionParameters.DbServerUrl,
InitialCatalog = dbConnectionParameters.DbInstanceName,
IntegratedSecurity = true,
MultipleActiveResultSets = true
};
if (!dbConnectionParameters.IsOsUser)
{
connectionStringBuilder.UserID = dbConnectionParameters.ConnectionUserName;
connectionStringBuilder.Password = dbConnectionParameters.ConnectionUserPassword;
connectionStringBuilder.IntegratedSecurity = false;
}
if (dbConnectionParameters.IsLocalDatabase)
{
connectionStringBuilder.AttachDBFilename = String.Format("{0}\\{1}.mdf", dbConnectionParameters.LocalDbFileCatalog, dbConnectionParameters.DbInstanceName);
}
return new SqlConnection(connectionStringBuilder.ToString());
}
public void CreateDataBase()
{
var contextFactory = new MsSqlDatabaseContextFactory();
var parameters = new DbConnectionParameters
{
DbServerUrl = "(localdb)\\v11.0",
DbInstanceName = "TestCodeFirst",
IsOsUser = true,
ConnectionUserName = "",
ConnectionUserPassword = ""
};
ModelContextBase context = contextFactory.CreateModelContext(contextFactory.CreateDbConnection(parameters));
context.Database.CommandTimeout = 800;
if (context.Database.Exists())
context.Database.Delete();
context.Database.Initialize(false);
}