MssqlInsertStrategy enum

How a row's key comes back from an insert.

Chosen when code is generated, not at runtime: whether OUTPUT is usable is a fact about the table that sys.triggers answers exactly.

Inheritance

• Object
• Enum
• MssqlInsertStrategy

Available extensions

• EnumName

Values

outputInserted → const MssqlInsertStrategy

INSERT … OUTPUT INSERTED.* VALUES … — one round trip, and defaults and computed columns come back too.

scopeIdentity → const MssqlInsertStrategy

INSERT …; SELECT SCOPE_IDENTITY() — for a table carrying an enabled trigger, where SQL Server rejects an OUTPUT clause without INTO (error 334). Only the identity value comes back.

noKeyReadback → const MssqlInsertStrategy

No identity column: nothing to read back.

Properties

hashCode → int

The hash code for this object.

no setter, inherited

index → int

A numeric identifier for the enumerated value.

no setter, inherited

name → String

Available on Enum, provided by the EnumName extension

The name of the enum value.

no setter

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

Methods

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited

Constants

values → const List<MssqlInsertStrategy>

A constant List of the values in this enum, in order of their declaration.