.asp wcf service

presentation -> wcf service ->database

add wcf_service as reference to presentation

add entity_frame as reference to wcf_service

copy connectionstring from app.config in entity_frame, paste it to web.config in both presentation and wcf_service

add service to wcf_service project

after rename service, make sure name also changed in markup view

//service_interface.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.ServiceModel.Web;

using System.Text;

using Wcf_service.domain;

namespace Wcf_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 service_interface

    {

        [OperationContract]

        List<dto> get_instructor();

        [OperationContract]

        void add_instructor(dto instructor);

        // TODO: Add your service operations here

    }

    // Use a data contract as illustrated in the sample below to add composite types to service operations.

    //[DataContract]

    //public class CompositeType

    //{

    //    bool boolValue = true;

    //    string stringValue = "Hello ";

    //    [DataMember]

    //    public bool BoolValue

    //    {

    //        get { return boolValue; }

    //        set { boolValue = value; }

    //    }

    //    [DataMember]

    //    public string StringValue

    //    {

    //        get { return stringValue; }

    //        set { stringValue = value; }

    //    }

    //}

}

--------------------------------------------------------

//service_method.cs //implement service interface

using ClassLibrary1; //entity_frame library

using System;

using System.Collections.Generic;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.ServiceModel.Web;

using System.Text;

using Wcf_service.domain;

namespace Wcf_service

{

    // NOTE: You can use the "Rename" command on the "Refactor" menu to change the class name "Service1" in code, svc and config file together.

    // NOTE: In order to launch WCF Test Client for testing this service, please select Service1.svc or Service1.svc.cs at the Solution Explorer and start debugging.

    public class service_method : service_interface

    {

        public void add_instructor(dto instructor)

        {           

            var i = new Instructor();

            i.FirstName = instructor.FirstName;

            i.LastName = instructor.LastName;

            var db = new CTTIEntities();

            db.Instructors.Add(i);

            db.SaveChanges();

        }

        public List<dto> get_instructor()

        {

            var db = new CTTIEntities();

            var instructors = db.Instructors.

                Select(x => new dto

                {

                    Id = x.Id,

                    FirstName = x.FirstName,

                    LastName = x.LastName

                }).ToList();

            return instructors;

        }

    }

}

--------------------------------------------------------

//~/wcfservie/domain/dto.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

namespace Wcf_service.domain

{

    public class dto

    {

        public int Id { get; set; }

        public string FirstName { get; set; }

        public string LastName { get; set; }

    }

}

add service reference to presentation

right click on reference -> add service reference -> discover -> expand tree view

select service reference under presentation as data source

add objectdatasource to listview

//default.aspx.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using Wcf_service.domain;

namespace wcf

{

    public partial class _default : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

        }

        protected void Button1_Click(object sender, EventArgs e)

        {

            var instructor = new dto();

            instructor.FirstName = TextBox1.Text;

            instructor.LastName = TextBox2.Text;

            //consume service

            var proxy = new wcf_service_reference.service_interfaceClient();

            proxy.add_instructor(instructor);

            Page.DataBind();

        }

    }

}