public void TestDataTable()
{
var result = _dbContext.GetListBySql <Student>("SELECT * FROM STUDENT");
_output.WriteLine(result.ToJson());
DataTable data = _dbContext.GetDataTable("SELECT * FROM STUDENT");
data.Rows.Cast <DataRow>().ForEach(x =>
{
_output.WriteLine(x["id"].ToString());
_output.WriteLine(x["name"].ToString());
_output.WriteLine(x["sex"].ToString());
});
}
public List <T> GetListBySql(string sql, object parameters = null)
{
return(DbContext.GetListBySql <T>(sql, parameters));
}
public List <T> GetListBySql <T>(string sql, object parameters = null) where T : class, new()
{
return(DbContext.GetListBySql <T>(sql, parameters));
}