www.pudn.com > WorkflowDesigner.rar > IDataAccess.cs, change:2007-11-16,size:3682b


using System; 
using System.Data; 
using System.Xml; 
 
namespace DataAccess 
{ 
	/// <summary> 
	/// SqlOperator  
	/// </summary> 
	public interface IDataAccess 
	{ 
		#region Support Property & Method 
		DatabaseType DatabaseType{get;} 
		//string SqlString{get;set;} 
		//QueryParameterCollection Parameters{get;set;} 
		//CommandType CommandType{get;set;} 
		IDbConnection DbConnection{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 
	} 
}