Technical Support and Solutions: What is WCF ? Sample WCF application code in .NET

I this post will explain very basic sample WCF application 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
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 Iterface IService1.cs and one Serive class Service1.cs .

Interface :-

In the interface I declared one function to fetch Employee salary 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;

namespace WcfServiceDemo

{

[ServiceContract]

public interface IService1

{

[OperationContract]

[FaultContract(typeof(string))]

[WebInvoke(Method = "POST", UriTemplate = "GetEmpSalary/{EmpId}", RequestFormat = WebMessageFormat.Json,

ResponseFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.WrappedRequest)]

string GetEmpSalary(string EmpId);

}

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 WcfServiceDemo

{

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