public void TestUpdateOperationWithDatetimeSqlServer()
{
var connection = new SqlConnection(ConnectionStringReader.GetSqlServerConnstring());
connection.Open();
using (var transaction = new TransactionScope())
{
IScriptBuilder builder = new ScriptSqlServerBuilder();
var doc = new Doc()
{
DocDate = new DateTime(2019, 02, 15, 23, 29, 29), Value = 1000
};
var createTableScript = builder.GetCreateTableCommand <Doc>();
builder.Execute(createTableScript, connection);
var lastId = connection.Insert <Doc>(doc);
doc.Value = 2000;
connection.Update <Doc>(doc);
var docFromDatabase = connection.Select <Doc>(c => c.Id == 1).FirstOrDefault();
Assert.AreEqual(2000, docFromDatabase.Value);
connection.Execute("drop table [Doc]");
transaction.Complete();
}
}
public void TestInsertOperationWithDatetimeSqlServer()
{
var connection = new SqlConnection(ConnectionStringReader.GetSqlServerConnstring());
connection.Open();
using (var conn = new SqlConnection(ConnectionStringReader.GetSqlServerConnstring()))
{
conn.Open();
var trans = conn.BeginTransaction();
IScriptBuilder builder = new ScriptSqlServerBuilder();
var doc = new Doc()
{
DocDate = new DateTime(2019, 02, 15, 23, 29, 29), Value = 1000
};
var createTableScript = builder.GetCreateTableCommand <Doc>();
builder.Execute(createTableScript, conn, trans);
var lastId = conn.InsertReturningId <Doc>(doc, trans);
Assert.AreEqual(1, lastId);
trans.Rollback();
}
}
public void TestInsertOperationSqlServerNoEntityKey()
{
var connection = new SqlConnection(ConnectionStringReader.GetSqlServerConnstring());
connection.Open();
var trans = connection.BeginTransaction();
using (var conn = connection)
{
IScriptBuilder builder = new ScriptSqlServerBuilder();
var conta = new ContaContabil()
{
Chave = "1.1", Name = "Ativo imobilizado"
};
var createTableScript = builder.GetCreateTableCommand <ContaContabil>();
builder.Execute(createTableScript, conn, trans);
conn.Insert <ContaContabil>(conta, false, trans);
Assert.AreEqual("1.1", conta.Chave);
trans.Rollback();
}
}
public void TestInsertOperationSqlServer()
{
var connection = new SqlConnection(ConnectionStringReader.GetSqlServerConnstring());
connection.Open();
var trans = connection.BeginTransaction();
using (var conn = connection)
{
IScriptBuilder builder = new ScriptSqlServerBuilder();
var cliente = new Cliente()
{
Id = 1, Nome = "Moisés", Ativo = true
};
var createTableScript = builder.GetCreateTableCommand <Cliente>();
builder.Execute(createTableScript, conn, trans);
var lastId = conn.InsertReturningId <Cliente>(cliente, trans);
Assert.AreEqual(1, lastId);
trans.Rollback();
}
}
public void TestSelectWithWherePrimitiveTypesSqlServer()
{
var connection = new SqlConnection(ConnectionStringReader.GetSqlServerConnstring());
connection.Open();
using (var scope = new TransactionScope())
{
using (var conn = connection)
{
IScriptBuilder builder = new ScriptSqlServerBuilder();
User user = new User()
{
Name = "Moisés", Email = "*****@*****.**", Ratting = 10, Scores = 20
};
User user2 = new User()
{
Name = "Miranda", Email = "*****@*****.**", Ratting = 20, Scores = 50
};
User user3 = new User()
{
Name = "Moshe", Email = "*****@*****.**", Ratting = 20, Scores = 21, System = true
};
var createTableScript = builder.GetCreateTableCommand <User>();
builder.Execute(createTableScript, conn);
conn.Insert(user);
conn.Insert(user2);
conn.Insert(user3);
var userFirst = conn.Select <User>(c => c.Email == user.Email);
var userSecond = conn.Select <User>(c => c.Id == 2);
var userThird = conn.Select <User>(c => c.System == true);
var noSystem = conn.Select <User>(c => c.System == false);
var userRatting20 = conn.Select <User>(c => c.Ratting == 20);
var usersScore21 = conn.Select <User>(c => c.Scores == 21);
Assert.AreEqual(1, userFirst.Count());
Assert.AreEqual("Miranda", userSecond.ToList()[0].Name);
Assert.AreEqual("Moshe", userThird.ToList()[0].Name);
Assert.AreEqual(2, noSystem.Count());
Assert.AreEqual(2, userRatting20.Count());
Assert.AreEqual("Moshe", usersScore21.ToList()[0].Name);
conn.Execute("drop table [User]");
conn.Close();
}
}
}
public void TestSelectOperationSqlServer()
{
var connection = new SqlConnection(ConnectionStringReader.GetSqlServerConnstring());
connection.Open();
using (var scope = new TransactionScope())
{
using (var conn = connection)
{
IScriptBuilder builder = new ScriptSqlServerBuilder();
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);
var insertScript2 = builder.GetInsertCommand <Cliente>(cliente2);
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]");
}
}
}