Hello,
first i must assume that i'm not very familiar with the C# yield keyword and its function. What is the best/easiest way to "translate" it into VB.NET? Especially i tried to convert this code into VB.NET, but i failed with:
yield return new MatchNode(++index, current.Value);
What i have is:
Imports System.Collections
Imports System.Data.SqlTypes
Imports System.Diagnostics.CodeAnalysis
Imports System.Text.RegularExpressions
Imports Microsoft.SqlServer.Server
Class MatchNode
Private _index As Integer
Private _value As String
Public Sub New(ByVal index As Integer, ByVal value As String)
_index = index
_value = value
End Sub
Public ReadOnly Property Index() As Integer
Get
Return _index
End Get
End Property
Public ReadOnly Property Value() As String
Get
Return _value
End Get
End Property
End Class
Class MatchIterator
Implements IEnumerable
Private _regex As Regex
Private _input As String
Public Sub New(ByVal input As String, ByVal pattern As String)
MyBase.New()
_regex = New Regex(pattern, UserDefinedFunctions.Options)
_input = input
End Sub
Public Function GetEnumerator() As IEnumerator Implements IEnumerable.GetEnumerator
Dim index As Integer = 0
Dim current As Match = Nothing
While (current Is Nothing OrElse current.Success)
If current Is Nothing Then
current = _regex.Match(_input)
Else
current = current.NextMatch()
End If
If current.Success Then
index += 1
'following should be a VB.Net yield'
Return New MatchNode(index, current.Value)
End If
End While
End Function
End Class
Partial Public Class UserDefinedFunctions
<SqlFunction(FillRowMethodName:="FillMatchRow", TableDefinition:="[Index] int,[Text] nvarchar(max)")> _
Public Shared Function RegexMatches(ByVal input As SqlChars, ByVal pattern As SqlString) As IEnumerable
Return New MatchIterator(New String(input.Value), pattern.Value)
End Function
Public Shared Sub FillMatchRow(ByVal data As Object, ByRef index As SqlInt32, ByRef text As SqlChars)
Dim node As MatchNode = CType(data, MatchNode)
index = New SqlInt32(node.Index)
text = New SqlChars(node.Value.ToCharArray)
End Sub
End Class