public void TestMethod1()
{
PersonBs test = new PersonBs();
string connectionString = "Data Source=MESKAI-PC;Initial Catalog=Test;Integrated Security=True";
Person p = new Person();
p.Name = "testname";
MsSqlServerConnection con = new MsSqlServerConnection(connectionString, true);
DataManager target = new DataManager(con); // TODO: Initialize to an appropriate value
//test.Insert(p);
}
public void SelectListTest()
{
string connectionString = "Data Source=MESKAI-PC;Initial Catalog=Test;Integrated Security=True";
MsSqlServerConnection connection = new MsSqlServerConnection(connectionString, true);
DataManager manager = new DataManager(connection);
Person p = new Person();
List<Person> liste = new List<Person>();
p.Name = "Can";
liste = manager.SelectObjectList<Person>(p);
Assert.AreEqual(3, liste.Count);
}
public void TransactionTest()
{
MsSqlServerConnection connection = new MsSqlServerConnection(connectionString, true);
DataManager manager = new DataManager(connection);
Person p = new Person();
Person2 p2 = new Person2();
try
{
manager.BeginTransaction();
p.Age = 20;
p.Name = "fatih";
manager.Insert(p);
throw new Exception("test");
p2.Name = "can";
p2.Age = p.PersonID;
manager.Insert(p2);
manager.CommitTransaction();
}
catch (Exception exc)
{
manager.RollbackTransaction();
}
finally
{
Assert.IsNotNull(p2.PersonID);
}
}
public SqlServerDataManager(MsSqlServerConnection conn)
: base(conn)
{
//SchemaValidator.TableValidator = new SqlServerTableValidator(this);//can kapattı
}