WCF，MySQL和交易WCF、MySQL

2023-09-07 17:05:06 作者：安

我在Windows Communication Foundation的服务器应用程序具有MySql.Data.MySqlClient.MySqlTransaction的一个问题。

I am having a problem in MySql.Data.MySqlClient.MySqlTransaction in a Windows Communication Foundation Server Application.

我使用的是实现了的ServiceContract接口的类的方法内的MySqlTransaction，当我尝试运行服务，它抛出这个错误：

I am using the MySqlTransaction inside the method of the class that implements the ServiceContract Interface and it throws this error when I try to run the service:

System.Runtime.Serialization.InvalidDataContractException ：输入'MySql.Data.MySqlClient.MySqlTransaction不能被序列化。考虑与DataContractAttribute属性将其标记和标记所有成员想要序列化的DataMemberAttribute属性。如果类型是一个集合，考虑与CollectionDataContractAttribute其标记。

System.Runtime.Serialization.InvalidDataContractException: Type 'MySql.Data.MySqlClient.MySqlTransaction' cannot be serialized. Consider marking it with the DataContractAttribute attribute, and marking all of its members you want serialized with the DataMemberAttribute attribute. If the type is a collection, consider marking it with the CollectionDataContractAttribute.

我的code在WCF服务是simmilar这样：

My code in WCF service was simmilar to this:

[ServiceContract]
public interface IDALService
{
    MySqlCommand Command { [OperationContract] get; [OperationContract] set; }

    [OperationContract]
    void Execute(string cmdText);
}

[ServiceBehavior(IncludeExceptionDetailInFaults = true)]
public class DALService : IDALService
{
    public MySqlCommand Command { get; set; }

    public DALService()
    {
        Command = null;
    }

    public void Execute(string cmdText)
    {
        MySqlCommand SQLCom = this.Command??new MySqlCommand();
        SQLCom.CommandText = cmdText;

        if (this.Command == null)
        {
            SQLCom.CommandType = CommandType.Text;
            SQLCom.Connection = new MySqlConnection(/* ... */);
            SQLCom.Connection.Open();
            SQLCom.Transaction = SQLCom.Connection.BeginTransaction();
        }

        if (this.Command == null)
        {
            try
            {
                SQLCom.ExecuteScalar();
                SQLCom.Transaction.Commit();
            }
            catch { SQLCom.Transaction.Rollback(); throw; }
            finally { SQLCom.Connection.Close(); }
        }
        else SQLCom.ExecuteScalar();
    }
}

出现的错误只需键入的http：//本地主机：1257 / DALService.svc 在我Web浏览器。

The error occur just by typing the http://localhost:1257/DALService.svc in my web browser.

我使用的框架4，code在C＃中，在Microsoft Visual Studio 2010专业版。

I am using Framework 4, code in C#, in Microsoft Visual Studio 2010 Pro.

请帮忙。先谢谢了。

WCF，MySQL和交易WCF、MySQL

推荐答案