John,
>Question #1 Since the clr is now part of SQLServer is there any plan to add a VFP like assembly to SQLServer my thought is there is probably a need for a Yukon assembly that provides a base functionality for traversing a "VIEW" / Cursor record by record not SET/SET a couple of functions, commands should do it
>Question #2 Is there any plans to provide a Yukon clr based assembly (a rank newbee here so this question might not make any sense) kind of a way to send commands/programs to Yukon on the fly and get back info that a straight SQL statement can't do ??? kind of like codeblock / MM
In this upcoming version of SQL Server you will be able to write stored procedures in either C# or VB .NET...Microsoft knows that many developers DON'T write stored procedures (even when they should for performance reasons) because it's one other learning curve to climb (T-SQL). Other than what's been mentioned with Xen (data manipulation built right into the C# language...which will NOT ship any time in the near future) data access in .NET will continue to be collection-based...a DataSet will a collection of Tables, and Tables with collections of rows that you can scan through using foreach. That said, I think a lot of what you're looking to do can be accomplished right now by means of standard T-SQL.
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com