public void ExecuteSqlGetObject()
{
string sql = "select * from Aluno where alunoID=@alunoID";
List <Parameter> parameters = new List <Parameter>();
SqlAndParameters sqlParameters = new SqlAndParameters();
Aluno aluno = new Aluno();
parameters.Add(new Parameter {
ParameterKey = "@alunoID", ParameterValue = 1
});
sqlParameters.Sql = sql;
sqlParameters.Parameter = parameters;
aluno = queryBuilder.ExecuteSqlGetObject <Aluno>(sqlParameters);
Assert.IsTrue(true);
}
public void ODBC_ExecuteSqlGetObject()
{
StringBuilder builder = new StringBuilder();
SqlAndParameters sqlParameters = new SqlAndParameters();
List <Parameter> parameters = new List <Parameter>();
cfp102 db2object = null;
builder.Append("Select * from c102 where CCH=? and CFB=1");
parameters.Add(new Parameter {
ParameterKey = "?", ParameterValue = "121"
});
sqlParameters.Sql = builder.ToString();
sqlParameters.Parameter = parameters;
db2object = queryBuilder.ExecuteSqlGetObject <cfp102>(sqlParameters);
Assert.IsNotNull(db2object);
}
