Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Solomon Rutzky CLR Table-Valued Function Example with Full Streaming (STVF) RE: CLR Table-Valued Function Example with Full Streaming (STVF)

  • December 24, 2009 at 12:02 pm

    #1096381

    Gift Peddie (12/23/2009)

    RBarryYoung (12/23/2009)

    C# "[font="Courier New"]yield break[/font]"? Yikes!

    I don't suppose there's a way to implement your example in VB.net, is there? (I don't know of any way to directly emulate [font="Courier New"]yield break[/font] in VB.)

    No yield is one those C# only definition because per Microsoft there is no valid reason to define it in VB.

    I already indicated that I knew that, Gift. Despite that fact that there is no deterministic general conversion for C# [font="Courier New"]yield break[/font], it is quite often possible to work out a case-specific method that can enable the same functionality in VB.net. Again, entirely dependent on the specific case, in this case, Solomon's clever method for streaming CLR-TVF data returns. It would be extremely valuable to me to be able to duplicate this performance in VB.net.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]