public object ExecuteScalar(string cmdText, CommandType cmdType, ParameterPackageCollection parameters) { IDbCommand command = this.PrepareCommand(cmdText, cmdType, parameters); if (command.Connection.State == ConnectionState.Closed) { command.Connection.Open(); } return(command.ExecuteScalar()); }
public void ExecuteNonQuery(string cmdText, CommandType cmdType, ParameterPackageCollection parameters) { IDbCommand command = this.PrepareCommand(cmdText, cmdType, parameters); if (command.Connection.State == ConnectionState.Closed) { command.Connection.Open(); } command.ExecuteNonQuery(); }
public DataTable FillTable(string cmdText, CommandType cmdType, ParameterPackageCollection parameters) { IDbCommand command = this.PrepareCommand(cmdText, cmdType, parameters); DataSet ds = new DataSet(); IDbDataAdapter adapter = this.CreateDataAdapter(); adapter.SelectCommand = command; adapter.Fill(ds); if (ds.Tables.Count == 0) { throw new Exception("no table"); } return(ds.Tables[0]); }
protected IDbCommand PrepareCommand(string cmdText, CommandType cmdType, ParameterPackageCollection parameters) { IDbConnection connection = this.CreateConnection(); IDbCommand command = this.CreateCommand(); command.Connection = connection; command.CommandText = cmdText; command.CommandType = cmdType; if (parameters != null) { foreach (ParameterPackage parameterPackage in parameters) { IDbDataParameter parameter = this.parameterConvertor.Convert(parameterPackage); command.Parameters.Add(parameter); } } return(command); }