gistfile1.cs

static void SqlBulkCopyExample(string connectionString, IEnumerable<Person> people)
{
    using (var dataTable = new DataTable())
    {
        dataTable.Columns.Add("Id");
        dataTable.Columns.Add("Name");
        dataTable.Columns.Add("SpouseName");
        dataTable.Columns.Add("BirthDate");
        dataTable.Columns.Add("Salary");
        dataTable.Columns.Add("IsMarried");
        dataTable.Columns.Add("Gender");

        foreach (var person in people)
        {
            var row = dataTable.NewRow();
            row["Name"] = person.Name;
            row["SpouseName"] = person.SpouseName;
            row["BirthDate"] = person.BirthDate;
            row["Salary"] = person.Salary;
            row["IsMarried"] = person.IsMarried;
            row["Gender"] = person.Gender;
            dataTable.Rows.Add(row);
        }

        using (var sqlConnection = new SqlConnection(connectionString))
        using (var bcp = new SqlBulkCopy(sqlConnection) { DestinationTableName = "People" })
        {
            sqlConnection.Open();
            bcp.WriteToServer(dataTable);
            sqlConnection.Close();
        }
    }
}