Show / Hide Table of Contents

    ISqlBuilder.Clone() Method

    .NET Standard 2.x

    Makes a copy of the current ISqlBuilder object.

    Namespace: SnapObjects.Data

    Assembly: SnapObjects.Data.dll

    Syntax

      ISqlBuilder Clone();
    

    Returns

    A copy of the current ISqlBuilder object.

    Examples

    The following code example demonstrates how to use the Clone method.

    using System;
    using SnapObjects.Data;
    
    namespace Appeon.ApiDoc.ISqlBuilderExamples
    {
        public class CloneExample
        {
            private readonly SchoolContext _context;
    
            public CloneExample(SchoolContext dataContext)
            {
                // Sets the data context
                _context = dataContext;
            }
    
            public void Example()
            {
                // Builds a SQL statement.
                var sqlBuilder = new SqlQueryBuilder();
    
                sqlBuilder.Select("name")
                        .From("Department");
    
                // Makes a copy.
                var sqlBuilderClone = (SqlQueryBuilder)sqlBuilder.Clone();
    
                // Adds the Where clause.
                sqlBuilderClone.WhereValue("DepartmentId", 1);
    
                string sql = sqlBuilder.ToSqlString(_context);
                Console.WriteLine("The SQL SELECT statement (sqlBuilder): \n{0}", 
                    sql);
    
                sql = sqlBuilderClone.ToSqlString(_context);
                Console.WriteLine();
                Console.WriteLine("The SQL SELECT statement (sqlBuilderClone): \n{0}", 
                    sql);
    
                /*This code produces the following output:
                
                The SQL SELECT statement:
                SELECT
                 [name]
                FROM [Department]
                WHERE ([DepartmentId] = 1)         
                */
    
                /* This code produces the following output:
    
                The SQL SELECT statement (sqlBuilder):
                SELECT
                 [name]
                FROM [Department]
    
                The SQL SELECT statement (sqlBuilderClone):
                SELECT
                 [name]
                FROM [Department]
                WHERE ([DepartmentId] = 1)
                */
            }
        }
    }
    

    Applies to

    .NET Standard

    2.x

    Back to top Generated by Appeon