presentation layer -> service -> server data
add .ado (model1.edmx) to entityframe data library
add webservice1.asmx to service .asp project
service project creates service
//~/service/webservice.asmxusing System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using entityframe;
namespace service
{
/// <summary>
/// Summary description for WebService1
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class WebService1 : System.Web.Services.WebService
{
[WebMethod]
public dto[] get_instructors()
{
var db = new CTTIEntities();
var instructors = db.Instructors.
Select(x => new dto
{
Id = x.Id,
FirstName = x.FirstName,
LastName = x.LastName
}).ToArray();
return instructors;
}
[WebMethod]
public void add(dto new_instructor)
{
var db = new CTTIEntities();
var i = new Instructor();
i.FirstName = new_instructor.FirstName;
i.LastName = new_instructor.LastName;
db.Instructors.Add(i);
db.SaveChanges();
}
}
}
--------------------------------------------------------
copy connection string from ~/entityframe/app.config
<connectionStrings>
<add name="CTTIEntities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string="data source=localhost;initial catalog=CTTI;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
</connectionStrings>
into
~/presentation/web.config
and ~/service/web.config
right click service project, select property
select webservice1.asmx as start page
right click on service project, set as start up project
run solution, see get_instructors method from webservice1.asmx
click invoke
get_instructors method returns instructor info
test is successful
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace service
{
public class dto
{
public int Id { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
}
}
//copy property from instructor.cs in entityframe (data) project
add service to presentation project
presentation consume service
click advanced
click add web reference
click web service in this solution
select webservice1
if new webmethod is added in ~/service/webservice1.asmx, right click -> update
~/presentation/default.aspx
objectdata source, select ~/presentation/xml_service/webservice1.asmx
data source from web reference get_instructor() method
select get_instructor method
service consumed
set presentation as start project
set data gridview source to objectdatasource
//~/presentation/default.aspx.cs
using object_form1.xml_service; //use service reference
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace object_form1
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
var ins = new dto();
ins.FirstName = TextBox1.Text;
ins.LastName = TextBox2.Text;
var proxy = new xml_service.WebService1(); //select service
proxy.add(ins); //method from service
Page.DataBind(); //update table/ data pull back from server
}
}
}
