/// <summary>
/// Get stored procedure and function information from the db
/// </summary>
/// <returns>Raw info on stored procs and functions</returns>
public IEnumerable <StoredProcFuncInfoRaw> GetStoredProcFunctionInformation()
{
List <StoredProcFuncInfoRaw> list = new List <StoredProcFuncInfoRaw>();
using (IDbConnection conn = _iBaseDatabaseConnection.GetDatabaseConnection())
{
conn.Open();
using (IDbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = Business.Common.SqlQuery._STORED_PROCEDURE_AND_FUNCTIONS;
using (IDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
list.Add(
new StoredProcFuncInfoRaw(
rdr.GetString(rdr.GetOrdinal("ObjectName")),
rdr.GetString(rdr.GetOrdinal("ObjectType")),
rdr.IsDBNull(rdr.GetOrdinal("ParameterId")) ? (int?)null : rdr.GetInt32(rdr.GetOrdinal("ParameterId")),
rdr.GetString(rdr.GetOrdinal("ParameterName")),
rdr.GetString(rdr.GetOrdinal("ParameterDataType")),
rdr.IsDBNull(rdr.GetOrdinal("ParameterMaxLength")) ? (int?)null : rdr.GetInt32(rdr.GetOrdinal("ParameterMaxLength")),
rdr.IsDBNull(rdr.GetOrdinal("IsOutPutParameter")) ? (bool?)null : rdr.GetBoolean(rdr.GetOrdinal("IsOutPutParameter"))
)
);
}
}
}
}
return(list);
}
/// <summary>
/// Get the data from the database, and return as an <see cref="IEnumerable{T}"/> of <see cref="TableColumnInfoRaw"/>
/// </summary>
/// <returns>IEnumerable of TableColumnInfoRaw</returns>
public IEnumerable <TableColumnInfoRaw> GetTableColumnInformation()
{
List <TableColumnInfoRaw> list = new List <TableColumnInfoRaw>();
using (IDbConnection conn = _iBaseDatabaseConnection.GetDatabaseConnection())
{
conn.Open();
using (IDbCommand cmd = conn.CreateCommand())
{
cmd.CommandText = Common.SqlQuery._TABLE_COLUMN_DESCRIPTIONS;
using (IDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
list.Add(
new TableColumnInfoRaw(
rdr.GetString(rdr.GetOrdinal("TABLE_NAME")),
rdr.GetString(rdr.GetOrdinal("TABLE_DESCRIPTION")),
rdr.GetString(rdr.GetOrdinal("COLUMN_NAME")),
rdr.GetString(rdr.GetOrdinal("COLUMN_DESCRIPTION")),
rdr.GetString(rdr.GetOrdinal("ColType")),
rdr.IsDBNull(rdr.GetOrdinal("Length")) ? (int?)null : rdr.GetInt32(rdr.GetOrdinal("Length")),
rdr.GetString(rdr.GetOrdinal("DefaultValue")),
rdr.GetBoolean(rdr.GetOrdinal("Nulls")),
rdr.IsDBNull(rdr.GetOrdinal("KeySeq")) ? (int?)null : rdr.GetInt32(rdr.GetOrdinal("KeySeq")),
rdr.GetDateTime(rdr.GetOrdinal("modify_date"))
)
);
}
}
}
}
return(list);
}
