BuildInsertCommand()

DbCommand System.Data.Common.DbCommandBuilder.BuildInsertCommand ( DataTableMapping mappings, DataRow dataRow )

inlineprivate

Definition at line 700 of file DbCommandBuilder.cs.

    {
        DbCommand dbCommand = InitializeCommand(InsertCommand);
        StringBuilder stringBuilder = new StringBuilder();
        int num = 0;
        string value = " (";
        stringBuilder.Append("INSERT INTO ");
        stringBuilder.Append(QuotedBaseTableName);
        DbSchemaRow[] dbSchemaRows = _dbSchemaRows;
        string[] array = new string[dbSchemaRows.Length];
        for (int i = 0; i < dbSchemaRows.Length; i++)
        {
            DbSchemaRow dbSchemaRow = dbSchemaRows[i];
            if (dbSchemaRow == null || dbSchemaRow.BaseColumnName.Length == 0 || !IncludeInInsertValues(dbSchemaRow))
            {
                continue;
            }
            object obj = null;
            string text = _sourceColumnNames[i];
            if (mappings != null && dataRow != null)
            {
                DataColumn dataColumn = GetDataColumn(text, mappings, dataRow);
                if (dataColumn == null || (dbSchemaRow.IsReadOnly && dataColumn.ReadOnly))
                {
                    continue;
                }
                obj = GetColumnValue(dataRow, dataColumn, DataRowVersion.Current);
                if (!dbSchemaRow.AllowDBNull && (obj == null || Convert.IsDBNull(obj)))
                {
                    continue;
                }
            }
            stringBuilder.Append(value);
            value = ", ";
            stringBuilder.Append(QuotedColumn(dbSchemaRow.BaseColumnName));
            array[num] = CreateParameterForValue(dbCommand, GetBaseParameterName(i), text, DataRowVersion.Current, num, obj, dbSchemaRow, StatementType.Insert, whereClause: false);
            num++;
        }
        if (num == 0)
        {
            stringBuilder.Append(" DEFAULT VALUES");
        }
        else
        {
            stringBuilder.Append(')');
            stringBuilder.Append(" VALUES ");
            stringBuilder.Append('(');
            stringBuilder.Append(array[0]);
            for (int j = 1; j < num; j++)
            {
                stringBuilder.Append(", ");
                stringBuilder.Append(array[j]);
            }
            stringBuilder.Append(')');
        }
        dbCommand.CommandText = stringBuilder.ToString();
        RemoveExtraParameters(dbCommand, num);
        InsertCommand = dbCommand;
        return dbCommand;
    }

References System.Data.Common.DbCommandBuilder._dbSchemaRows, System.Data.Common.DbCommandBuilder._sourceColumnNames, System.Data.Common.DbSchemaRow.AllowDBNull, System.Text.StringBuilder.Append(), System.array, System.Data.Common.DbSchemaRow.BaseColumnName, System.Data.Common.DbCommandBuilder.CreateParameterForValue(), System.Data.Common.DbCommandBuilder.GetBaseParameterName(), System.Data.Common.DbCommandBuilder.GetColumnValue(), System.Data.Common.DbCommandBuilder.GetDataColumn(), System.Text.RegularExpressions.i, System.Data.Common.DbCommandBuilder.IncludeInInsertValues(), System.Data.Common.DbCommandBuilder.InitializeCommand(), System.Data.Common.DbCommandBuilder.InsertCommand, System.Convert.IsDBNull(), System.Data.Common.DbSchemaRow.IsReadOnly, System.obj, System.Data.Common.DbCommandBuilder.QuotedBaseTableName, System.Data.Common.DbCommandBuilder.QuotedColumn(), System.Data.DataColumn.ReadOnly, System.Data.Common.DbCommandBuilder.RemoveExtraParameters(), System.text, System.Text.StringBuilder.ToString(), and System.value.

Referenced by System.Data.Common.DbCommandBuilder.GetInsertCommand(), and System.Data.Common.DbCommandBuilder.RowUpdatingHandlerBuilder().