Tortuga.Chain Namespace
Tortuga.Chain.CommandBuilders Namespace
Tortuga.Chain.Metadata Namespace

SqlServerMetadataCache..::..MaxParameters Property

Gets the maximum number of parameters in a single SQL batch.

Namespace:  Tortuga.Chain.SqlServer
Assembly:  Tortuga.Chain.SqlServer.MDS (in Tortuga.Chain.SqlServer.MDS.dll)

Syntax


public Nullable<int> MaxParameters { get; }
Public ReadOnly Property MaxParameters As Nullable(Of Integer)
	Get
public:
property Nullable<int^> MaxParameters {
	Nullable<int^> get ();
}

Field Value

The maximum number of parameters.

Remarks


Note that the documentation says 2100, but you need to subtract one for the SQL statement itself. https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15