3 ms·
Oracle Database beat C# to language-level iterator support by four years with pipelined functions as part of the 9i release in 2001. Its syntax uses "pipe row"
by steve_taylor 4y ago
Oracle Database beat C# to language-level iterator support by four years with pipelined functions as part of the 9i release in 2001. Its syntax uses "pipe row" instead of "yield return".
In fact, you can connect a .NET app to an Oracle Database, invoke a PL/SQL pipelined function and, while that function is emitting results via pipe row inside a PL/SQL for loop, your C# wrapper streams the results to its called via yield return inside a C# for loop.