This is a suggestion to implement a feature where routines (such as stored procedures, functions, etc.) may be created directly in a CLR language without explicitly adding an assembly which was compiled separately (i.e., in Visual Studio).
This would be extremely convenient for simple routines; it would make development, testing, and maintenance much easier for some common scenarios.
CREATE FUNCTION MyFunc
public static SqlInt32 MyProc(SqlInt32 param)
return param * (9/5) + 32
/* Note: Should be possible to define additional private C# methods here as well, so that the above method can call them as helper methods. */