查询大数据表的效率对比:Linq to SQL、Entity Framework、企业(8)
//Database db1 = DatabaseFactory.CreateDatabase();
dbCommand = db.GetStoredProcCommand("SelectSystemErrorLogsAll");
return db.ExecuteDataSet(dbCommand);
}
        public DataSet select2()
        {
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetStoredProcCommand("SelectSystemErrorLogsAll");
            return db.ExecuteDataSet(dbCommand);
        }
        public DataSet selectSQL()
        {
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand("select * from School");
            return db.ExecuteDataSet(dbCommand);
        }
        public IDataReader selectSQLReader()
        {
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand("select * from School");
            return db.ExecuteReader(dbCommand);
        }
        public DataSet selectView()
        {
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand("select * from ViewsSchool");
            return db.ExecuteDataSet(dbCommand);
        }
        public DataSet selectProSet()
        {
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetStoredProcCommand("SelectSchoolsAll");
	
相关新闻>>
- 发表评论
 - 
				
 
- 最新评论 进入详细评论页>>
 



