SelectColumn Class

In This Topic

Represents a column or an expression in SELECT, GROUP BY and ORDER BY clauses of a SQL statement.

Syntax

Visual Basic
C#

'Declaration
 
Public NotInheritable Class SelectColumn 
   Inherits SelectStatementNode

public sealed class SelectColumn : SelectStatementNode

Example

This example shows how SelectColumns can be used to create a SelectStatement object representing the following query:

SELECT test.dept.dname Department, test.dept.loc Location
    FROM test.dept

csharp

SqlSelectStatement statement = new SqlSelectStatement();

// Create columns. Specify their schema, tables to which they belong, their names and aliases.
SelectColumn cName = new SelectColumn("test", "dept", "dname", "Department");
SelectColumn cLoc = new SelectColumn("test", "dept", "loc", "Location");

statement.Columns.Add(cName);
statement.Columns.Add(cLoc);

statement.Tables.Add(new SelectTable("test", "dept", ""));

Visual Basic

Dim statement As SqlSelectStatement = New SqlSelectStatement()

' Create columns. Specify their schema, tables to which they belong, their names and aliases.
Dim cName = New SelectColumn("test", "dept", "dname", "Department")
Dim cLoc = New SelectColumn("test", "dept", "loc", "Location")

statement.Columns.Add(cName)
statement.Columns.Add(cLoc)

statement.Tables.Add(New SelectTable("test", "dept", ""))

Inheritance Hierarchy

System.Object
Devart.Common.SelectStatementNode
Devart.Common.SelectColumn

Reference

SelectColumn Members
Devart.Common Namespace

Send Feedback