Show / Hide Table of Contents

    ISqlQueryBuilder.Distinct() Method

    .NET Standard 2.x

    Adds the DISTINCT keyword to the SELECT clause of the current object. It specifies that only unique rows can appear in the result set.

    Namespace: SnapObjects.Data

    Assembly: SnapObjects.Data.dll

    Syntax

      ISqlBuilder Distinct();
    

    Returns

    SnapObjects.Data.ISqlBuilder

    Returns an ISqlBuilder object which represents the current object.

    Examples

    The following code example demonstrates how to use the Distinct() method to filter the duplicate values from the query result.

    using SnapObjects.Data;
    using System;
    
    namespace Appeon.ApiDoc.ISqlQueryBuilderExamples
    {
        public class DistinctExample
        {
            private SchoolContext _context;
    
            public DistinctExample(SchoolContext dataContext)
            {
                // Sets Data Context.
                _context = dataContext;
            }
    
            public void Example()
            {
    
                // Declares SqlQueryBuilder.            
                var sqlbuilder = new SqlQueryBuilder();
    
                // Gets all the values of the "startdate" column from the "Department“ table.
                sqlbuilder.Select("startdate")
                    .From("Department", "dept");
    
                // Filters the duplicate values from the query result.
                sqlbuilder.Distinct();
    
                // Converts to raw SQL for the database corresponding to the data context.
                string sql = sqlbuilder.ToSqlString(_context);
    
                Console.WriteLine(sql);
                
                /*This code produces the following output:
                
                SELECT
                DISTINCT [startdate]
                FROM [Department] AS [dept]
                */
            }
        }
    }
    

    Applies to

    .NET Standard

    2.x

    Back to top Generated by Appeon