public void TestInsertOperationWithStringKeySqlServer()
{
var carrier = new Carrier();
using (var tran = new TransactionScope())
{
using (var conn = new SqlConnection(ConnectionStringReader.GetSqlServerConnstring()))
{
var createTableScript = conn.GetScriptBuild().GetCreateTableCommand <Carrier>();
conn.Execute(createTableScript);
conn.Insert <Carrier>(carrier);
conn.Execute("Drop table Carrier");
}
tran.Complete();
}
}
public void TestHanaCreateTableScriptShorts()
{
IScriptBuilder builder = new ScriptHanaBuilder();
var connStr = ConnectionStringReader.GetConnstring("hana");
var conn = new HanaConnection(connStr);
var sql = $@"SELECT
[OUSR].[USER_CODE],
[OUSR].[USERID],
[OUSR].[U_NAME],
[dpto].[Name] as [DepartmentName],
[OUSR].[Department],
[OUSR].[GENDER],
[OUSR].[objType],
[OUSR].[userSign],
[OUSR].[SUPERUSER],
[OUSR].[updateDate]
FROM
[OUSR] left join
[OUDP] [dpto] on [dpto].[Code] = [OUSR].[Department]" .Replace("[", "\"").Replace("]", "\"");
var users = conn.Query <OUSR>(sql);
}
public void TestSelectWithSelectExentions()
{
var carrier = new Carrier();
var createDate = new DateTime(2019, 07, 19);
var updateDate = new DateTime(2019, 07, 25);
using (var tran = new TransactionScope())
{
using (var conn = new SqlConnection(ConnectionStringReader.GetSqlServerConnstring()))
{
var createTableScript = conn.GetScriptBuild().GetCreateTableCommand <Carrier>();
conn.Execute(createTableScript);
conn.Insert <Carrier>(carrier);
var result = conn.Select <Carrier>(c => c.CreateDate > createDate && c.UpdateDate <= updateDate && c.Name == "Teste");
conn.Execute("Drop table Carrier");
}
tran.Complete();
}
}
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]");
}
}
}
public void SapHanaDeleteModel222()
{
var conn = new Sap.Data.Hana.HanaConnection(ConnectionStringReader.GetConnstring("hana"));
var sql = "SELECT * FROM \"@IV_LP_LABELMODEL\"";
var result = conn.Query <LabelModel>(sql);
}