Windows Phone 九、SQLite数据库

public class Person 2 { 3 [PrimaryKey, AutoIncrement] 4 public int Id { get; set; } 5 [MaxLength(8)] 6 public string Name { get; set; } 7 public int Age { get; set; } 8 public char Gender { get; set; } 9 } Person

 1         private void Button_Click(object sender, RoutedEventArgs e)
 2         {
 3             //创建数据库（不存在情况创建，存在则打开）
 4             var connection = new SQLiteConnection("temp.db");
 5             //创建表
 6             connection.CreateTable<Person>();
 7             Person zhang = new Person();
 8             //zhang.Id = 1;
 9             zhang.Name = "letter zhang";
10             zhang.Age = 18;
11             zhang.Gender = ‘男‘;
12             //添加数据
13             var result = connection.Insert(zhang);//返回执行结果受影响行数
14             System.Diagnostics.Debug.WriteLine(result);
15             //更新操作
16             result = connection.Update(new Person { Id = 2, Name = "zhangsan", Age = 19 });
17             System.Diagnostics.Debug.WriteLine(result);
18             //读取数据
19             var temp = connection.Find<Person>(1);
20             System.Diagnostics.Debug.WriteLine(temp.Name);
21             //读取全部数据
22             var list = connection.Query<Person>("select * from Person where id>=?", 1);
23             foreach (var item in list)
24             {
25                 System.Diagnostics.Debug.WriteLine(item.Name);
26             }
27             //删除操作
28             connection.Delete<Person>(1);
29         }

 

Windows Phone 九、SQLite数据库

标签：

本文系统来源：http://www.cnblogs.com/includeling/p/4581609.html

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！