dotConnect for SQL Server Documentation
Devart.Common Namespace / SelectTableCollection Class
Members Example

In This Topic
    SelectTableCollection Class
    In This Topic
    Represents a collection of tables and subqueries in a SelectStatement object.
    Syntax
    'Declaration
     
    Public NotInheritable Class SelectTableCollection 
       Inherits System.Collections.CollectionBase
       Implements System.Collections.ICollectionSystem.Collections.IEnumerableSystem.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
    
    SelectTableCollection collection = statement.Tables;
    foreach (SelectTable table in collection)
            Console.WriteLine(table.ToString());
    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

    See Also