ISqlJoinBuilder.Join(string table, string alias) 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. You need to specify an alias for the new table source.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Syntax

  ISqlJoinOnBuilder Join(string table, string alias);

Parameters

table System.String

The name of the new table source.

alias System.String

The alias of the new table source.

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 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 Example2()
        {
            var sqlQueryBuilder = new SqlQueryBuilder();

            // Gets DepartmentID values and Name values from the "Department" table, and Title values from the "Course" table.
            // Sets to join "Department" table and "Course" table by: Department.DepartmentID = Course.DepartmentID.              
            // Specifies "CourseTable" as the alias for the table ("Course") to join.
            sqlQueryBuilder
                .Select("Department.DepartmentID")
                .Select("Department.Name")
                .Select("CourseTable.Title")
                .From("Department")
                .Join("Course", "CourseTable")
                .OnRaw("Department.DepartmentID = CourseTable.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],
                [CourseTable].[Title]
              FROM [Department]
              JOIN [Course] AS [CourseTable]
              ON [Department].[DepartmentID] = [CourseTable].[DepartmentID]
            */
        }
    }
}

Applies to

.NET Standard

2.x