Assembly For Stored Procedure

I was playing around with the CLR in writing assemblies for the sql server 2005 stored procedure.  I guess the example i found was for the beta version

This line is from the beta but no longer works.  Any ideas what will fix this.  There is no longer GetCommand property.

SqlCommand cmd = SqlContext.GetCommand();

 

 

Example

public partial class StoredProcedures{[Microsoft.SqlServer.Server.SqlProcedure]                                                                               public static void StoredProcedure1()

{

// Put your code here

SqlCommand cmd = SqlContext.GetCommand();

cmd.CommandText="select firstname + ' ' + lastname + as [name] from person.contact";

SqlDataReader rdr = cmd.ExecuteReader();

SqlPipe sp = SqlContext.GetPipe();

sp.Send(rdr);

}};