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程序一份。