public void TestUpdateOperationAnsi()
{
var connection = new MaxDBConnection(ConfigurationManager.ConnectionStrings["maxdb"].ConnectionString);
connection.Open();
var trans = connection.BeginTransaction();
using (var conn = connection)
{
IScriptBuilder builder = conn.GetScriptBuild();
var cliente = new Cliente()
{
Id = 1, Nome = "Moisés", Ativo = true
};
var createTableScript = builder.GetCreateTableCommand <Cliente>();
builder.Execute(createTableScript, conn, trans);
conn.Insert <Cliente>(cliente, true, trans);
cliente.Nome = "Paul";
conn.Update(cliente);
cliente.Nome = "John Lennon";
conn.Execute("drop table \"Cliente\"");
//conn.Execute("drop sequence \"sequence_cliente_id\"");
}
}
public void TestSelectOperationAnsi()
{
var connection = new MaxDBConnection(ConfigurationManager.ConnectionStrings["maxdb"].ConnectionString);
connection.Open();
using (var scope = new TransactionScope())
{
using (var conn = connection)
{
IScriptBuilder builder = conn.GetScriptBuild();
var cliente = new Cliente()
{
Id = 1, Nome = "Moisés", Ativo = true
};
var cliente2 = new Cliente()
{
Id = 2, Nome = "José", Ativo = true
};
var createTableScript = builder.GetCreateTableCommand <Cliente>();
var insertScript1 = builder.GetInsertCommand <Cliente>(cliente, true);
var insertScript2 = builder.GetInsertCommand <Cliente>(cliente2, true);
builder.Execute(createTableScript, conn);
builder.Execute(insertScript1, conn);
builder.Execute(insertScript2, conn);
var clientes = conn.GetAll <Cliente>();
Assert.AreEqual(2, clientes.Count());
Assert.AreEqual("Moisés", clientes.ToList()[0].Nome);
Assert.AreEqual("José", clientes.ToList()[1].Nome);
conn.Execute("drop table \"Cliente\"");
}
}
}