Technical Support and Solutions: WCF REST sample web service

I this post will explain very basic sample WCF REST Service with example for beginers.

What is WCF :-

.NET provides various options for creating services under .NET Framework. Before WCF, ASP.NET Web Services are used to ceate service in .NET Framework. Now WCF is the latest programming model for building and developing service-oriented application. WCF allows applications to communicate with each other in distributed environment. WCF is a set of technologies that covers ASMX web services, Web Services Enhancements (WSE), .NET Remoting and MSMQ. In this article, you will learn How to create and consume your WCF application from client app.

Task List

WCF application (REST)
1 Database Table, 1 Stored Procedure to fetch Employee salary.
Client Application(ASP.NET app)

Creating WCF app:-

Open your Visual Studio go to file menu then select new project one window will open. Now in left tab Select WCF and in right tab select WCF Service Application and choose your app name, location then clock on OK button. See below

Now your WCF application is ready. It contains one Interface IService1.cs and one Service class Service1.cs .

using System;

using System.Collections.Generic;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.ServiceModel.Web;

using System.Text;

namespace WCF_Sample_REST_Service

{

// 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]

[FaultContract(typeof(string))]

// UriTemplate for REST Service

// UriTemplate = "formate?Param1={EmpId}&Param1={EmpName}"

[WebInvoke(Method = "POST", UriTemplate = "Json?EmpId={EmpId}&EmpName={EmpName}",

RequestFormat = WebMessageFormat.Json, ResponseFormat = WebMessageFormat.Json,

BodyStyle = WebMessageBodyStyle.Wrapped)]

string GetEmpSalary(string EmpId, string EmpName);

}

Service class:-

In below Service class I implimented above method see below

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.Web.Configuration;

using System.Data;

using System.Data.SqlClient;

namespace WCF_Sample_REST_Service

{

// REST WCF sevice...

public class Service1 : IService1

{

// first I will create an Instance of SqlConnection

static String conString = WebConfigurationManager.ConnectionStrings["TestWebCon"].ConnectionString;

static SqlConnection con = new SqlConnection(conString);

public string GetEmpSalary(string EmpId, string EmpName)

{

string result = string.Empty;

SqlCommand cmd = new SqlCommand("[dbo].[getEmployeeSalary]", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@EmpId ", EmpId);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

if (ds.Tables[0].Rows.Count > 0)

{

result = ds.Tables[0].Rows[0].ItemArray[0].ToString();

}

else

{

result = "Record not found!";

}

return result;

}

Note:- You can replace your Interface and service class code by above code.

Now I will Create a database table tblEmpMaster.

CREATE TABLE [dbo].[tblEmpMaster](

[EmpID] [int] NOT NULL,

[EmpName] [varchar](100) NOT NULL,

[EmpSalary] [int] NULL,

[Age] [int] NULL

) ON [PRIMARY]

Let me Insert some records in the above table

USE [Employee]