Shahed Khan (MVP C#)

SmartCodeGenerator DBSchemaProvider Snapshot

The Database Schema Explorer of SmartCodeGenerator has the following Classes to support your needs to browse through  Database Schemas.

public class ColumnSchema : DataObjectBase
{
      // Methods
      public ColumnSchema(TableSchema table, string name, DbType dataType, string nativeType, int size, byte precision, int scale, bool allowDBNull);
      public ColumnSchema(TableSchema table, string name, DbType dataType, string nativeType, int size, byte precision, int scale, bool allowDBNull, ExtendedPropertyCollection extendedProperties);

      // Properties
      public bool IsForeignKeyMember { get; }
      public bool IsPrimaryKeyMember { get; }
      public bool IsUnique { get; }
      public TableSchema Table { get; }
}

public class CommandResultColumnSchema : DataObjectBase
{
      // Methods
      public CommandResultColumnSchema(CommandSchema command, string name, DbType dataType, string nativeType, int size, byte precision, int scale, bool allowDBNull);
      public CommandResultColumnSchema(CommandSchema command, string name, DbType dataType, string nativeType, int size, byte precision, int scale, bool allowDBNull, ExtendedPropertyCollection extendedProperties);
      public override void Refresh();

      // Properties
      public CommandSchema Command { get; }

}

public class CommandResultSchema : TabularBase
{
      // Methods
      public CommandResultSchema(CommandSchema command, string name, CommandResultColumnSchemaCollection columns);
      public CommandResultSchema(CommandSchema command, string name, CommandResultColumnSchemaCollection columns, ExtendedPropertyCollection extendedProperties);

      // Properties
      public CommandResultColumnSchemaCollection Columns { get; }
      public CommandSchema Command { get; }
      public CommandResultColumnSchema this[int index] { get; }
     
}

public class CommandSchema : SchemaBase
{
      // Methods
      public CommandSchema(DatabaseSchema database, string name, string owner, DateTime dateCreated);
      public CommandSchema(DatabaseSchema database, string name, string owner, DateTime dateCreated, ExtendedPropertyCollection extendedProperties);

      // Properties
      public ParameterSchemaCollection AllInputParameters { get; }
      public ParameterSchemaCollection AllOutputParameters { get; }
      public CommandResultSchemaCollection CommandResults { get; }
      public string CommandText { get; }
      public DateTime DateCreated { get; }
      public ParameterSchemaCollection InputOutputParameters { get; }
      public ParameterSchemaCollection InputParameters { get; }
      public ParameterSchemaCollection NonReturnValueParameters { get; }
      public ParameterSchemaCollection OutputParameters { get; }
      public string Owner { get; }
      public ParameterSchemaCollection Parameters { get; }
      public ParameterSchema ReturnValueParameter { get; }      
}

public class DatabaseSchema : SchemaBase
{
      // Methods
      public DatabaseSchema();
      public DatabaseSchema(string connectionString);
      public DatabaseSchema(string provider, string connectionString);
      public override string ToString();

      // Properties
      public CommandSchemaCollection Commands { get; }
      public string ConnectionString { get; set; }
      public string DatabaseSchemaProvider { get; set; }
      public override string Name { get; }
      public TableSchemaCollection Tables { get; }
      public ViewSchemaCollection Views { get; }
}

public class IndexSchema : SchemaBase
{
      // Methods
      public IndexSchema(TableSchema table, string name, bool isPrimaryKey, bool isUnique, bool isClustered, string[] memberColumns);
      public IndexSchema(TableSchema table, string name, bool isPrimaryKey, bool isUnique, bool isClustered, string[] memberColumns, ExtendedPropertyCollection extendedProperties);

      // Properties
      public bool IsClustered { get; }
      public bool IsPrimaryKey { get; }
      public bool IsUnique { get; }
      public ColumnSchemaCollection MemberColumns { get; }
      public TableSchema Table { get; }

}

public class ParameterSchema : DataObjectBase
{
      // Methods
      public ParameterSchema(CommandSchema command, string name, ParameterDirection direction, DbType dataType, string nativeType, int size, byte precision, int scale, bool allowDBNull);
      public ParameterSchema(CommandSchema command, string name, ParameterDirection direction, DbType dataType, string nativeType, int size, byte precision, int scale, bool allowDBNull, ExtendedPropertyCollection extendedProperties);

      // Properties
      public CommandSchema Command { get; }
      public ParameterDirection Direction { get; }      
}

public class PrimaryKeySchema : SchemaBase
{
      // Methods
      public PrimaryKeySchema(TableSchema table, string name, string[] memberColumns);
      public PrimaryKeySchema(TableSchema table, string name, string[] memberColumns, ExtendedPropertyCollection extendedProperties);

      // Properties
      public ColumnSchemaCollection MemberColumns { get; }
      public TableSchema Table { get; }
}

public class TableKeySchema : SchemaBase
{
      // Methods
      public TableKeySchema(DatabaseSchema database, string name, string[] foreignKeyMemberColumns, string foreignKeyTable, string[] primaryKeyMemberColumns, string primaryKeyTable);
      public TableKeySchema(DatabaseSchema database, string name, string[] foreignKeyMemberColumns, string foreignKeyTable, string[] primaryKeyMemberColumns, string primaryKeyTable, ExtendedPropertyCollection extendedProperties);

      // Properties
      public ColumnSchemaCollection ForeignKeyMemberColumns { get; }
      public TableSchema ForeignKeyTable { get; }
      public PrimaryKeySchema PrimaryKey { get; }
      public ColumnSchemaCollection PrimaryKeyMemberColumns { get; }
      public TableSchema PrimaryKeyTable { get; }     
}

public class TableSchema : TabularBase
{
      // Methods
      public TableSchema(DatabaseSchema database, string name, string owner, DateTime dateCreated);
      public TableSchema(DatabaseSchema database, string name, string owner, DateTime dateCreated, ExtendedPropertyCollection extendedProperties);
      private bool dependentOf(TableSchema schema2, TableSchemaCollection collection1);
      public bool IsDependantOf(TableSchema table);

      // Properties
      public ColumnSchemaCollection Columns { get; }
      public DateTime DateCreated { get; }
      public TableKeySchemaCollection ForeignKeys { get; }
      public IndexSchemaCollection Indexes { get; }
      public TableKeySchemaCollection Keys { get; }
      public ColumnSchemaCollection NonKeyColumns { get; }
      public ColumnSchemaCollection NonPrimaryKeyColumns { get; }
      public string Owner { get; }
      public PrimaryKeySchema PrimaryKey { get; }
      public TableKeySchemaCollection PrimaryKeys { get; }

}

public class ViewColumnSchema : DataObjectBase
{
      // Methods
      public ViewColumnSchema(ViewSchema view, string name, DbType dataType, string nativeType, int size, byte precision, int scale);
      public ViewColumnSchema(ViewSchema view, string name, DbType dataType, string nativeType, int size, byte precision, int scale, ExtendedPropertyCollection extendedProperties);
      public ViewColumnSchema(ViewSchema view, string name, DbType dataType, string nativeType, int size, byte precision, int scale, bool allowDBNull);
      public ViewColumnSchema(ViewSchema view, string name, DbType dataType, string nativeType, int size, byte precision, int scale, bool allowDBNull, ExtendedPropertyCollection extendedProperties);

      // Properties
      public ViewSchema View { get; }

}

public class ViewSchema : TabularBase
{
      // Methods
      public ViewSchema(DatabaseSchema database, string name, string owner, DateTime dateCreated);
      public ViewSchema(DatabaseSchema database, string name, string owner, DateTime dateCreated, ExtendedPropertyCollection extendedProperties);
      public DataTable GetViewData();

      // Properties
      public ViewColumnSchemaCollection Columns { get; }
      public DateTime DateCreated { get; }
      public string Owner { get; }
      public string ViewText { get; }

}