Show / Hide Table of Contents

    ISqlJoinBuilder.Join(string table) Method

    .NET Standard 2.x

    Creates a table by joining the original table source with a new table source, without specifying the type of the JOIN operator.

    Namespace: SnapObjects.Data

    Assembly: SnapObjects.Data.dll

    Syntax

      ISqlJoinOnBuilder Join(string table);
    

    Parameters

    table System.String

    The new table source to be joined with the original table source.

    Returns

    SnapObjects.Data.ISqlJoinOnBuilder

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

    Remarks

    If the type of the JOIN operator is not specified, database will use the INNER JOIN operator by default.

    Examples

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

    using SnapObjects.Data;
    using System;
    
    namespace Appeon.ApiDoc.ISqlJoinBuilderExamples
    {
        public class JoinExample
        {
            private readonly SchoolContext _context;
    
            public JoinExample(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")
                    .Join("Course")
                    .OnRaw("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]
                  JOIN [Course]
                  ON [Department].[DepartmentID] = [Course].[DepartmentID]
                */
            }
        }
    }
    

    Applies to

    .NET Standard

    2.x

    Back to top Generated by Appeon