Websharp使用说明(8)
类别: ASP.NET教程
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程序一份。
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程序一份。
- 上一篇: Websharp使用说明(7)
- 下一篇: .NET 的对象关系持久化机制(1)
-= 资 源 教 程 =-
文 章 搜 索