用SQL Server和XML学习Silverlight 2(1)(8)

[ServiceContract]
public interface ICustomerDesigns
{
    [OperationContract]
    List GetDesignsByUserId(string UserId);

    [OperationContract]
    int InsertNewCustomerWeddingImprintDesign
     (CustomerWeddingImprintDesign cstIDesign);

    [OperationContract]
    List GetDesignByAutoId(int AutoID);
}

#region ICustomerDesigns Members


public List GetDesignsByUserId(string UserId)
{
    try
    {
        DBAccessDataContext dc = new DBAccessDataContext();
 var matchingDesigns = from CustomerWeddingImprintDesigns 
in dc.CustomerWeddingImprintDesigns
                 where CustomerWeddingImprint
                 Designs.UserID.Equals(UserId) 
                select CustomerWeddingImprintDesigns;
        return matchingDesigns.ToList();
    }
    catch (System.Exception ex)
    {
        Console.WriteLine(ex.Message);
        return null;
    }
}

public List 
GetDesignByAutoId(int AutoID)
{
   DBAccessDataContext dc = new 
DBAccessDataContext();
    var matchingDesigns = from CustomerWeddingImprintDesigns 
in dc.CustomerWeddingImprintDesigns
                          where 
CustomerWeddingImprintDesigns.AutoID.Equals(AutoID)
                          select CustomerWeddingImprintDesigns;
    return matchingDesigns.ToList();
}

public int InsertNewCustomerWeddingImprintDesign
(CustomerWeddingImprintDesign custIDesign)
{
    try
    {
        DBAccessDataContext dc = new 
DBAccessDataContext(); 
        dc.CustomerWeddingImprintDesigns.

InsertOnSubmit(custIDesign);                
        // Insert count of changes to be made to the database
        System.Data.Linq.ChangeSet changes = dc.GetChangeSet();
        dc.SubmitChanges();
        return changes.Inserts.Count;
    }
    catch (System.Exception ex)
    {
        Console.WriteLine(ex.Message);
        return 0;
    }
}

#endregion}

protected override ServiceHost CreateServiceHost(Type serviceType, Uri 
[] baseAddresses)
{ 
// If more than one base address exists then return the second 
// address, otherwise return the first address
 (protected override ServiceHost CreateServiceHost
(Type serviceType, Uri[] baseAddresses)
{                       
    // If more than one base address exists then return the second 
    // address, otherwise return the first address
    //(You might be wondering why we're picking the second address here 
    //rather than the first.
    //For us, the second address holds the correct address for our 

deployment domain
    //www.silverlightblend.com. You may need to modify this code to return 
    //a different/custom base address depending on your IIS server configuration. 
    if (baseAddresses.Length > 1)
    {
        return new ServiceHost(serviceType, baseAddresses[1]);
    }
    else
    {
        return new ServiceHost(serviceType, baseAddresses[0]);
    }            
}

＜% @ ServiceHost 
Language="C#" Debug
="true" Service="DMSL2WeddingImprints_Web.CustomerDesigns" 
Factory="DMSL2WeddingImprints_Web.CustomHostFactory" 
CodeBehind="CustomerDesigns.svc.cs" %＞