private static void InsertOnly <T, TId>(SQLiteConnection db, ISeedJson <T> json) where T : Entity <TId>, new() { foreach (var entity in json.Read()) { //var rowsAffected = db.Find<T>(entity.Id); var records = db.Table <T>().Count(); if (records == 0) { db.Insert(entity); } } }
private static void InsertOrUpdate <T>(SQLiteConnection db, ISeedJson <T> json) { // try // { foreach (var entity in json.Read()) { var rowsAffected = db.Update(entity); if (rowsAffected == 0) { db.Insert(entity); } } // } // catch (Exception e) // { // var s = json; // var m = e.Message; // throw; // } }