public void SqlServer_DDLStatement_DoesntCrash()
{
var repo = new SqlServerIntegrationRepository(GetConnection());
repo.ExecuteAdHocQuery("CREATE DATABASE datafacetestddl");
repo.ExecuteAdHocQuery("DROP DATABASE datafacetestddl");
}
public void SqlServer_ToScalar_Works()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
var repo = new SqlServerIntegrationRepository(GetConnection());
Assert.AreEqual(142, repo.ToScalar());
}
public void SqlServer_ManyManyTransactions_DoesntLeak()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
for (int ii = 0; ii < 1000; ii++) {
var repo = new SqlServerIntegrationRepository(GetConnection());
repo.SprocWithSchema();
}
}
public void SqlServer_ToScalarNull_Works()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
var repo = new SqlServerIntegrationRepository(GetConnection());
Assert.IsNull(repo.ToScalarNull());
}
public void SqlServer_EmptyMultipleResultSets_Work()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
var repo = new SqlServerIntegrationRepository(GetConnection());
var model = repo.EmptyMultipleResultSetModel();
Assert.IsNotNull(model);
}
public void SqlServer_ToFirstOrDefault_WithoutValue_Works()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
var repo = new SqlServerIntegrationRepository(GetConnection());
Assert.IsNull(repo.ToFirstOrDefaultScalar2());
}
public void SqlServer_SprocWithParameter_Works()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
var repo = new SqlServerIntegrationRepository(GetConnection());
Assert.AreEqual(143, repo.SprocWithParameter(143));
}
public void SqlServer_EmptyMultipleResultSets_Work()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
var repo = new SqlServerIntegrationRepository(GetConnection());
var model = repo.EmptyMultipleResultSetModel();
Assert.IsNotNull(model);
}
public void SqlServer_ManyManyTransactions_DoesntLeak()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
for (int ii = 0; ii < 1000; ii++)
{
var repo = new SqlServerIntegrationRepository(GetConnection());
repo.SprocWithSchema();
}
}
public void SqlServer_CommitTransaction_HasSideEffect()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
var repo = new SqlServerIntegrationRepository(GetConnection());
using (var transaction = repo.WithTransaction()) {
repo.SprocWithSideEffect();
transaction.Commit();
}
Assert.AreEqual(1, repo.GetCountOfSideEffects());
}
public void SqlServer_RollbackTransaction_DoesntHaveSideEffect()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
var repo = new SqlServerIntegrationRepository(GetConnection());
using (var transaction = repo.WithTransaction()) {
repo.SprocWithSideEffect();
transaction.Rollback();
}
Assert.AreEqual(0, repo.GetCountOfSideEffects());
}
public void SqlServer_CommitTransaction_HasSideEffect()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
var repo = new SqlServerIntegrationRepository(GetConnection());
using (var transaction = repo.WithTransaction()) {
repo.SprocWithSideEffect();
transaction.Commit();
}
Assert.AreEqual(1, repo.GetCountOfSideEffects());
}
public void SqlServer_MultipleResultSets_Work()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
var repo = new SqlServerIntegrationRepository(GetConnection());
var model = repo.ToMultipleResultSetModel();
Assert.AreEqual(model.ResultSet0.Count, 2);
Assert.AreEqual(model.ResultSet0[0].IntValue, 147);
Assert.AreEqual(model.ResultSet0[1].IntValue, 192);
Assert.AreEqual(model.ResultSet0[0].BoolValue, true);
Assert.AreEqual(model.ResultSet0[1].BoolValue, false);
Assert.AreEqual(model.ResultSet1.Count, 2);
Assert.AreEqual(model.ResultSet1[0].StringValue, "abc");
Assert.AreEqual(model.ResultSet1[1].StringValue, "def");
Assert.AreEqual(model.ResultSet1[0].DateTimeValue, new DateTime(2001, 2, 3));
Assert.AreEqual(model.ResultSet1[1].DateTimeValue, new DateTime(2004, 5, 6));
}
public void SqlServer_MultipleResultSets_Work()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
var repo = new SqlServerIntegrationRepository(GetConnection());
var model = repo.ToMultipleResultSetModel();
Assert.AreEqual(model.ResultSet0.Count, 2);
Assert.AreEqual(model.ResultSet0[0].IntValue, 147);
Assert.AreEqual(model.ResultSet0[1].IntValue, 192);
Assert.AreEqual(model.ResultSet0[0].BoolValue, true);
Assert.AreEqual(model.ResultSet0[1].BoolValue, false);
Assert.AreEqual(model.ResultSet1.Count, 2);
Assert.AreEqual(model.ResultSet1[0].StringValue, "abc");
Assert.AreEqual(model.ResultSet1[1].StringValue, "def");
Assert.AreEqual(model.ResultSet1[0].DateTimeValue, new DateTime(2001, 2, 3));
Assert.AreEqual(model.ResultSet1[1].DateTimeValue, new DateTime(2004, 5, 6));
}
public void SqlServer_SprocWithSchema_Works()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
var repo = new SqlServerIntegrationRepository(GetConnection());
Assert.AreEqual(123, repo.SprocWithSchema());
}
public void SqlServer_ToScalarNull_Works()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
var repo = new SqlServerIntegrationRepository(GetConnection());
Assert.IsNull(repo.ToScalarNull());
}
public void SqlServer_ToScalar_Works()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
var repo = new SqlServerIntegrationRepository(GetConnection());
Assert.AreEqual(142, repo.ToScalar());
}
public void SqlServer_DDLStatement_DoesntCrash()
{
var repo = new SqlServerIntegrationRepository(GetConnection());
repo.ExecuteAdHocQuery("CREATE DATABASE datafacetestddl");
repo.ExecuteAdHocQuery("DROP DATABASE datafacetestddl");
}
public void SqlServer_RollbackTransaction_DoesntHaveSideEffect()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
var repo = new SqlServerIntegrationRepository(GetConnection());
using (var transaction = repo.WithTransaction()) {
repo.SprocWithSideEffect();
transaction.Rollback();
}
Assert.AreEqual(0, repo.GetCountOfSideEffects());
}
public void SqlServer_ToFirstOrDefault_WithValue_Works()
{
IDatabaseConnection connection = GetConnection();
InitializeDatabase(connection);
var repo = new SqlServerIntegrationRepository(GetConnection());
Assert.AreEqual(1, repo.ToFirstOrDefaultScalar1());
}