Show / Hide Table of Contents

    ISqlJoinBuilder.FullJoinRaw(string joinClause) Method

    .NET Standard 2.x

    Uses the FULL OUTER JOIN operator to join the original table source directly with a raw SQL to create a joined table.

    Namespace: SnapObjects.Data

    Assembly: SnapObjects.Data.dll

    Syntax

      ISqlJoinOnBuilder FullJoinRaw(string joinClause);
    

    Parameters

    joinClause System.String

    A string of raw SQL after the FULL OUTER JOIN keyword.

    Returns

    SnapObjects.Data.ISqlJoinOnBuilder

    Returns an ISqlJoinOnBuilder object which can be used to create the condition on which the join is based.

    Examples

    The following code example demonstrates how to join a table with another using the FullJoinRaw method.

    using SnapObjects.Data;
    using System;
    
    namespace Appeon.ApiDoc.ISqlJoinBuilderExamples
    {
        public class FullJoinRawExample
        {
            private readonly SchoolContext _context;
    
            public FullJoinRawExample(SchoolContext dataContext)
            {
                // Sets data context.
                _context = dataContext;
            }
    
            public void Example1()
            {
                var sqlQueryBuilder = new SqlQueryBuilder();
    
                // Gets DepartmentID and Name from the "Department" table, and Title from the "Course" table.
                // Sets to join "Department" table and "Course" table by: Department.DepartmentID = Course.DepartmentID.            
                sqlQueryBuilder
                    .Select("Department.DepartmentID")
                    .Select("Department.Name")
                    .Select("Course.Title")
                    .From("Department")
                    .FullJoinRaw("Course On Department.DepartmentID = Course.DepartmentID");
    
                // Converts to raw SQL for the database corresponding to the data context.
                string sql = sqlQueryBuilder.ToSqlString(_context);
    
                Console.WriteLine(sql);
                
                /*This code example produces the following output:           
                  SELECT
                    [Department].[DepartmentID],
                    [Department].[Name],
                    [Course].[Title]
                  FROM [Department]
                  FULL JOIN [Course]
                       ON [Department].[DepartmentID] = [Course].[DepartmentID]
                */
            }
        }
    }
    

    Applies to

    .NET Standard

    2.x

    Back to top Generated by Appeon