Show / Hide Table of Contents

    ISqlInsertBuilder.Column(string columnName, ISqlParameter parameter) Method

    .NET Standard 2.x

    Inserts dynamic data into the column of a table. The dynamic data will be specified by a SQL parameter when the SQL is executed.

    Namespace: SnapObjects.Data

    Assembly: SnapObjects.Data.dll

    Syntax

      ISqlInsertBuilder Column(string columnName, ISqlParameter parameter);
    

    Parameters

    columnName System.String

    The name of the column into which data will be inserted.

    parameter SnapObjects.Data.ISqlParameter

    An ISqlParameter object which represents a SQL parameter.

    It can be created by calling the SqlBuilder.Parameter method.

    Returns

    SnapObjects.Data.ISqlInsertBuilder

    Returns the current ISqlInsertBuilder object.

    Examples

    The following code example demonstrates how to use the Column(string columnName, ISqlParam parameter) method to insert dynamic data to the row. The dynamic data will be specified by a SQL parameter when the SQL is executed.

    using SnapObjects.Data;
    using System;
    
    namespace Appeon.ApiDoc.ISqlInsertBuilderExamples
    {
        public class ColumnExample
        {
            private SchoolContext _context;
    
            public ColumnExample(SchoolContext dataContext)
            {
                // Sets Data Context.
                _context = dataContext;
            }
    
            public void Example()
            {
                // Declares SqlInsertBuilder.
                var sqlbuilder = new SqlInsertBuilder();
    
                // Creates a SQL INSERT statement and inserts data into the "Department" table.
                // The data to be inserted is dynamic and will be specified when SQL is executed.
                sqlbuilder.Insert("Department")
                    .Column("DepartmentID", SqlBuilder.Parameter<int>("Id"))
                    .Column("Name", SqlBuilder.Parameter<string>("Name"))
                    .Column("Budget", SqlBuilder.Parameter<decimal>("Budget"))
                    .Column("StartDate", SqlBuilder.Parameter<DateTime>("curdate"));
    
                // Converts to raw SQL for the database corresponding to the data context.                   
                string sql = sqlbuilder.ToSqlString(_context);
    
                Console.WriteLine(sql);
    
                // Executes the SQL with the arguments passed in.
                var departments = _context.SqlExecutor
                    .Execute(sql, 20, "Chinese", 18000m, DateTime.Now);
    
                /*This code produces the following output:
                
                INSERT INTO Department([DepartmentID],
                [Name],
                [Budget],
                [StartDate]) VALUES(@Id,
                @Name,
                @Budget,
                @curdate) 
                */
            }
        }
    }
    

    Applies to

    .NET Standard

    2.x

    Back to top Generated by Appeon