Table of Contents

Interface SqlFunctions.ISqlServerRegexpMatchRow

Namespace
NextORM.Core
Assembly
nextorm.core.dll

Row shape produced by regexp_matches(string?, string?): SQL Server 2025 returns one row per match with match_id bigint, the one-based start_position int and end_position int, the matched text as match_value varchar(n) and the capture groups as the engine's JSON text in substring_matches varchar(max). The substring_matches column is carried as an opaque string: its length is not fixed by the input, so it is never cast or truncated by the provider.

public interface SqlFunctions.ISqlServerRegexpMatchRow
Extension Methods

Properties

EndPosition

The one-based position of the last character of the match.

[Column("end_position")]
int EndPosition { get; set; }

Property Value

int

MatchId

The one-based match number.

[Column("match_id")]
long MatchId { get; set; }

Property Value

long

MatchValue

The matched text.

[Column("match_value")]
string? MatchValue { get; set; }

Property Value

string

StartPosition

The one-based position of the first character of the match.

[Column("start_position")]
int StartPosition { get; set; }

Property Value

int

SubstringMatches

The capture groups as the engine's JSON text (varchar(max)), never truncated.

[Column("substring_matches")]
string? SubstringMatches { get; set; }

Property Value

string