public void TestDatabaseConnectionSharing()
{
var mapper = MapBuilder <State> .BuildAllProperties();
const string SQL = "SELECT * FROM State s WHERE s.Name = @Name";
var dal = new SimpleNet.Data.Repository.SimpleDataAccess("Simple");
using (var connection = dal.GetConnection())
{
var alabama = dal.Read(connection, mapper, SQL, CommandType.Text, new[]
{
dal.GetDbParameter("@Name", "Alabama")
}).FirstOrDefault();
Assert.IsNotNull(alabama);
Assert.IsTrue(alabama.Name.Equals("Alabama"));
var georgia = dal.Read(connection, mapper, SQL, CommandType.Text, new[]
{
dal.GetDbParameter("@Name", "georgia")
}).FirstOrDefault();
Assert.IsNotNull(georgia);
Assert.IsTrue(georgia.Name.Equals("Georgia"));
}
}
public void TestDatabaseConnectionSharing()
{
var mapper = MapBuilder<State>.BuildAllProperties();
const string SQL = "SELECT * FROM State s WHERE s.Name = @Name";
var dal = new SimpleNet.Data.Repository.SimpleDataAccess("Simple");
using (var connection = dal.GetConnection())
{
var alabama = dal.Read(connection, mapper, SQL, CommandType.Text, new[]
{
dal.GetDbParameter("@Name", "Alabama")
}).FirstOrDefault();
Assert.IsNotNull(alabama);
Assert.IsTrue(alabama.Name.Equals("Alabama"));
var georgia = dal.Read(connection, mapper, SQL, CommandType.Text, new[]
{
dal.GetDbParameter("@Name", "georgia")
}).FirstOrDefault();
Assert.IsNotNull(georgia);
Assert.IsTrue(georgia.Name.Equals("Georgia"));
}
}
public void TestTransaction()
{
var mapper = MapBuilder<State>.BuildAllProperties();
const string SQL = "SELECT * FROM State s WHERE s.Name = @Name";
var dal = new SimpleNet.Data.Repository.SimpleDataAccess("Simple");
using (var connection = dal.GetConnection())
{
using (var transaction = connection.BeginTransaction())
{
var alabama = dal.Read(connection, mapper, SQL, CommandType.Text, new[]
{
dal.GetDbParameter("@Name", "Alabama")
}, transaction).FirstOrDefault();
Assert.IsNotNull(alabama);
Assert.IsTrue(alabama.Name.Equals("Alabama"));
dal.ExecuteNonQuery(connection,
"UPDATE STATE Set Name = @Name WHERE Id=@Id",
CommandType.Text,
new[]
{
dal.GetDbParameter("@Name", "Alabama2"),
dal.GetDbParameter("@Id", alabama.Id)
},
transaction);
var alabama2 = dal.Read(connection, mapper, SQL, CommandType.Text, new[]
{
dal.GetDbParameter("@Name", "Alabama2")
}, transaction).FirstOrDefault();
Assert.IsNotNull(alabama2);
Assert.IsTrue(alabama2.Name.Equals("Alabama2"));
// Roll back the transaction
transaction.Rollback();
alabama = dal.Read(connection, mapper, SQL, CommandType.Text, new[]
{
dal.GetDbParameter("@Name", "Alabama")
}, transaction).FirstOrDefault();
Assert.IsNotNull(alabama);
Assert.IsTrue(alabama.Name.Equals("Alabama"));
}
}
}
public void TestTransaction()
{
var mapper = MapBuilder <State> .BuildAllProperties();
const string SQL = "SELECT * FROM State s WHERE s.Name = @Name";
var dal = new SimpleNet.Data.Repository.SimpleDataAccess("Simple");
using (var connection = dal.GetConnection())
{
using (var transaction = connection.BeginTransaction())
{
var alabama = dal.Read(connection, mapper, SQL, CommandType.Text, new[]
{
dal.GetDbParameter("@Name", "Alabama")
}, transaction).FirstOrDefault();
Assert.IsNotNull(alabama);
Assert.IsTrue(alabama.Name.Equals("Alabama"));
dal.ExecuteNonQuery(connection,
"UPDATE STATE Set Name = @Name WHERE Id=@Id",
CommandType.Text,
new[]
{
dal.GetDbParameter("@Name", "Alabama2"),
dal.GetDbParameter("@Id", alabama.Id)
},
transaction);
var alabama2 = dal.Read(connection, mapper, SQL, CommandType.Text, new[]
{
dal.GetDbParameter("@Name", "Alabama2")
}, transaction).FirstOrDefault();
Assert.IsNotNull(alabama2);
Assert.IsTrue(alabama2.Name.Equals("Alabama2"));
// Roll back the transaction
transaction.Rollback();
alabama = dal.Read(connection, mapper, SQL, CommandType.Text, new[]
{
dal.GetDbParameter("@Name", "Alabama")
}, transaction).FirstOrDefault();
Assert.IsNotNull(alabama);
Assert.IsTrue(alabama.Name.Equals("Alabama"));
}
}
}