SelectTableCollection Class

In This Topic

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

Syntax

Visual Basic
C#

'Declaration
 
Public NotInheritable Class SelectTableCollection 
   Inherits System.Collections.CollectionBase
   Implements System.Collections.ICollection, System.Collections.IEnumerable, System.Collections.IList

public sealed class SelectTableCollection : System.Collections.CollectionBase, System.Collections.ICollection, System.Collections.IEnumerable, System.Collections.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 SqlSelectStatement 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

csharp

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

Inheritance Hierarchy

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

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

SelectTableCollection Members
Devart.Common Namespace

Send Feedback