public void ODBC_ExecuteSqlGetDataTable() { StringBuilder builder = new StringBuilder(); SqlAndParameters sqlParameters = new SqlAndParameters(); System.Data.DataTable table = null; builder.Append("Select * from c02 where CFB='' and CF=1 "); sqlParameters.Sql = builder.ToString(); table = queryBuilder.ExecuteSqlGetDataTable(sqlParameters); Assert.IsTrue(table.Rows.Count > 0); }
public void ExecuteSqlGetDataTable() { string sql = "select * from Aluno"; List <Parameter> parameters = new List <Parameter>(); SqlAndParameters sqlParameters = new SqlAndParameters(); System.Data.DataTable table = null; sqlParameters.Sql = sql; table = queryBuilder.ExecuteSqlGetDataTable(sqlParameters); Console.WriteLine(table.Rows.Count); Assert.IsTrue(table.Rows.Count > 0); }