Documentation Home

Tip

All examples used are valid against the Microsoft Northwind Sample Database You can run the resulting SQL from the examples against Northwind in order to test and play with the SqlObjects library.

INSERT

Basic Insert

var sql = TSQL

    .INSERT().INTO("Categories")
      .COLUMN("CategoryName")
      .COLUMN("Description")
    .VALUES()
      .VALUE("Vegan")
      .VALUE("Exclusively plant-based food")
    .Build()

;

Console.WriteLine(sql);

Output:

INSERT INTO [Categories]
(
 [CategoryName],
 [Description]
) VALUES (
 'Vegan',
 'Exclusively plant-based food'
)

Basic Insert with Table Schema

var sql = TSQL

    .INSERT().INTO("dbo", "Categories")
      .COLUMN("CategoryName")
      .COLUMN("Description")
    .VALUES()
      .VALUE("Vegan")
      .VALUE("Exclusively plant-based food")
    .Build()

;

Console.WriteLine(sql);

Output:

INSERT INTO [dbo].[Categories]
(
 [CategoryName],
 [Description]
) VALUES (
 'Vegan',
 'Exclusively plant-based food'
)

Insert Using a Collection of Strings for Column Names

var columns = new List<string> { "CategoryName", "Description" };

var sql = TSQL

    .INSERT().INTO("dbo", "Categories")
      .COLUMNS(columns)
    .VALUES()
      .VALUE("Vegan")
      .VALUE("Exclusively plant-based food")
    .Build()

;

Console.WriteLine(sql);

Output:

INSERT INTO [dbo].[Categories]
(
 [CategoryName],
 [Description]
) VALUES (
 'Vegan',
 'Exclusively plant-based food'
)

Insert Using a Collection of Strings for Columns and Values

Specifying an IEnumerable<string> collection for the VALUES clause will produce parameters using the column names as a naming convention.

var columns = new List<string> { "CategoryName", "Description" };

var sql = TSQL

    .INSERT().INTO("dbo", "Categories")
      .COLUMNS(columns)
    .VALUES(columns)
    .Build()

;

Console.WriteLine(sql);

Output:

INSERT INTO [dbo].[Categories]
(
 [CategoryName],
 [Description]
) VALUES (
 @CategoryName,
 @Description
)

Insert Using a Collection of TSQLColumn Objects

var columns = new List<TSQLColumn>
{
    new TSQLColumn { ColumnName = "CategoryName" },
    new TSQLColumn { ColumnName = "Description" }
};

var sql = TSQL

    .INSERT().INTO("dbo", "Categories")
      .COLUMNS(columns)
    .VALUES()
      .VALUE("Vegan")
      .VALUE("Exclusively plant-based food")
    .Build()

;

Console.WriteLine(sql);

Output:

INSERT INTO [dbo].[Categories]
(
 [CategoryName],
 [Description]
) VALUES (
 'Vegan',
 'Exclusively plant-based food'
)

Insert Using a Collection of TSQLColumn Objects for Columns and Values

Specifying a collection of TSQLColumn objects for the VALUES clause will produce parameters using the column names as a naming convention.

var columns = new List<TSQLColumn>
{
    new TSQLColumn { ColumnName = "CategoryName" },
    new TSQLColumn { ColumnName = "Description" }
};

var sql = TSQL

    .INSERT().INTO("dbo", "Categories")
      .COLUMNS(columns)
    .VALUES(columns)
    .Build()

;

Console.WriteLine(sql);

Output:

INSERT INTO [dbo].[Categories]
(
 [CategoryName],
 [Description]
) VALUES (
 @CategoryName,
 @Description
)

Insert Using Explicit Parameter Names for the VALUES Clause

Parameter names can be specified for the VALUES clause manually.

var sql = TSQL

    .INSERT().INTO("dbo", "Categories")
      .COLUMN("CategoryName")
      .COLUMN("Description")
    .VALUES()
      .VALUE("@CategoryName")
      .VALUE("@Description")
    .Build()

;

Console.WriteLine(sql);

Output:

INSERT INTO [dbo].[Categories]
(
 [CategoryName],
 [Description]
) VALUES (
 @CategoryName,
 @Description
)

Insert Using a SELECT statement

var sql = TSQL

    .INSERT().INTO("dbo", "Categories")
      .COLUMN("CategoryName")
      .COLUMN("Description")
    .SELECT()
      .VALUE("Vegan")
      .VALUE("Exclusively plant-based food")
    .Build()

;

Console.WriteLine(sql);

Output:

INSERT INTO [dbo].[Categories]
(
 [CategoryName],
 [Description]
)
SELECT
 'Vegan',
 'Exclusively plant-based food'

Insert Using a SELECT Statement with a Collection of Strings

var columns = new List<string> { "CategoryName", "Description" };

var sql = TSQL

    .INSERT().INTO("dbo", "Categories")
      .COLUMNS(columns)
    .SELECT()
      .VALUES(columns)
    .Build()

;

Console.WriteLine(sql);

Output:

INSERT INTO [dbo].[Categories]
(
 [CategoryName],
 [Description]
)
SELECT
 @CategoryName,
 @Description

Insert Using a SELECT Statement with a Collection of TSQLColumn Objects

var columns = new List<TSQLColumn>
{
    new TSQLColumn { ColumnName = "CategoryName" },
    new TSQLColumn { ColumnName = "Description" }
};

var sql = TSQL

    .INSERT().INTO("dbo", "Categories")
      .COLUMNS(columns)
    .SELECT()
      .VALUES(columns)
    .Build()

;

Console.WriteLine(sql);

Output:

INSERT INTO [dbo].[Categories]
(
 [CategoryName],
 [Description]
)
SELECT
 @CategoryName,
 @Description