using ...System;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Activation;
using System.Collections.Generic;
using System.Text;
using EmployeesContext;
using EmployeesEntities;

namespace datagridcurd
...{
    [ServiceContract(Namespace = "")]
    [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]
    public class EmployeeInfoWCFService
    ...{
        [OperationContract]
        public List GetEmployees()
        ...{
            EmployeeModelDataContext db = new EmployeeModelDataContext();
            return db.Employees.ToList();
        }
        
        [OperationContract]
        public void Insert(Employees employee)
        ...{
            EmployeeModelDataContext db = new EmployeeModelDataContext();
            string employeename = employee.EmployeeName;
            int employeeage = employee.EmployeeAge;
            string strsql = "INSERT INTO Employee(EmployeeName,EmployeeAge)
              VALUES('" + employeename + "'," + employeeage.ToString() + ")";
            db.ExecuteCommand(strsql);
        }

        [OperationContract]
        public void Update(List employee)
        ...{
            EmployeeModelDataContext db = new EmployeeModelDataContext();
            employee.ForEach( x =>
            ...{
                int employeeid = x.EmployeeID;
                string employeename = x.EmployeeName;
                int employeeage = x.EmployeeAge;
                string strsql = "UPDATE Employee SET EmployeeName='" + employeename +
                  "',EmployeeAge=" + employeeage.ToString() + "WHERE EmployeeID=" + employeeid.ToString();
                db.ExecuteCommand(strsql);
            });
        }

        [OperationContract]
        public void Delete(Employees employee)
        ...{
            EmployeeModelDataContext db = new EmployeeModelDataContext();
            int employeeid = employee.EmployeeID;
            string strsql = "DELETE FROM Employee WHERE EmployeeID="+employeeid.ToString();
            db.ExecuteCommand(strsql);
        }

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

<UserControl
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    mc:Ignorable="d" xmlns:data="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Data"
x:Class="SilverlightClient.MainPage"
    d:DesignWidth="320" d:DesignHeight="240">
    <Grid x:Name="LayoutRoot" Background="White" Width="320" Height="240">
        <data:DataGrid x:Name="dgEmployee" Margin="8,8,8,48" Background="#FFCEDBE8"/>
        <Button x:Name="btnGetData" Height="30" HorizontalAlignment="Left" Margin="8,0,0,8"
VerticalAlignment="Bottom" Width="64" Content="GetData"/>
        <Button x:Name="btnInsert" Height="30" HorizontalAlignment="Left" Margin="88,0,0,8"
VerticalAlignment="Bottom" Width="64" Content="Insert"/>
        <Button x:Name="btnSave" Height="30" HorizontalAlignment="Right" Margin="0,0,88,8"
VerticalAlignment="Bottom" Width="64" Content="Save"/>
        <Button x:Name="btnDelete" Height="30" HorizontalAlignment="Right" Margin="0,0,8,8"
VerticalAlignment="Bottom" Width="64" Content="Delete"/>
    </Grid>
</UserControl>

using ...System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using System.Data.Services.Client;//引入System.Data.Services.Client命名空间
using SilverlightClient.EmployeeWCFServiceReference;//引入数据服务所在命名空间
using System.Collections.ObjectModel;//引入ObservableCollection所在命名空间

namespace SilverlightClient
...{
    public partial class MainPage : UserControl
    ...{
        List BoundData = new List();
        int rowCount = 0;
        bool isInsertOrUpdate = false;

        public MainPage()
        ...{
            InitializeComponent();
            this.btnGetData.Click += new RoutedEventHandler(btnGetData_Click);
            this.btnInsert.Click += new RoutedEventHandler(btnInsert_Click);
            this.btnSave.Click += new RoutedEventHandler(btnSave_Click);
            this.btnDelete.Click += new RoutedEventHandler(btnDelete_Click);
        }

        void btnDelete_Click(object sender, RoutedEventArgs e)
        ...{
            EmployeeInfoWCFServiceClient webClient = new EmployeeInfoWCFServiceClient();
            webClient.DeleteAsync(dgEmployee.SelectedItem as Employees);
            webClient.DeleteCompleted +=
new EventHandler(webClient_DeleteCompleted);
        }

        void webClient_DeleteCompleted(object sender, System.ComponentModel.AsyncCompletedEventArgs e)
        ...{
            ;
        }

        void btnSave_Click(object sender, RoutedEventArgs e)
        ...{
            if (isInsertOrUpdate)
            ...{
                EmployeeInfoWCFServiceClient webClient = new EmployeeInfoWCFServiceClient();
                webClient.InsertAsync(dgEmployee.SelectedItem as Employees);
                webClient.InsertCompleted +=
new EventHandler(webClient_InsertCompleted);
            }
            else
            ...{
                EmployeeInfoWCFServiceClient webClient = new EmployeeInfoWCFServiceClient();
                ObservableCollection updatemodel = new ObservableCollection();
                foreach (object o in dgEmployee.ItemsSource)
                ...{
                    updatemodel.Add(o as Employees);
                }
                webClient.UpdateAsync(updatemodel);
                webClient.UpdateCompleted +=
new EventHandler(webClient_UpdateCompleted);
            }
        }

        void webClient_UpdateCompleted(object sender, System.ComponentModel.AsyncCompletedEventArgs e)
        ...{
            ;
        }
        
        void  webClient_InsertCompleted(object sender, System.ComponentModel.AsyncCompletedEventArgs e)
        ...{
             ;
        }
        
        void btnInsert_Click(object sender, RoutedEventArgs e)
        ...{
            Employees u = new Employees();
            BoundData.Insert(rowCount, u);
            dgEmployee.SelectedIndex = rowCount;
            dgEmployee.BeginEdit();
            dgEmployee.ItemsSource = BoundData;
            isInsertOrUpdate = true;
        }

        void btnGetData_Click(object sender, RoutedEventArgs e)
        ...{
            EmployeeInfoWCFServiceClient webClient = new EmployeeInfoWCFServiceClient();
            webClient.GetEmployeesAsync();//异步调用
            webClient.GetEmployeesCompleted +=
new EventHandler(webClient_GetEmployeesCompleted);
        }

        void webClient_GetEmployeesCompleted(object sender, GetEmployeesCompletedEventArgs e)
        ...{
            BoundData = e.Result.ToList();
            dgEmployee.ItemsSource = BoundData;
            rowCount = BoundData.Count;
        }

    }
}