Sql.Net Class Library Documentation

FromClause Class

Represents the FROM clause of a select statement

For a list of all members of this type, see FromClause Members.


public class FromClause : ICloneable

Thread Safety

Public static (Shared in Visual Basic) members of this type are safe for multithreaded operations. Instance members are not guaranteed to be thread-safe.


FromClause consists of a base table set by the BaseTable property and optional joins defined using the Join method.

SqlOM supports inner, outer and cross joins. Inner join between two tables returns only rows which exist in both tables. Outer (Left, Right and Full) joins return rows when at least one of the tables has a matching row. Left outer joins returns all rows from the left table and while the missing rows from the right are filled with nulls. Right outer join is the opposite of left. Full outer join returns all the rows from the left and the right tables while the missing rows from the opposite table are filled with nulls. Cross join does not match any keys and returns the cartesian product of both tables. For more information about joins consult SQL documentation.


Namespace: Reeb.SqlOM

Assembly: Reeb.SqlOM (in Reeb.SqlOM.dll)

See Also

FromClause Members | Reeb.SqlOM Namespace