Import csv to MySQL

load data local infile 'contacts.csv' into table contacts fields terminated by ','

enclosed by '"'

lines terminated by '\n'

(name, phone, address)

Service routing

Global.asax

// Assign address [/api/project] for ProjectService class.

protected void Application_Start(object sender, EventArgs e)

{

RouteTable.Routes.Add(new ServiceRoute("api/project", new WebServiceHostFactory(), typeof(ProjectService)));

}

ProjectService.cs

[ServiceContract]

AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]

public class ProjectService

{

// Assign address [/api/project/all] for GetAllProjects method

[OperationContract]

[WebInvoke(Method = "GET", BodyStyle = WebMessageBodyStyle.WrappedRequest, ResponseFormat = WebMessageFormat.Json, UriTemplate = "all")]

public List GetAllProjects()

{

// code

}

}

URL routing

Global.axas

// Assign address [/project] for [/Project.aspx]

protected void Application_Start(object sender, EventArgs e)

{

RouteTable.Routes.MapPageRoute("", "project", "~/Project.aspx");

}