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程序一份。
本文地址:http://com.8s8s.com/it/it45120.htm