public void SqlServerDataSourceTests_CreateFromConnectionStringBuilder()
{
var connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SqlServerTestDatabase"].ConnectionString;
var csb = new SqlConnectionStringBuilder(connectionString);
var dataSource = new SqlServerDataSource("Foo", csb);
Assert.AreEqual("Foo", dataSource.Name);
dataSource.TestConnection();
}
public SqlServerDataSource AttachRules(SqlServerDataSource source)
{
return source.WithRules(
new DateTimeRule("CreatedDate", DateTimeKind.Local, OperationTypes.Insert),
new DateTimeRule("UpdatedDate", DateTimeKind.Local, OperationTypes.InsertOrUpdate),
new UserDataRule("CreatedByKey", "EmployeeKey", OperationTypes.Insert),
new UserDataRule("UpdatedByKey", "EmployeeKey", OperationTypes.InsertOrUpdate),
new ValidateWithValidatable(OperationTypes.InsertOrUpdate)
);
}
static TestBase()
{
foreach (ConnectionStringSettings con in ConfigurationManager.ConnectionStrings)
{
var ds = new SqlServerDataSource(con.Name, con.ConnectionString);
s_DataSources.Add(con.Name, ds);
if (s_PrimaryDataSource == null) s_PrimaryDataSource = ds;
}
}
public static void AssemblyInit(TestContext context)
{
s_DataSource = SqlServerDataSource.CreateFromConfig("CodeFirstModels");
s_DapperRepo = new EmployeeRepositoryDapper(ConfigurationManager.ConnectionStrings["CodeFirstModels"].ConnectionString);
s_ChainRepo = new EmployeeRepositoryChain(SqlServerDataSource.CreateFromConfig("CodeFirstModels"));
s_ChainCompiledRepo = new EmployeeRepositoryChainCompiled(SqlServerDataSource.CreateFromConfig("CodeFirstModels"));
s_EFIntermediateRepo = new EmployeeRepositoryEF_Intermediate();
s_EFIntermediateNoTrackRepo = new EmployeeRepositoryEF_Intermediate_NoTrack();
s_EFNoviceRepo = new EmployeeRepositoryEF_Novice();
if (Warmup)
{
CrudTestCore(s_DapperRepo);
CrudTestCore(s_ChainRepo);
CrudTestCore(s_ChainCompiledRepo);
CrudTestCore(s_EFIntermediateRepo);
CrudTestCore(s_EFIntermediateNoTrackRepo);
CrudTestCore(s_EFNoviceRepo);
}
}
public void SqlServerDataSourceTests_Ctr()
{
var connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SqlServerTestDatabase"].ConnectionString;
var dataSource = new SqlServerDataSource(connectionString);
dataSource.TestConnection();
}
public EmployeeRepositoryChain(SqlServerDataSource dataSource)
{
m_DataSource = dataSource;
}
static DapperReadmeVsChain()
{
//This would be handled by your Dependency Injection framework
s_ConnectionString = ConfigurationManager.ConnectionStrings["CodeFirstModels"].ConnectionString;
s_DataSource = SqlServerDataSource.CreateFromConfig("CodeFirstModels");
}
/// <summary>
/// Creates a new data source with the indicated changes to the settings.
/// </summary>
/// <param name="settings">The new settings to use.</param>
/// <returns></returns>
/// <remarks>The new data source will share the same database metadata cache.</remarks>
public SqlServerDataSource WithSettings(SqlServerDataSourceSettings settings)
{
var mergedSettings = new SqlServerDataSourceSettings()
{
DefaultCommandTimeout = settings?.DefaultCommandTimeout ?? DefaultCommandTimeout,
SuppressGlobalEvents = settings?.SuppressGlobalEvents ?? SuppressGlobalEvents,
StrictMode = settings?.StrictMode ?? StrictMode,
XactAbort = settings?.XactAbort ?? XactAbort,
ArithAbort = settings?.ArithAbort ?? ArithAbort
};
var result = new SqlServerDataSource(Name, m_ConnectionBuilder, mergedSettings, m_DatabaseMetadata, m_Cache, m_ExtensionCache);
result.m_DatabaseMetadata = m_DatabaseMetadata;
result.AuditRules = AuditRules;
result.UserValue = UserValue;
result.ExecutionStarted += (sender, e) => OnExecutionStarted(e);
result.ExecutionFinished += (sender, e) => OnExecutionFinished(e);
result.ExecutionError += (sender, e) => OnExecutionError(e);
result.ExecutionCanceled += (sender, e) => OnExecutionCanceled(e);
return result;
}
static TestBase()
{
s_DataSource = SqlServerDataSource.CreateFromConfig("SqlServerTestDatabase");
s_StrictDataSource = s_DataSource.WithSettings(new SqlServerDataSourceSettings() { StrictMode = true });
}
