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 同他联系。