Click here to Skip to main content
13,558,412 members
Click here to Skip to main content
Add your own
alternative version


55 bookmarked
Posted 4 Sep 2008
Licenced CPOL

ASP.NET 3.5 Sample Application of LINQ, WFC, JSON, and AJAX

, 4 Sep 2008
Rate this:
Please Sign up or sign in to vote.
A simple sample of LINQ, WCF, JSON, and AJAX.


The purpose of this article is to provide a working sample of a new .NET technologies. This sample contains a working example of calling a WCF service from AJAX and using the results in JavaScript via JSON. It will also provide you with an example of how to call a Stored Procedure in LINQ. This sample uses the Northwind database that you can download from Microsoft. In order to run the sample, you must change the connection string "NorthwindConnectionString" in the web.config to point to your copy of Northwind. The SearchCustomers Stored Procedure code is provided in a text file in the solution.


Often, developers are too busy actually working on applications to take the time to learn all of the new tools provided by Microsoft. I have seen some examples of LINQ, WCF, and JSON, but I wanted to put a simple example of each in one place.

An entity class to use with JSON

The class below is an entity that will be accessible in JavaScript. In order to access the properties via JSON, you need to add the appropriate attributes.

using System;
using System.Runtime.Serialization;
namespace WCF_AJAX.Data
    //Take note of the attributes Serializable, DataContract and DataMember
    //These are what make the object easily usable to you via JSON
    public class CustomerItem

        public string CustomerID {get;  set;}

        public string ContactName { get; set; }

        public CustomerItem()


Accessing the entity object via JSON

The markup file below gives an example of using the list of CustomerItems that is returned from the WCF Service. In order to use the JavaScript below, you need to have a ScriptManager and a reference to the ApplicationService (the WCF).

<asp:scriptmanager id="ScriptManager1" runat="server">
        <asp:servicereference path="~/Services/ApplicationService.svc">

The JavaScript:

function Search() {
   var textInput =$get("txtSearch");
   ApplicationService.searchCustomers(textInput.value, OnSearchComplete, OnError);

function OnSearchComplete(result) {
   var selectOfCustomers = $get("ddlCustomers");
   var customerItems = result;
   var pos = 0;
   for (var customerNo in customerItems) {
      var oOption = document.createElement("OPTION");
      oOption.text = customerItems[customerNo].ContactName;
      oOption.value = customerItems[customerNo].CustomerID
      selectOfCustomers.add(oOption, pos);
      pos += 1;

function OnError(result) {

Creating the WCF Service using LINQ to get your data

The class below is the WCF service called from the client. The AspNetCompatibilityRequirements attributes are required.

using System;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Activation;
using System.ServiceModel.Web;
using System.Collections.Generic;

namespace WCF_AJAX.Services
    [ServiceContract(Namespace = "")]
    [AspNetCompatibilityRequirements(RequirementsMode = 
    public class ApplicationService
        // Add [WebGet] attribute to use HTTP GET
        public List<data.customeritem>searchCustomers(string searchText)
            var listOfCustomerItems = new List<data.customeritem>();
            var dataContext = new Data.NorthwindDataContext();
            foreach (var result in dataContext.SearchCustomers(searchText))
                var item = new Data.CustomerItem();
                item.CustomerID = result.CustomerID;
                item.ContactName = result.ContactName;
            return listOfCustomerItems;

        // Add more operations here and mark them with [OperationContract]

The NorthwindDataContext class was created by the designer. There is no coding required to create the class. In order to use a Stored Procedure, you have to chose "Add New Item" from the solution and pick LINQ to SQL Classes. VS 2008 will add a DBML file to the project. Then, open the DBML file in design mode and drag the Stored Procedure from the Server Explorer tab's Data Connections.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Web Developer
United States United States

You may also be interested in...


Comments and Discussions

GeneralLiked your sample Pin
nursiko2-Feb-12 18:50
membernursiko2-Feb-12 18:50 
GeneralMy vote of 3 Pin
Pramod k patel24-Nov-11 19:00
memberPramod k patel24-Nov-11 19:00 
GeneralMy vote of 4 Pin
Tathagat Verma28-Sep-11 1:51
memberTathagat Verma28-Sep-11 1:51 
GeneralMy vote of 2 Pin
jason_999919-Feb-10 4:13
memberjason_999919-Feb-10 4:13 
QuestionWhat changes need to be done in cross domain case? Pin
prasad v pathak11-Nov-08 1:52
memberprasad v pathak11-Nov-08 1:52 
QuestionNot getting jsdebug file Pin
prasad v pathak10-Nov-08 22:29
memberprasad v pathak10-Nov-08 22:29 
GeneralReminder: This Does Not Work Across Domains Pin
Ken Cox18-Oct-08 11:18
memberKen Cox18-Oct-08 11:18 
GeneralTitle Pin
PIEBALDconsult4-Sep-08 16:33
memberPIEBALDconsult4-Sep-08 16:33 
GeneralRe: Title Pin
ToddHileHoffer5-Sep-08 2:07
memberToddHileHoffer5-Sep-08 2:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.180515.1 | Last Updated 4 Sep 2008
Article Copyright 2008 by ToddHileHoffer
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid