ISqlJoinBuilder.InnerJoin(string table) Method

.NET Standard 2.x

Uses the INNER JOIN operator to join the original table source and the new table source to create a joined table.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Syntax

  ISqlJoinOnBuilder InnerJoin(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.

Examples

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

using SnapObjects.Data;
using System;

namespace Appeon.ApiDoc.ISqlJoinBuilderExamples
{
    public class InnerJoinExample
    {
        private readonly SchoolContext _context;

        public InnerJoinExample(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")
                .InnerJoin("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]
              Inner JOIN [Course]
                    ON [Department].[DepartmentID] = [Course].[DepartmentID]
            */
        }
    }
}

Applies to

.NET Standard

2.x