Windows phone数据库SQLCE


		在wp 7.1中终于可以使用SQLCE了，要使用sqlce需要添加system.data.linq的命名空间的引用
要使用sqlce，首先要建立一个实体类，表示数据库中的一行的实例
using System.Data.Linq.Mapping;
using System.ComponentModel;
namespace WindowsPhoneSQLCE.App_Code
{   
 [Table]   
 public class Person : INotifyPropertyChanged, INotifyPropertyChanging  
  {      
  private int _id;
        //用户编号,该列自动生成,不可为空  
      [Column(IsPrimaryKey = true, IsDbGenerated = true, CanBeNull = false)]       
      public int Id       
     {         
      get { return _id; }           
      set
             {
                if (_id != value)
                {
                     OnPropertyChanging("Id");
                    _id = value;
                     OnPropertyChanged("Id");
                 }
                 _id = value;
             }
         }
        private string _name;
        //用户名称
         [Column]
        public string Name
         {
             get { return _name; }
             set
            {
                _name = value;
            }
        }
        private string _job;
        //用户工作
        [Column]
         public string Job
        {
             get { return _job; }
             set { _job = value; }
         }
        //属性更改完毕事件
         public event PropertyChangedEventHandler PropertyChanged;
        public void OnPropertyChanged(string propertyName)
         {
             if (PropertyChanged != null)
             {
                 PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
             }
         }
        //属性更改事件
         public event PropertyChangingEventHandler PropertyChanging;
        public void OnPropertyChanging(string propertyName)
         { 
           if (PropertyChanging != null) 
           { 
               PropertyChanging(this, new PropertyChangingEventArgs(propertyName));
             }  
      }
    }
 }
 
建立一个数据上下文
using System.Data.Linq;
namespace WindowsPhoneSQLCE.App_Code
 {
     //Person数据上下文
     public class PersonDataContext : DataContext
     {
         private const string dbConstring = "Data Source=isostore:/db.sdf";
        public PersonDataContext()
             : base(dbConstring) 
       {
        }
        public Table<Person> person;
     }
}
 
 
使用时 的前台布局
<phone:PhoneApplicationPage
     x:Class="WindowsPhoneSQLCE.MainPage"
     xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
     xmlns:phone="clr-namespace:Microsoft.Phone.Controls;assembly=Microsoft.Phone"
    xmlns:shell="clr-namespace:Microsoft.Phone.Shell;assembly=Microsoft.Phone"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    mc:Ignorable="d" d:DesignWidth="480" d:DesignHeight="768" 
   FontFamily="{StaticResource PhoneFontFamilyNormal}" 
   FontSize="{StaticResource PhoneFontSizeNormal}"  
  Foreground="{StaticResource PhoneForegroundBrush}"  
  SupportedOrientations="Portrait" Orientation="Portrait"  
  shell:SystemTray.IsVisible="True">
    <!--LayoutRoot is the root grid where all page content is placed-->
    <Grid x:Name="LayoutRoot" Background="Transparent">
        <Grid.RowDefinitions> 
           <RowDefinition Height="Auto"/>
        &nbs

补充：移动开发 , Windows Phone ,