protected override IList <Column> GetColumns(DbInfoProvider infoProvider, IDbConnection connection)
{
var databaseInstanceName = DatabaseObject.Parent.Parent == null ? null : DatabaseObject.Parent.Parent.Name;
var columns = infoProvider.GetViewColumns(connection, DatabaseObject.Parent.Name, DatabaseObject.Name, databaseInstanceName);
foreach (var column in columns)
{
column.Parent = DatabaseObject;
}
return(columns);
}
protected override IList <Column> GetColumns(DbInfoProvider infoProvider, IDbConnection connection)
{
var databaseInstanceName = DatabaseObject.Parent.Parent == null ? null : DatabaseObject.Parent.Parent.Name;
var index = DatabaseObject as Index;
if (index == null)
{
throw new Exception("Index is null");
}
var columns = infoProvider.GetIndexIncludedColumns(connection, index.Table.Parent.Name, index.Table.Name, DatabaseObject.Parent.Name, DatabaseObject.Name, indexId: this.DatabaseObject.Id, databaseInstanceName: databaseInstanceName);
foreach (var column in columns)
{
column.Parent = DatabaseObject;
}
return(columns);
}
public DatabaseMetadata(Database database)
{
_database = database;
_infoProvider = database.GetInfoProvider();
_schema = GetOrCreateSchema(database.GetLoginUserId());
}
protected override IList <Column> GetColumns(DbInfoProvider infoProvider, IDbConnection connection)
{
return(infoProvider.GetStoredProcedureParameters(connection, (StoredProcedure)DatabaseObject).Cast <Column>().ToList());
}
protected override IList <Column> GetColumns(DbInfoProvider infoProvider, IDbConnection connection)
{
return(infoProvider.GetFunctionReturnValue(connection, (Function)DatabaseObject).Cast <Column>().ToList());
}
protected abstract IList <Column> GetColumns(DbInfoProvider infoProvider, IDbConnection connection);
