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); }