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 年毕业于南京大学,目前中国科技大学硕士在读,曾任苏州某软件公司技术总监,可以通过 [email protected] 同他联系。