SelectTableCollection Class

Represents a collection of tables and subqueries in a SelectStatement object.

For a list of all members of this type, see SelectTableCollection members.

Inheritance Hierarchy

System.Object
System.Collections.CollectionBase
Devart.Common.SelectTableCollection

Syntax

[Visual Basic]
Public NotInheritable Class SelectTableCollection 
   Inherits CollectionBase
   Implements ICollection, IEnumerable, IList

[C#]
public sealed class SelectTableCollection : CollectionBase, ICollection, IEnumerable, IList

Remarks

Use SelectTableCollection class to manage tables used in a query. To access the collection use the SelectStatement.Tables property.

Example

In the following sample we retrieve a collection of SelectTables from an OracleSelectStatement object 'statement' and print them. For example, if statement represents the command

SELECT * FROM test.dept tDept,test.emp tEmp

the output of the sample would be the following:

test.dept tDept
test.emp tEmp

[C#]

SelectTableCollection collection = statement.Tables; 
foreach (SelectTable table in collection) 
    Console.WriteLine(table.ToString());

[Visual Basic]

Dim collection As SelectTableCollection = statement.Tables
 For Each table In collection
     Console.WriteLine(table.ToString())
 Next

See Also

Language