Websharp使用说明（8）

DataAccess：

public interface DataAccess      {          #region Support Property & Method          DatabaseType DatabaseType{get;}          IDbConnection DbConnection{get;}          PersistenceManager PersistenceManager{get;}          IDbTransaction BeginTransaction();          void Open();          void Close();          bool IsClosed{get;}            #endregion            #region ExecuteNonQuery            int ExecuteNonQuery(CommandType commandType, string commandText);          int ExecuteNonQuery(string commandText);          int ExecuteNonQuery(string commandText, QueryParameterCollection commandParameters);          int ExecuteNonQuery(CommandType commandType, string commandText, QueryParameterCollection commandParameters);            #endregion ExecuteNonQuery            #region ExecuteDataSet            DataSet ExecuteDataset(CommandType commandType, string commandText);          DataSet ExecuteDataset(string commandText);          DataSet ExecuteDataset(CommandType commandType, string commandText, QueryParameterCollection commandParameters);          DataSet ExecuteDataset(string commandText, QueryParameterCollection commandParameters);            DataSet ExecuteDataset(CommandType commandType, string commandText,string tableName);          DataSet ExecuteDataset(string commandText,string tableName);          DataSet ExecuteDataset(CommandType commandType, string commandText, QueryParameterCollection commandParameters,string tableName);          DataSet ExecuteDataset(string commandText, QueryParameterCollection commandParameters,string tableName);            DataSet ExecuteDataset(CommandType commandType, string commandText,DataSet ds);          DataSet ExecuteDataset(string commandText,DataSet ds);          DataSet ExecuteDataset(CommandType commandType, string commandText, QueryParameterCollection commandParameters,DataSet ds);          DataSet ExecuteDataset(string commandText, QueryParameterCollection commandParameters,DataSet ds);            DataSet ExecuteDataset(CommandType commandType, string commandText,DataSet ds,string tableName);          DataSet ExecuteDataset(string commandText,DataSet ds,string tableName);          DataSet ExecuteDataset(CommandType commandType, string commandText, QueryParameterCollection commandParameters,DataSet ds,string tableName);          DataSet ExecuteDataset(string commandText, QueryParameterCollection commandParameters,DataSet ds,string tableName);            #endregion ExecuteDataSet                   #region ExecuteReader                         IDataReader ExecuteReader(CommandType commandType, string commandText);          IDataReader ExecuteReader(string commandText);          IDataReader ExecuteReader(CommandType commandType, string commandText, QueryParameterCollection commandParameters);          IDataReader ExecuteReader(string commandText, QueryParameterCollection commandParameters);            #endregion ExecuteReader            #region ExecuteScalar                   object ExecuteScalar(CommandType commandType, string commandText);          object ExecuteScalar(string commandText);          object ExecuteScalar(CommandType commandType, string commandText, QueryParameterCollection commandParameters);          object ExecuteScalar(string commandText, QueryParameterCollection commandParameters);                   #endregion ExecuteScalar               #region ExecuteXmlReader                   XmlReader ExecuteXmlReader(CommandType commandType, string commandText);          XmlReader ExecuteXmlReader(string commandText);          XmlReader ExecuteXmlReader(CommandType commandType, string commandText, QueryParameterCollection commandParameters);          XmlReader ExecuteXmlReader(string commandText, QueryParameterCollection commandParameters);            #endregion ExecuteXmlReader      }

 

       附2：使用Websharp中间件开发的Demo程序一份。

 

       作者简介：孙亚民， 1998 年毕业于南京大学，目前中国科技大学硕士在读，曾任苏州某软件公司技术总监，可以通过 sunny_y_m@163.com 同他联系。