public int save() { var path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite"); using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path)) { var infoTable = conn.GetTableInfo("User"); if (!infoTable.Any()) { // conn.DropTable<User>(); conn.CreateTable<User>(); } var info = conn.GetMapping(typeof(User)); if (this._user.UserID == 0) { //var i = conn.InsertOrReplace(this._user); var i = conn.Insert(this._user); conn.Commit(); // this._user.UserID = i; return i; } else { var i = conn.Update(this._user); return i; } } }
public int save() { var path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite"); using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path)) { var infoTable = conn.GetTableInfo("Eat"); if (!infoTable.Any()) { //conn.DropTable<Eat>(); conn.CreateTable <Eat>(); } var info = conn.GetMapping(typeof(Eat)); if (this._eat.EatID == 0) { var i = conn.Insert(this._eat); conn.Commit(); return(i); } else { var i = conn.Update(this._eat); return(i); } } }
private static int RowCount <T>(this SQLite.Net.SQLiteConnection connection) { //this could potentially create a new mapping if it doesn't exist in the connection already, alternative is to search //the TableMappings enumerable for an existing mapping but that would be slower return(connection.ExecuteScalar <int>(string.Format("select count(*) from {0}", connection.GetMapping <T>().TableName))); }