/// <summary> /// Executes a DataSet. /// </summary> /// <param name="edt">Database provider dataType</param> /// <param name="connectionString">Connection string</param> /// <param name="executableQuery">Query to be executed</param> /// <returns>DataSet</returns> public DataTable ExecuteDataTable(DatabaseServer edt, string connectionString, ExecutionQuery executableQuery) { DbConnection icon = null; DbCommand icmd = null; DataTable dset = null; DbDataAdapter idap = null; DataFactory factory = new DataFactory(); try { factory.InitializeDbConnection(edt, ref icon); factory.InitializeDbCommand(edt, ref icmd); factory.InitializeDbDataAdapter(edt, ref idap, icmd); icmd.Connection = icon; dset = new DataTable(); icon.ConnectionString = connectionString; icmd.Parameters.Clear(); if (executableQuery.Parameters != null) { foreach (IDataParameter var in executableQuery.Parameters) { icmd.Parameters.Add(var); } } icmd.CommandText = executableQuery.Query; idap.SelectCommand = icmd; //log the queries (new ExecutionEngineLogger()).LogContext(executableQuery); icon.Open(); idap.Fill(dset); return(dset); } finally { DisposeObjects(ref icon, ref icmd); } }
/// <summary> /// Executes a DataTable /// </summary> /// <param name="edt">Provider Type</param> /// <param name="connectionString">Connection Strinng</param> /// <param name="storedProcedure">Stored Procedure's name</param> /// <param name="iparam">Stored Procedure Data Parameters</param> /// <returns>DataSet</returns> public DataTable ExecuteDataTable(DatabaseServer edt, string connectionString, string storedProcedure, params IDataParameter[] iparam) { DbConnection icon = null; DbCommand icmd = null; DataTable table = null; DbDataAdapter idap = null; DataFactory factory = new DataFactory(); try { factory.InitializeDbConnection(edt, ref icon); factory.InitializeDbCommand(edt, ref icmd); factory.InitializeDbDataAdapter(edt, ref idap, icmd); icon.ConnectionString = connectionString; icmd.Connection = icon; icon.Open(); table = new DataTable(); if (iparam != null) { for (int i = 0; i < iparam.Length; i++) { icmd.Parameters.Add(iparam[i]); } } //log the message (new ExecutionEngineLogger()).LogContext(storedProcedure); icmd.CommandType = CommandType.StoredProcedure; icmd.CommandText = storedProcedure; idap.SelectCommand = icmd; idap.Fill(table); return(table); } finally { DisposeObjects(ref icon, ref icmd); } }
public static void ExecuteDataSet(DatabaseServer edt, string connectionString, ExecutionQuery executableQuery, ref DataSet ds) { DbConnection icon = null; DbCommand icmd = null; DbDataAdapter idap = null; try { DataFactory.InitializeDbConnection(edt, ref icon); DataFactory.InitializeDbCommand(edt, ref icmd); DataFactory.InitializeDbDataAdapter(edt, ref idap, icmd); icmd.Connection = icon; icon.ConnectionString = connectionString; icmd.Parameters.Clear(); if (executableQuery.Parameters != null) { foreach (IDataParameter var in executableQuery.Parameters) { icmd.Parameters.Add(var); } } icmd.CommandType = CommandType.Text; icmd.CommandText = executableQuery.Query; idap.SelectCommand = icmd; //log the query (new ExecutionEngineLogger()).LogContext(executableQuery); icon.Open(); idap.Fill(ds); } finally { DisposeObjects(ref icon, ref icmd); } }