Create a SQL Procedure from C#

See more:

SQL

I am trying to create a SQL function from C#. The code for creating the function works fine in SQL but as soon as I try do it in C# it fails. I've narrowed it down to being the way C# formats the CommandText into a single line.

This is my code

#region Function Code
            string functionCode =String.Format(@"USE [{0}]
                                    SET ANSI_NULLS ON
                                    GO
                                    SET QUOTED_IDENTIFIER ON
                                    GO

                                    CREATE FUNCTION fn_KeyValue
                                    (
	                                    @tableName varchar(255),
	                                    @columnName varchar(255)
                                    )
                                    RETURNS varchar(100)
                                    AS
                                    BEGIN
	                                    DECLARE @result varchar(100)

	                                    SELECT @result = constraint_type
	                                    FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS a, INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE b
	                                    WHERE a.table_name= @tableName
	                                    AND a.constraint_name=b.constraint_name
	                                    AND b.column_name = @columnName

	                                    RETURN @result

                                    END
                                    GO", Settings.Instance);
            #endregion

            new SqlCommand()
            {
                CommandText = functionCode,
                CommandType = CommandType.Text,
                Connection = Settings.Connection
            }.ExecuteNonQuery();

The error I get is:

Incorrect syntax near 'GO'.
Incorrect syntax near 'GO'.
'CREATE FUNCTION' must be the first statement in a query batch.
Must declare the scalar variable "@tableName".
A RETURN statement with a return value cannot be used in this context.
Incorrect syntax near 'GO'

Is there a way for me to format my string so that SQL can understand it??