示例#1
0
        public async Task <T> Find <T>(string where)
        {
            var sql     = EntityToSql.SelectSql <TEntity>(where);
            var dataSet = await dbHelper.Query(sql);

            var dataTable = dataSet.Tables[0];
            var model     = DataTableToEntityHelper.ToEntity <T>(dataTable);

            return(model);
        }
示例#2
0
        public async Task <int> GetCount(string str)
        {
            string sql = "";

            if (str.Contains("select"))
            {
                sql = str;
            }
            else
            {
                sql = EntityToSql.SelectSql <TEntity>(str);
            }

            return(Convert.ToInt32(await dbHelper.GetSingle(sql)));
        }