Beispiel #1
0
        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);
                }
            }
        }
Beispiel #2
0
        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;
//            }
        }