WebSharp instructions (8)

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;}

#ndregion

#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);

#ENDREGON EXECUTENONQUERY

#REGON EXECUTEDASET

DataSet ExecutetSet (CommandType CommandType, String CommandText);

DataSet ExecuteTaset (String CommandText);

DataSet Executedataset (CommandType CommandType, String Commandtext, QueryParameterCollection CommandParameters);

DataSet ExecutetAset (String CommandText, QueryParameterCollection CommandParameters);

DataSet ExecutetAset (CommandType CommandType, String CommandText, String Tablename);

DataSet ExecutetAset (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 ExecuteTaset (String CommandText, DataSet DS);

DataSet ExecutetAset (CommandType CommandType, String CommandText, QueryParameterCollection CommandParameters, DataSet DS);

DataSet ExecutetAset (String CommandText, QueryParameterCollection CommandParameters, DataSet DS);

DataSet ExecuteTel (CommandType CommandType, String CommandText, DataSet DS, String TableName);

DataSet ExecuteTaset (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);

#ndregion executedataset

#Region ExecuteReader

IDataReader ExecuteRead (CommandType CommandType, String CommandText);

IdataReader ExecuteReader (String CommandText);

IDataReader ExecuteReader (String CommandText, QueryParameterCollection Commandparameters);

IdataReader ExecuteReader (String CommandText, QueryParameterCollection CommandParameters);

#ENDREGON 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);

#ndregion 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

}

Attach 2: A Demo program developed using Websharp middleware.

About the author: Sun Yam,

1998

He graduated from Nanjing University. At present, Master of Science and Technology, China University of Science and Technology, has served as a software company in Suzhou, which can pass

Sunny_y_m@163.com

Contact him.