Websharp使用说明（7)

来源：互联网发布：搜达足球数据库编辑：程序博客网时间：2024/04/29 19:47

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