Exemplos de LeeFuns.DataAccess DatabaseReader em C# (CSharp)

Exemplo n.º 1

 public DataTable FindTableBySql(string strSql, DbParameter[] parameters)
 {
     return(DatabaseReader.ReaderToDataTable(DbHelper.ExecuteReader(CommandType.Text, strSql.ToString(), parameters)));
 }

Exemplo n.º 2

        public DataTable FindTableTop <T>(int Top) where T : new()
        {
            StringBuilder builder = DatabaseCommon.SelectSql <T>(Top);

            return(DatabaseReader.ReaderToDataTable(DbHelper.ExecuteReader(CommandType.Text, builder.ToString())));
        }

Exemplo n.º 3

 public DataTable FindTableByProc(string procName, DbParameter[] parameters)
 {
     return(DatabaseReader.ReaderToDataTable(DbHelper.ExecuteReader(CommandType.StoredProcedure, procName, parameters)));
 }

Exemplo n.º 4

 public List <T> FindListBySql <T>(string strSql, DbParameter[] parameters)
 {
     return(DatabaseReader.ReaderToList <T>(DbHelper.ExecuteReader(CommandType.Text, strSql.ToString(), parameters)));
 }

Exemplo n.º 5

        public List <T> FindList <T>() where T : new()
        {
            StringBuilder builder = DatabaseCommon.SelectSql <T>();

            return(DatabaseReader.ReaderToList <T>(DbHelper.ExecuteReader(CommandType.Text, builder.ToString())));
        }

Exemplo n.º 6

 public Hashtable FindHashtableBySql(string strSql)
 {
     return(DatabaseReader.ReaderToHashtable(DbHelper.ExecuteReader(CommandType.Text, strSql.ToString())));
 }

Exemplo n.º 7

 public T FindEntityBySql <T>(string strSql, DbParameter[] parameters)
 {
     return(DatabaseReader.ReaderToModel <T>(DbHelper.ExecuteReader(CommandType.Text, strSql.ToString(), parameters)));
 }