序列化与反序列化

poorServer 代码

using System;
using System.IO;
using System.Text;
using System.Reflection;
using System.Runtime.InteropServices;
using System.EnterpriseServices;

[assembly: ApplicationName("POOLINGTEST")]
[assembly: AssemblyKeyFile("poolserver.snk")]

namespace PoolServer
{
[ObjectPooling(Enabled=true,MinPoolSize=0, MaxPoolSize=1,CreationTimeout=2000)]
[JustInTimeActivation(true)]
[ConstructionEnabled(Default="Workstation id=DEVELOPER;data source=DEVELOPER;initial catalog=pubs;user id=sa;password=;")]   //Text File to be created during construction

public class PooledFile : ServicedComponent
{
   private string strConnection;

   protected override void Construct(string constructString)
   {
    strConnection = constructString;
   }

   public string ConnectionString
   {
    get
    {
     return strConnection;
    }
   }
}
}

-------------------------------------------------------------------------------------------------------------------------------

Q1：抛出安全异常和远程异常。几乎是遵照样例完成，过程很顺利，没有产生任何语法错误，但产生时运行异常，如问题1。
      A1：Clinet需要向COM+存储过程远程调用发出参数SqlParameter[]，这是非基本类型，且Microsoft也没打算让它可序列化，当这些复杂对象通过网络传输时，必须在Client进行序列化，将SqlParameter[]序列化为二进制流，然后在远程接收到二进制流后，再进行反序列化，即将二进制流转换为SqlParameter[]。由于SqlParameter不支持序列化，只能“曲线救国”，设计一个类ESqlParameter，设置[Serializable]，并且在该类中实现可以和SqlParameter进行相互任意转换的方法，至此该运行时异常解除。
-------------------------------------------------------------------------------------------------------------------------------

序列化代码：

IFormatter formatter = new BinaryFormatter();
       FileStream file=new FileStream("MyFile.dat", FileMode.Create, FileAccess.ReadWrite, FileShare.None);   
       Stream stream=(Stream)(file);
       formatter.Serialize(stream, eparam);
       stream.Seek(0, SeekOrigin.Begin);           
       SqlDataReader dr = loader.executeQueryProcedure("prcGetEmpName", stream);     
       file.Close();     
       stream.Close();
-------------------------------------------------------------------------------------------------------------------------------

IFormatter formatter = new BinaryFormatter();
      Stream stream = new FileStream("MyFile.dat", FileMode.Open, FileAccess.Read, FileShare.Read);
      ESqlParameter[] eparam = (ESqlParameter []) formatter.Deserialize(stream);
      stream.Close();
      SqlParameter param = new SqlParameter();

      Q2：解决了Q1，但依然产生运行时异常，提示信道(管道)未注册、多次注册、安全异常等之类的异常。      A2：对于远程传递参数，尤其是非基本类型参数，接收、传递和处理时可能存在权限不够的问题，重新修改Remoting Server和Clinet注册信道的方法，以设置较为合适的权限。

-------------------------------------------------------------------------------------------------------------------------------

Remoting Server代码：

RemotingConfiguration.Applicati;
      RemotingConfiguration.RegisterActivatedServiceType(typeof(RemoteTest.SQLConnection));
      BinaryServerFormatterSinkProvider serverProvider = new BinaryServerFormatterSinkProvider();   
      BinaryClientFormatterSinkProvider clientProvider = new BinaryClientFormatterSinkProvider();   
      serverProvider.TypeFilterLevel = TypeFilterLevel.Full;   
      IDictionary props = new Hashtable();   
      props["port"]=9000;   
      TcpChannel channel = new TcpChannel(props,clientProvider,serverProvider);   
      ChannelServices.RegisterChannel(channel);

-------------------------------------------------------------------------------------------------------------------------------

Client代码：

RemotingConfiguration.RegisterActivatedClientType(typeof(RemoteTest.SQLConnection),"tcp://localhost:9000/TestLoader");
      BinaryServerFormatterSinkProvider serverProvider = new BinaryServerFormatterSinkProvider();   
      BinaryClientFormatterSinkProvider clientProvider = new BinaryClientFormatterSinkProvider();   
      serverProvider.TypeFilterLevel = TypeFilterLevel.Full;   
      IDictionary props=new Hashtable();   
      props["port"]=0;   
      TcpChannel channel = new TcpChannel(props,clientProvider,serverProvider);   
      ChannelServices.RegisterChannel(channel);   
      SQLConnection loader = new SQLConnection();
     
      至此，异常不再产生，经受了多数的测试。后来，受启发，将Remoting Server设计成托盘程序，类似于Microsoft SQL Server的服务管理器、MySQL和Tomcat等服务器程序，不占任务栏地盘，只需选择启动和停止，出现不同的图标和不同远程服务器的状态。