Windows Phone 学习 创建和使用数据库

来源:互联网 发布:excel下拉菜单选择数据 编辑:程序博客网 时间:2024/06/05 20:06
   using (MyDataContex dc = new MyDataContex())            {                if (dc.DatabaseExists() == false)                {                    dc.CreateDatabase();                    System.Diagnostics.Debug.WriteLine(DateTime.Now.ToLongTimeString() + " 数据库创建完成。");                }                else                {                    System.Diagnostics.Debug.WriteLine(DateTime.Now.ToLongTimeString() + " 数据库已经存在。");                }            }
 public class TestEntity : INotifyPropertyChanging, INotifyPropertyChanged    {        private string _cityName;        /// <summary>        /// 公共属性,对应于表中的列        /// </summary>        [Column]        public string CityName        {            get            {                return this._cityName;            }            set            {                if (this._cityName != value)                {                    OnPropertyChanging("CityName");                    this._cityName = value;                    OnPropertyChanged("CityName");                }            }        }        public event PropertyChangingEventHandler PropertyChanging;        // 引发PropertyChanging事件        protected void OnPropertyChanging(string propertyName)        {            if (PropertyChanging != null)            {                PropertyChanging(this, new PropertyChangingEventArgs(propertyName));            }        }        public event PropertyChangedEventHandler PropertyChanged;        // 引发PropertyChanged事件        protected void OnPropertyChanged(string propertyName)        {            if (PropertyChanged != null)            {                PropertyChanged(this, new PropertyChangedEventArgs(propertyName));            }        }    }    /// <summary>    /// 从DataContext派生的类    /// </summary>    public class MyDataContex:DataContext    {        /// <summary>        /// 连接字符串        /// </summary>        public const string CONNECT_STRING = "Data Source='isostore:/db.sdf';Password='123456'";        /// <summary>        /// 构造函数        /// </summary>        public MyDataContex()            : base(CONNECT_STRING)        {        }        /// <summary>        /// 公共属性,对应于数据库中的表        /// </summary>        public Table<TestEntity> MyTestEntity;    }


0 0
原创粉丝点击