Windows phone 8 Sqlite queries to insert update delete in C# xaml app

Posted by : Sudhir Chekuri Sunday, 24 November 2013

C# code in windows phone 8 app with sqlite commands

string dbPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");

private void BtnUpdate_OnClick(object sender, RoutedEventArgs e)
{

using (var db = new SQLiteConnection(dbPath))
{
db.DeleteAll<RechargePlansData>();
db.RunInTransaction(() =>
{
for (int i = 0; i < d.l.Count; i++)
{
db.Insert(new RechargePlansData() { statename = 1, networkname = 1, categoryname = 1, amount = "2000", talktime = "2200", validity = "1 months", descriptiondata = "voda description1" });
}
});
}

private void BtnUpdate_OnClick(object sender, RoutedEventArgs e)
{
using (var db = new SQLiteConnection(dbPath))
{
var existing = db.Query<Person>("select * from Person").FirstOrDefault();
if (existing != null)
{
existing.FirstName = "Denis";
db.RunInTransaction(() =>
{
db.Update(existing);
});
}
}
}

private void BtnDelete_OnClick(object sender, RoutedEventArgs e)
{
using (var db = new SQLiteConnection(dbPath))
{
var existing = db.Query<Person>("select * from Person").FirstOrDefault();
if (existing != null)
{
db.RunInTransaction(() =>
{
db.Delete(existing);
});
}
}
}