Class Insert

Insert documents/rows into a collection/table

@returns @ref Mysqlx::Resultset

Inheritance

System.Object

Insert

Implements

Google.Protobuf.IBufferMessage

Namespace: Mysqlx.Crud

Assembly: MySql.Data.dll

Version: 9.2.0

Syntax

public sealed class Insert : Google.Protobuf.IMessage<Insert>

Constructors

Insert()

Declaration

public Insert()

Insert(Insert)

Declaration

public Insert(Insert other)

Parameters

Type	Name	Description
Insert	other

Fields

ArgsFieldNumber

Field number for the "args" field.

Declaration

public const int ArgsFieldNumber = 5

Field Value

Type	Description
System.Int32

CollectionFieldNumber

Field number for the "collection" field.

Declaration

public const int CollectionFieldNumber = 1

Field Value

Type	Description
System.Int32

DataModelFieldNumber

Field number for the "data_model" field.

Declaration

public const int DataModelFieldNumber = 2

Field Value

Type	Description
System.Int32

ProjectionFieldNumber

Field number for the "projection" field.

Declaration

public const int ProjectionFieldNumber = 3

Field Value

Type	Description
System.Int32

RowFieldNumber

Field number for the "row" field.

Declaration

public const int RowFieldNumber = 4

Field Value

Type	Description
System.Int32

UpsertFieldNumber

Field number for the "upsert" field.

Declaration

public const int UpsertFieldNumber = 6

Field Value

Type	Description
System.Int32

Properties

Args

• values for parameters used in row expressions

Declaration

public Google.Protobuf.Collections.RepeatedField<Scalar> Args { get; }

Property Value

Type	Description
Google.Protobuf.Collections.RepeatedField<Scalar>

Collection

• collection to insert into

Declaration

public Collection Collection { get; set; }

Property Value

Type	Description
Collection

DataModel

• data model that the operations refer to

Declaration

public DataModel DataModel { get; set; }

Property Value

Type	Description
DataModel

Descriptor

Declaration

public static Google.Protobuf.Reflection.MessageDescriptor Descriptor { get; }

Property Value

Type	Description
Google.Protobuf.Reflection.MessageDescriptor

HasDataModel

Gets whether the "data_model" field is set

Declaration

public bool HasDataModel { get; }

Property Value

Type	Description
System.Boolean

HasUpsert

Gets whether the "upsert" field is set

Declaration

public bool HasUpsert { get; }

Property Value

Type	Description
System.Boolean

Parser

Declaration

public static Google.Protobuf.MessageParser<Insert> Parser { get; }

Property Value

Type	Description
Google.Protobuf.MessageParser<Insert>

Projection

• name of the columns to insert data into (empty if data_model is DOCUMENT)

Declaration

public Google.Protobuf.Collections.RepeatedField<Column> Projection { get; }

Property Value

Type	Description
Google.Protobuf.Collections.RepeatedField<Column>

Row

• set of rows to insert into the collection/table (a single expression with a JSON document literal or an OBJECT expression)

Declaration

public Google.Protobuf.Collections.RepeatedField<Insert.Types.TypedRow> Row { get; }

Property Value

Type	Description
Google.Protobuf.Collections.RepeatedField<Insert.Types.TypedRow>

Upsert

• true if this should be treated as an Upsert (that is, update on duplicate key)

Declaration

public bool Upsert { get; set; }

Property Value

Type	Description
System.Boolean

Methods

CalculateSize()

Declaration

public int CalculateSize()

Returns

Type	Description
System.Int32

ClearDataModel()

Clears the value of the "data_model" field

Declaration

public void ClearDataModel()

ClearUpsert()

Clears the value of the "upsert" field

Declaration

public void ClearUpsert()

Clone()

Declaration

public Insert Clone()

Returns

Type	Description
Insert

Equals(Insert)

Declaration

public bool Equals(Insert other)

Parameters

Type	Name	Description
Insert	other

Returns

Type	Description
System.Boolean

Equals(Object)

Declaration

public override bool Equals(object other)

Parameters

Type	Name	Description
System.Object	other

Returns

Type	Description
System.Boolean

GetHashCode()

Declaration

public override int GetHashCode()

Returns

Type	Description
System.Int32

MergeFrom(Google.Protobuf.CodedInputStream)

Declaration

public void MergeFrom(Google.Protobuf.CodedInputStream input)

Parameters

Type	Name	Description
Google.Protobuf.CodedInputStream	input

MergeFrom(Insert)

Declaration

public void MergeFrom(Insert other)

Parameters

Type	Name	Description
Insert	other

ToString()

Declaration

public override string ToString()

Returns

Type	Description
System.String

WriteTo(Google.Protobuf.CodedOutputStream)

Declaration

public void WriteTo(Google.Protobuf.CodedOutputStream output)

Parameters

Type	Name	Description
Google.Protobuf.CodedOutputStream	output

Implements

Google.Protobuf.IBufferMessage