protected ColumnsTreeNode([NotNull] DatabaseObjectWithColumns databaseObject, DatabaseConnection connection, DatabaseInstance databaseInstance, string nodeDisplayText = "Columns")
: base(nodeDisplayText, connection, databaseInstance)
{
if (databaseObject == null)
{
throw new ArgumentNullException("databaseObject");
}
if (connection == null)
{
throw new ArgumentNullException("connection");
}
DatabaseObject = databaseObject;
}
public virtual void PopulateChildColumns(DbConnection connection, DatabaseObjectWithColumns obj)
{
populateChildren <Column>(connection, obj, obj.Columns, this.ColumnSQL, childColumnsWhere(obj), string.Empty);
}
protected virtual string childColumnsWhere(DatabaseObjectWithColumns obj) => $" and co.TABLE_NAME = '{obj.ObjectName}'" + (string.IsNullOrEmpty(obj.Schema.SchemaName) ? string.Empty : $" and co.TABLE_SCHEMA = '{obj.Schema.SchemaName}'");
