Random rnd = new Random();
string strInsert = " Insert into Customer (Name,Email,Desc) values (@Name,@Email,@Desc)";
for (int i = 0; i < 5; i++)
{
string strInsert = " Insert into Customer (Name,Email,Desc) values (@Name,@Email,@Desc)";
for (int i = 0; i < 5; i++)
{
Customer tst = new Customer
{
Name = "Name " + i,
Email = Name + "@" + "aaa.com",
Desc = "Desc for " + i
};
rec = (Application.Current as App).db.Insert < Customer>(tst,strInsert);
}
System.Diagnostics.Debug.WriteLine("\nInserted 5 " + " rows\r\nGenerated in " + (DateTime.Now - start).TotalSeconds);
}
{
Name = "Name " + i,
Email = Name + "@" + "aaa.com",
Desc = "Desc for " + i
};
rec = (Application.Current as App).db.Insert < Customer>(tst,strInsert);
}
System.Diagnostics.Debug.WriteLine("\nInserted 5 " + " rows\r\nGenerated in " + (DateTime.Now - start).TotalSeconds);
}
2. 删除记录
删除操作更简单，如清单5所示。
清单5：
private void btnDel_Click(object sender, RoutedEventArgs e)
{
DateTime start = DateTime.Now;
string strDel = " Delete from Customer where ID="+ "(SELECT COUNT(*) FROM Customer)" ;
(Application.Current as App).db.Delete(strDel);
}
{
DateTime start = DateTime.Now;
string strDel = " Delete from Customer where ID="+ "(SELECT COUNT(*) FROM Customer)" ;
(Application.Current as App).db.Delete(strDel);
}
在上面的代码，客户表中的最后一个记录将被删除。显然，要编写复杂和全功能的SQL语句，你应该先熟悉SQLite数据库相关的语法。事实上，这并不是一件难事，因为有关于SQLite的教程在网站可以轻松搞到(例如这里http://www.sqlite.org/lang.html)。
二、总结
在本系列文章中，我向您介绍了一款强大且易于使用的支持Windows Phone 7开发的开源嵌入数据库系统-Sqlite Client for Windows Phone。正如您所看到的，在文中，我给出的仅仅是有关Sqlite Client for Windows Phone的入门性使用方法。但是，也看到了基于传统型SQL数据库操作知识，你可以轻松掌握Sqlite Client for Windows Phone的使用。尽管如此，有关这款软件的真正实用性的技巧性的东西，还有待读者您的进一步挖掘。
