C# (CSharp) Ivony.Data.SqlQueries.SqlDom JoinedTables Exemples

Exemple #1

        public JoinedTables On(SqlBooleanExpression condition)
        {
            switch (joinType)
            {
            case TableJoinType.InnerJoin:
                return(JoinedTables.InnerJoin(left, right, condition));

            case TableJoinType.LeftOuterJoin:
                return(JoinedTables.LeftOuterJoin(left, right, condition));

            case TableJoinType.RightOuterJoin:
                return(JoinedTables.RightOuterJoin(left, right, condition));

            case TableJoinType.FullOuterJoin:
                return(JoinedTables.FullOuterJoin(left, right, condition));

            default:
                throw new InvalidOperationException();
            }
        }

Exemple #2

 public JoinedTables CrossJoin(TableSource right)
 => JoinedTables.CrossJoin(this, right);

Exemple #3

 public JoinedTables FullOuterJoin(TableSource right, SqlBooleanExpression condition)
 => JoinedTables.FullOuterJoin(this, right, condition);