Creating The WCF Services Using Visual Studio

WCF Services

Windows Communication Foundation is a programming platform and runtime system for building, configuring, and deploying the network-distributed services. It is the latest service-oriented technology. Interoperability is the fundamental characteristic of WCF.

Steps to creating the WCF Services in Visual Studio

The WCF Services can be created very easily by using the following steps.

STEP 1 - Create a database using SQL server.

1. Database name: TestDatabase
2. Database table name: TestRecord

TestRecord Table

STEP 1 - Creating WCF Service 

Now, we can create WCF Service:

• Go to Visual Studio >> New >> select a project.

Now, click on the project, select WCF Service application, and provide a name for the Service.

Now, click on the OK button. Then, you will get 3 files in Solution Explorer.

1. IService.cs
2. Service.svc
3. Service.svc.cs

The following image shows the following files.

For inserting the data into the database, you need to write the following code in the IService1.csfile which contains the following two sections.

1. OperationContract
2. DataContract

The OperationContract section is used to add the service operations and a DataContract is used to add types to the service operations.

Iservice1.cs File

Now, we create a function in the OperationContract section of the Iservice1.cs file.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace WCFServiceForInsert {
    // NOTE: You can use the "Rename" command on the "Refactor" menu to change the interface name "IService1" in both code and config file together.
    [ServiceContract]
    public interface IService1 {
        [OperationContract]
        string InsertUserDetails(TestRecord testInfo);
        [OperationContract]
        DataSet SelectUserDetails();
        [OperationContract]
        bool DeleteUserDetails(TestRecord testInfo);
        [OperationContract]
        DataSet UpdateUserDetails(TestRecord testInfo);
        [OperationContract]
        void UpdateRegistrationTable(TestRecord testInfo);
    }
    // Use a data contract as illustrated in the sample below to add composite types to service operations.
    [DataContract]
    public class TestRecord {
        int userid;
        string username;
        string password;
        string country;
        string email;
        [DataMember]
        public int UserID {
            get {
                return userid;
            }
            set {
                userid = value;
            }
        }
        [DataMember]
        public string UserName {
            get {
                return username;
            }
            set {
                username = value;
            }
        }
        [DataMember]
        public string Password {
            get {
                return password;
            }
            set {
                password = value;
            }
        }
        [DataMember]
        public string Country {
            get {
                return country;
            }
            set {
                country = value;
            }
        }
        [DataMember]
        public string Email {
            get {
                return email;
            }
            set {
                email = value;
            }
        }
    }
}

Service.svc.cs File

In this file, we defined the definition of the function InsertUserDetails(TestRecord testInfo).

Now, replace the code with the following.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace WCFServiceForInsert {
    // NOTE: You can use the "Rename" command on the "Refactor" menu to change the class name "Service1" in code, svc and config file together.
    public class Service1: IService1 {
        public DataSet SelectUserDetails() {
            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=registration; UserID=sa; Password=wintellect");
            con.Open();
            SqlCommand cmd = new SqlCommand("Select * from TestRecord", con);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            cmd.ExecuteNonQuery();
            con.Close();
            return ds;
        }
        public bool DeleteUserDetails(TestRecord testInfo) {
            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=registration;UserID=sa; Password=wintellect");
            con.Open();
            SqlCommand cmd = new SqlCommand("delete from TestRecord where UserID=@UserID", con);
            cmd.Parameters.AddWithValue("@UserID", testInfo.UserID);
            cmd.ExecuteNonQuery();
            con.Close();
            return true;
        }
        public DataSet UpdateUserDetails(TestRecord testInfo) {
            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=registration;UserID=sa; Password=wintellect");
            con.Open();
            SqlCommand cmd = new SqlCommand("select * from TestRecord where UserID=@UserID", con);
            cmd.Parameters.AddWithValue("@UserID", testInfo.UserID);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            cmd.ExecuteNonQuery();
            con.Close();
            return ds;
        }
        public void UpdateRegistrationTable(TestRecord testInfo) {
            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=registration;UserID=sa; Password=wintellect");
            con.Open();
            SqlCommand cmd = new SqlCommand("update TestRecord set UserName=@UserName,Password=@Password,Country=@Country, Email=@Email where UserID=@UserID", con);
            cmd.Parameters.AddWithValue("@UserID", testInfo.UserID);
            cmd.Parameters.AddWithValue("@UserName", testInfo.UserName);
            cmd.Parameters.AddWithValue("@Password", testInfo.Password);
            cmd.Parameters.AddWithValue("@Country", testInfo.Country);
            cmd.Parameters.AddWithValue("@Email", testInfo.Email);
            cmd.ExecuteNonQuery();
            con.Close();
        }
        public string InsertUserDetails(TestRecord testInfo) {
            string Message;
            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=registration;UserID=sa; Password=wintellect");
            con.Open();
            SqlCommand cmd = new SqlCommand("insert into TestRecord (UserName,Password,Country,Email) values(@UserName,@Password,@Country,@Email)", con);
            cmd.Parameters.AddWithValue("@UserName", testInfo.UserName);
            cmd.Parameters.AddWithValue("@Password", testInfo.Password);
            cmd.Parameters.AddWithValue("@Country", testInfo.Country);
            cmd.Parameters.AddWithValue("@Email", testInfo.Email);
            int result = cmd.ExecuteNonQuery();
            if (result == 1) {
                Message = testInfo.UserName + " Details inserted successfully";
            } else {
                Message = testInfo.UserName + " Details not inserted successfully";
            }
            con.Close();
            return Message;
        }
    }
}

Open the service in the browser. Now, right-click on the service1.vcs -> open in browser:

Now, copy the URL.

URL - http://localhost:2268/Service1.svc

If you see that output similar to what I have shown, you have created the WCF services successfully. Now, you can integrate this WCF Service in your application. I will be using this WCF service application in my next blog with ASP.NET and performing the CRUD operation.