public DataTable GetProcedures(string database)
{
DataTable metaData = new DataTable();
try
{
metaData = context.CreateProceduresDataTable();
EfzConnection conn = InternalConnection;
EfzCommand cmd = new EfzCommand();
cmd.CommandText =
@"SELECT p.*
FROM INFORMATION_SCHEMA.SYSTEM_PROCEDURES p
WHERE PROCEDURE_CAT = '" + database + "'";
cmd.Connection = conn;
using (EfzDataReader r = cmd.ExecuteReader())
{
while (r.Read())
{
DataRow row = metaData.NewRow();
metaData.Rows.Add(row);
row["PROCEDURE_CATALOG"] = r["PROCEDURE_CAT"];
row["PROCEDURE_SCHEMA"] = r["PROCEDURE_SCHEM"];
row["PROCEDURE_NAME"] = r["PROCEDURE_NAME"];
row["PROCEDURE_TYPE"] = r["PROCEDURE_TYPE"];
row["DESCRIPTION"] = r["REMARKS"];
}
}
}
finally { }
return(metaData);
}
private DataTable Mapper(IDataReader reader)
{
DataTable metaData = _context.CreateProceduresDataTable();
while (reader.Read())
{
DataRow row = metaData.NewRow();
//metaData.Columns.Add("PROCEDURE_CATALOG", Type.GetType("System.String"));
//metaData.Columns.Add("PROCEDURE_SCHEMA", Type.GetType("System.String"));
//metaData.Columns.Add("PROCEDURE_NAME", Type.GetType("System.String"));
//metaData.Columns.Add("PROCEDURE_TYPE", Type.GetType("System.Int16"));
//metaData.Columns.Add("PROCEDURE_DEFINITION", Type.GetType("System.String"));
//metaData.Columns.Add("DESCRIPTION", Type.GetType("System.String"));
//metaData.Columns.Add("DATE_CREATED", Type.GetType("System.DateTime"));
//metaData.Columns.Add("DATE_MODIFIED", Type.GetType("System.DateTime"));
row["PROCEDURE_CATALOG"] = _database;
row["PROCEDURE_SCHEMA"] = reader.GetString(0).Trim();
row["PROCEDURE_NAME"] = reader.GetString(1).Trim();
metaData.Rows.Add(row);
}
metaData.AcceptChanges();
return(metaData);
}
DataTable IMyMetaPlugin.GetProcedures(string databaseName)
{
TraceContext("GetProcedures: db=" + databaseName);
DataTable metaData = new DataTable();
SchemaXsd3bEx db = null;
try
{
metaData = context.CreateProceduresDataTable();
db = Xsd3b;
foreach (TableDefinitionRow tab in db.TableDefinition)
{
if (tab.DBTableType.ToUpper().IndexOf("PROC") >= 0) // PROCEDURE, SYSTEM PROCEDURE
{
DataRow row = metaData.NewRow();
metaData.Rows.Add(row);
set(row, "PROCEDURE_NAME", tab.TableName);
set(row, "DESCRIPTION", tab.TableComment);
}
}
}
finally
{
}
metaData.TableName = "GetProcedures";
TraceTable("GetProcedures-" + databaseName, metaData);
return(metaData);
}
public System.Data.DataTable GetProcedures(string database)
{
return(_context.CreateProceduresDataTable());
}
