c# - 如何用MYSQL通过WCF Service插入操作？

Question

我尝试通过 WCF 服务创建插入操作。这是我所做的。首先，我将向您展示我的项目结构

各文件说明:

IServiceClient.cs 包含服务契约组

[ServiceContract]
public interface IServiceClient
{
    [OperationContract]
    void InsertMaster();
}

Service.cs 包含数据契约组

[DataContract]
public class Service
{
    [DataMember]
    public string Id;
    [DataMember]
    public string Submitter;
    [DataMember]
    public string Comments;
    [DataMember]
    public DateTime TimeSubmitted;
}

ServiceClient.cs 包含插入到MYSQL操作等业务逻辑

public void InsertMaster()
{
    string query = "INSERT INTO movies (id, submitter, comments, time) VALUES(id, submitter, comments, time)";
    //open connection
    connection.Open();
    //create command and assign the query and connection from the constructor
    MySqlCommand cmd = new MySqlCommand(query, connection);
    //Execute command
    cmd.ExecuteNonQuery();
    //close connection
    connection.Close();
}

我的问题是，如何将 Data Contract 字段传递给 ServiceClient.cs，以便我可以编写一些 MYSQL 查询？ “字符串查询”只是我的演示，我想从数据契约(Contract)提供的值中插入

我的第二个问题是如何将数据契约字段加载到 WCF 测试客户端中？在我的客户端项目中使用它之前，我需要测试它是否可以工作

Answer 1

这是你需要修改的方式:

[ServiceContract]
public interface IServiceClient
{
    [OperationContract]
    void InsertMaster(Service ServiceObj);
}

[DataContract]
public class Service
{
    [DataMember]
    public string Id;
    [DataMember]
    public string Submitter;
    [DataMember]
    public string Comments;
    [DataMember]
    public DateTime TimeSubmitted;
}

public void InsertMaster(Service ServiceObj)
{
    string query = "INSERT INTO movies (id, submitter, comments, time) VALUES(ServiceObj.id, ServiceObj.submitter, ServiceObj.comments, ServiceObj.time)";
    //open connection
    connection.Open();
    //create command and assign the query and connection from the constructor
    MySqlCommand cmd = new MySqlCommand(query, connection);
    //Execute command
    cmd.ExecuteNonQuery();
    //close connection
    connection.Close();

}

一旦您使用 WCF 测试客户端进行测试，契约(Contract)就会出现。