C#

<br />
<br />
using System;<br />
using System.Collections.Generic;<br />
using System.Text;<br />
using System.Data.SqlTypes;<br />
using System.Data.SqlClient;<br />
using Microsoft.SqlServer.Server;<br />
<br />
<br />
public class CountForMe<br />
{<br />
    private System.Data.SqlClient.SqlConnection ProductionConnection;<br />
    private System.Data.SqlClient.SqlCommand spListTypeCodes;<br />
<br />
<br />
    [Microsoft.SqlServer.Server.SqlProcedure]<br />
    public static void HereWeBe()<br />
    {<br />
        /***<br />
         * this is the entry point for the stored procedure<br />
         * second attempt ta this to see what we can do<br />
         **/<br />
        // in order to call a nonstatic class from within a static class<br />
        // you must create the following reference to the class<br />
        // reference: <br />
        // ms-help://MS.VSExpressCC.v80/MS.NETFramework.v20.en/dv_cscomp/html/3ff67f11-bdf9-436b-bc0c-4fa3cd1925a6.htm<br />
        CountForMe cfm = new CountForMe();<br />
        cfm.GetData();<br />
        cfm = null;<br />
        //<br />
    }<br />
    private void GetData()<br />
    {<br />
        // initialize connection string<br />
        ProductionConnection = new System.Data.SqlClient.SqlConnection();<br />
        spListTypeCodes = new System.Data.SqlClient.SqlCommand();<br />
        //<br />
        ProductionConnection.ConnectionString = "{TAKEN OUT FOR SECURITY}";<br />
        // setup stored procedure<br />
        spListTypeCodes.CommandText = "dbo.[spListTypeCodes]";<br />
        spListTypeCodes.CommandType = System.Data.CommandType.StoredProcedure;<br />
        spListTypeCodes.Connection = ProductionConnection;<br />
        spListTypeCodes.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));<br />
        //<br />
        //<br />
        ProductionConnection.Open();<br />
        SqlDataReader myReader = spListTypeCodes.ExecuteReader();<br />
        if (myReader.HasRows)<br />
        {<br />
            string message = "";<br />
            // setup message to print to screen<br />
            message = "Type Code: " + myReader["TypeCode"].ToString() +<br />
                " Type Description: " + myReader["TypeDescription"].ToString() +<br />
                " Type Code deleted: " + myReader["TypeCodeDeleted"].ToString();<br />
            // now print message to list<br />
            SqlContext.Pipe.Send(message);<br />
        }<br />
        myReader.Close();<br />
        myReader = null;<br />
        ProductionConnection.Close();<br />
    }<br />
<br />
}<br />

<br />
Msg 6522, Level 16, State 1, Procedure spSecondAttempt, Line 0<br />
A .NET Framework error occurred during execution of user defined routine or aggregate 'spSecondAttempt': <br />
System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.<br />
System.Security.SecurityException: <br />
   at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)<br />
   at System.Security.PermissionSet.Demand()<br />
   at System.Data.Common.DbConnectionOptions.DemandPermission()<br />
   at System.Data.SqlClient.SqlConnection.PermissionDemand()<br />
   at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)<br />
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)<br />
   at System.Data.SqlClient.SqlConnection.Open()<br />
   at CountForMe.GetData()<br />
   at CountForMe.HereWeBe()<br />