Table of Contents

Class SqlDatabaseCollection

Namespace
CENTREL.XIA.Configuration.Types
Assembly
CENTREL.XIA.Configuration.Types.dll

Represents a collection of SQL databases.

public class SqlDatabaseCollection : Collection<SqlDatabase>, IList<SqlDatabase>, ICollection<SqlDatabase>, IList, ICollection, IReadOnlyList<SqlDatabase>, IReadOnlyCollection<SqlDatabase>, IEnumerable<SqlDatabase>, IEnumerable
Inheritance
SqlDatabaseCollection
Implements
Inherited Members

Constructors

SqlDatabaseCollection()

Initializes a new instance of the CENTREL.XIA.Configuration.Types.SqlDatabaseCollection class.

public SqlDatabaseCollection()

Methods

FindAssembly(Guid)

Returns the CENTREL.XIA.Configuration.Types.SqlAssembly with the specified identifier regardless of the database in which it resides, or null if no CENTREL.XIA.Configuration.Types.SqlAssembly with that identifier is found.

public SqlAssembly FindAssembly(Guid identifier)

Parameters

identifier Guid

The identifier of the CENTREL.XIA.Configuration.Types.SqlAssembly to locate.

Returns

SqlAssembly

The CENTREL.XIA.Configuration.Types.SqlAssembly with the specified identifier.

FindByName(string)

Returns the database with the specified name, or null if no database with that name is found.

public SqlDatabase FindByName(string name)

Parameters

name string

The name of the database to locate.

Returns

SqlDatabase

The database with the specified name.

FindByType(SqlDatabaseSearchType)

Finds the databases of the specified type.

public SqlDatabaseCollection FindByType(SqlDatabaseSearchType searchType)

Parameters

searchType SqlDatabaseSearchType

The type of database to find.

Returns

SqlDatabaseCollection

A CENTREL.XIA.Configuration.Types.SqlDatabaseCollection containing the databases of the specified type.

FindColumn(Guid)

Returns the CENTREL.XIA.Configuration.Types.SqlColumn with the specified identifier regardless of the database in which it resides, or null if no CENTREL.XIA.Configuration.Types.SqlColumn with that identifier is found.

public SqlColumn FindColumn(Guid identifier)

Parameters

identifier Guid

The identifier of the CENTREL.XIA.Configuration.Types.SqlColumn to locate.

Returns

SqlColumn

The CENTREL.XIA.Configuration.Types.SqlColumn with the specified identifier.

FindForeignKey(Guid)

Returns the CENTREL.XIA.Configuration.Types.SqlForeignKey with the specified identifier regardless of the database in which it resides, or null if no CENTREL.XIA.Configuration.Types.SqlForeignKey with that identifier is found.

public SqlForeignKey FindForeignKey(Guid identifier)

Parameters

identifier Guid

The identifier of the CENTREL.XIA.Configuration.Types.SqlForeignKey to locate.

Returns

SqlForeignKey

The CENTREL.XIA.Configuration.Types.SqlForeignKey with the specified identifier.

FindStoredProcedure(Guid)

Returns the CENTREL.XIA.Configuration.Types.SqlStoredProcedure with the specified identifier regardless of the database in which it resides, or null if no CENTREL.XIA.Configuration.Types.SqlStoredProcedure with that identifier is found.

public SqlStoredProcedure FindStoredProcedure(Guid identifier)

Parameters

identifier Guid

The identifier of the CENTREL.XIA.Configuration.Types.SqlStoredProcedure to locate.

Returns

SqlStoredProcedure

The CENTREL.XIA.Configuration.Types.SqlStoredProcedure with the specified identifier.

FindStoredProcedures()

Finds the stored procedures in all databases.

public SqlStoredProcedureCollection FindStoredProcedures()

Returns

SqlStoredProcedureCollection

A CENTREL.XIA.Configuration.Types.SqlStoredProcedureCollection containing stored procedures in all databases.

FindTable(Guid)

Returns the CENTREL.XIA.Configuration.Types.SqlTable with the specified identifier regardless of the database in which it resides, or null if no CENTREL.XIA.Configuration.Types.SqlTable with that identifier is found.

public SqlTable FindTable(Guid identifier)

Parameters

identifier Guid

The identifier of the CENTREL.XIA.Configuration.Types.SqlTable to locate.

Returns

SqlTable

The CENTREL.XIA.Configuration.Types.SqlTable with the specified identifier.

FindTables()

Finds the tables in all databases.

public SqlTableCollection FindTables()

Returns

SqlTableCollection

A CENTREL.XIA.Configuration.Types.SqlTableCollection containing tables in all databases.

FindTrigger(Guid)

Returns the CENTREL.XIA.Configuration.Types.SqlTrigger with the specified identifier regardless of the database in which it resides, or null if no CENTREL.XIA.Configuration.Types.SqlTrigger with that identifier is found.

public SqlTrigger FindTrigger(Guid identifier)

Parameters

identifier Guid

The identifier of the CENTREL.XIA.Configuration.Types.SqlTrigger to locate.

Returns

SqlTrigger

The CENTREL.XIA.Configuration.Types.SqlTrigger with the specified identifier.

FindUserDefinedFunction(Guid)

Returns the CENTREL.XIA.Configuration.Types.SqlUserDefinedFunction with the specified identifier regardless of the database in which it resides, or null if no CENTREL.XIA.Configuration.Types.SqlUserDefinedFunction with that identifier is found.

public SqlUserDefinedFunction FindUserDefinedFunction(Guid identifier)

Parameters

identifier Guid

The identifier of the CENTREL.XIA.Configuration.Types.SqlUserDefinedFunction to locate.

Returns

SqlUserDefinedFunction

The CENTREL.XIA.Configuration.Types.SqlUserDefinedFunction with the specified identifier.

FindUserDefinedFunctions()

Finds the user defined functions in all databases.

public SqlUserDefinedFunctionCollection FindUserDefinedFunctions()

Returns

SqlUserDefinedFunctionCollection

A CENTREL.XIA.Configuration.Types.SqlUserDefinedFunctionCollection containing user defined functions in all databases.

FindView(Guid)

Returns the CENTREL.XIA.Configuration.Types.SqlView with the specified identifier regardless of the database in which it resides, or null if no CENTREL.XIA.Configuration.Types.SqlView with that identifier is found.

public SqlView FindView(Guid identifier)

Parameters

identifier Guid

The identifier of the CENTREL.XIA.Configuration.Types.SqlView to locate.

Returns

SqlView

The CENTREL.XIA.Configuration.Types.SqlView with the specified identifier.

FindViews()

Finds the views in all databases.

public SqlViewCollection FindViews()

Returns

SqlViewCollection

A CENTREL.XIA.Configuration.Types.SqlViewCollection containing views in all databases.

Sort()

Sorts the values in the collection.

public void Sort()