public partial class StoredProcedures
{
    [Microsoft.SqlServer.Server.SqlProcedure]

    public static void GetAllKnowledges()
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "Context Connection=true";

        SqlCommand cmd = new SqlCommand();
        cmd.Connection = conn;
        cmd.CommandText = @" SELECT BLABLA FROM BLABLA";

        conn.Open();

        SqlDataReader rdr = cmd.ExecuteReader();
        SqlContext.Pipe.Send(rdr);

        rdr.Close();
        conn.Close();
    
    }


};