protected DataAccessModelConfiguration CreateSqlServerConfiguration(string databaseName)
{
DataAccessModelConfiguration retval;
var connectionString = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER_CONNECTIONSTRING");
if (connectionString == null)
{
var host = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER_HOST") ?? ".\\SQLEXPRESS";
var userName = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER_USERNAME");
var password = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER_PASSWORD");
retval = SqlServerConfiguration.Create(databaseName, host, userName: userName, password: password, multipleActiveResultsets: true);
}
else
{
retval = SqlServerConfiguration.Create(connectionString);
}
retval.AlwaysSubmitDefaultValues = this.alwaysSubmitDefaultValues;
retval.ValueTypesAutoImplicitDefault = this.valueTypesAutoImplicitDefault;
retval.SaveAndReuseGeneratedAssemblies = true;
retval.SqlDatabaseContextInfos[0].SqlDataTypes = new List <Type> {
typeof(SqlFixedDateDataType)
};
return(retval);
}
protected DataAccessModelConfiguration CreateSqlServerConfiguration(string databaseName)
{
DataAccessModelConfiguration retval;
var databaseRegex = new Regex(@"(?:(?:Initial Catalog)|(?:Database))\s*=\s*([^;$]+)[;$]", RegexOptions.IgnoreCase);
var connectionString = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER_CONNECTIONSTRING");
if (connectionString == null)
{
var host = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER_HOST") ?? ".\\SQLEXPRESS";
var userName = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER_USERNAME");
var password = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER_PASSWORD");
retval = SqlServerConfiguration.Create(databaseName, host, userName: userName, password: password, multipleActiveResultsets: true);
}
else
{
if (!databaseRegex.IsMatch(connectionString))
{
connectionString = $"Database={databaseName};{connectionString}";
}
else
{
connectionString = databaseRegex.Replace(connectionString, $"Database={databaseName};");
}
retval = SqlServerConfiguration.Create(connectionString);
}
retval.AlwaysSubmitDefaultValues = this.alwaysSubmitDefaultValues;
retval.ValueTypesAutoImplicitDefault = this.valueTypesAutoImplicitDefault;
retval.SaveAndReuseGeneratedAssemblies = true;
retval.SqlDatabaseContextInfos[0].SqlDataTypes = new List <Type> {
typeof(SqlFixedDateDataType)
};
return(retval);
}
protected DataAccessModelConfiguration CreateSqlServerConfiguration(string databaseName)
{
return(SqlServerConfiguration.Create(databaseName, "localhost", null, null));
}
protected DataAccessModelConfiguration CreateSqlServerConfiguration(string databaseName)
{
return(SqlServerConfiguration.Create(databaseName, "localhost", multipleActiveResultsets: true));
}
protected DataAccessModelConfiguration CreateSqlServerConfiguration(string databaseName)
{
var host = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER") ?? ".\\SQLEXPRESS";
return SqlServerConfiguration.Create(databaseName, host, multipleActiveResultsets: true, deleteDatabaseDropsTablesOnly:true);
}
