操作本地数据库

1.创建实体 注意加Table和Column特性

 /// <summary>
    /// 课程类
    /// </summary>
    [Table] //表示类将成为一个table
    public class Course : INotifyPropertyChanged, INotifyPropertyChanging
    {
        [Column(IsVersion = true)] //table的列
        private Binary _version;

        private int _id;
        [Column(IsPrimaryKey=true,IsDbGenerated=true)] //table的列，主键，自动生成
        public int Id
        {
            get { return _id; }
            set 
            {
                if (_id != value)
                {
                    RaiseProtertyChanging("Id");
                    _id = value;
                    RaisePropertyChanged("Id");
                }
            }
        }

        private string _name;
        [Column]
        public string Name
        {
            get { return _name; }
            set
            {
                if (_name != value)
                {
                    RaiseProtertyChanging("Name");
                    _name = value;
                    RaisePropertyChanged("Name");
                }
            }
        }

        private string _location;
        [Column]
        public string Location
        {
            get { return _location; }
            set
            {
                if (_location != value)
                {
                    RaiseProtertyChanging("Location");
                    _location = value;
                    RaisePropertyChanged("Location");
                }
            }
        }

        public event PropertyChangedEventHandler PropertyChanged;

        private void RaisePropertyChanged(string propertyName)
        {
            if (PropertyChanged != null)
            {
                PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
            }
        }

        public event PropertyChangingEventHandler PropertyChanging;

        private void RaiseProtertyChanging(string propertyName)
        {
            if (PropertyChanging != null)
            {
                PropertyChanging(this, new PropertyChangingEventArgs(propertyName));
            }
        }
    }

2.创建类继承DataContext,而且封装this.GetTable<Course>()方法,否则创建数据库时报错

 public class MyDataContext : DataContext
    {
        //连接字符窜
        public const string ConnectionString = "Data Source=isostore:/MyDb.sdf";

        //构造函数
        public MyDataContext()
            : base(ConnectionString)
        {
            if (!this.DatabaseExists())
            {
                //创建数据库
                this.CreateDatabase();
            }
        }
        //必须存在，否则创建数据库报错：DataContext不存在表
        public Table<Course> CourseTable
        {
            get { return this.GetTable<Course>(); }
        }
    }

3.页面前台代码

<!--ContentPanel - 在此处放置其他内容-->
        <Grid x:Name="ContentPanel" Grid.Row="1" Margin="12,0,12,0">
            <Grid.RowDefinitions>
                <RowDefinition Height="Auto"/>
                <RowDefinition Height="*"/>
            </Grid.RowDefinitions>
            <StackPanel Grid.Row="0" Orientation="Horizontal">
                <Button Content="添加" Click="Button_Click" />
                <Button Content="编辑" Click="Button_Click_1" />
                <Button Content="删除" Click="Button_Click_2" />
            </StackPanel>
            <ListBox Grid.Row="1" Name="CourseList">
                <ListBox.ItemTemplate>
                    <DataTemplate>
                        <Grid>
                            <Grid.ColumnDefinitions>
                                <ColumnDefinition Width="Auto"/>
                                <ColumnDefinition Width="Auto"/>
                                <ColumnDefinition Width="Auto"/>
                            </Grid.ColumnDefinitions>
                            <TextBlock Grid.Column="0" Text="{Binding Id,Mode=TwoWay}"/>
                            <TextBlock Grid.Column="1" Text="{Binding Name,Mode=TwoWay}"/>
                            <TextBlock Grid.Column="2" Text="{Binding Location,Mode=TwoWay}"/>
                        </Grid>
                    </DataTemplate>
                </ListBox.ItemTemplate>
               
            </ListBox>
        </Grid>

4.页面后台代码

添加：调用GetTable<T>().InsertOnSubmit(T)方法，最后调用SubmitChanges()向数据库提交数据。

删除:  GetTable<T>().DeleteOnSubmit(T)方法，最后调用SubmitChanges()向数据库提交数据。

编辑：调用SubmitChanges()

页面绑定的数据源必须是ObservableCollection类型

 public partial class MainPage : PhoneApplicationPage
    {
        private ObservableCollection<Course> Courses;
        private DataContext _data;
        // 构造函数
        public MainPage()
        {
            InitializeComponent();
            //创建数据库
            //CreateDatabase();
            _data = new MyDataContext();
            //初始化数据
            InitData();
        }

        private void CreateDatabase()
        {
           _data = new MyDataContext();
            if (!_data.DatabaseExists())
            {
                _data.CreateDatabase();
            }
        }

        private void InitData()
        {
            Courses = new ObservableCollection<Course>
           {
            new Course{Name="电子商务",Location="教学楼101"},
            new Course{Name="心理学",Location="教学楼101"},
            new Course{Name="高等数学",Location="教学楼101"},
            new Course{Name="网络营销",Location="教学楼101"},
           };
            foreach (var c in Courses)
            {
                _data.GetTable<Course>().InsertOnSubmit(c);//插入数据库
            }
            _data.SubmitChanges();
            this.CourseList.ItemsSource = Courses;
           
        }
        //添加事件
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            Course c = new Course()
            {
                Name = "客户关系管理",
                Location = "教学楼401"
            };
            Courses.Add(c);
            _data.GetTable<Course>().InsertOnSubmit(c);
            _data.SubmitChanges();
        }
        //编辑事件
        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            Course c = Courses.First(s => s.Name == "网络营销");
            c.Location = "编辑教学楼";
            _data.SubmitChanges();
            
        }
        //删除事件
        private void Button_Click_2(object sender, RoutedEventArgs e)
        {
            Course c = Courses.First(s => s.Name == "电子商务");
            Courses.Remove(c);
            _data.GetTable<Course>().DeleteOnSubmit(c);
            _data.SubmitChanges();
        }
    }