Ejemplo n.º 1
0
 public static List<PersonModel> LoadAllPeople()
 {
     using (IDbConnection conn = new SQLiteConnection(LoadConnectionString()))
     {
         List<PersonModel> decryptedList = StringEncrypter.Decrypt(conn.Query<PersonModel>("Select * from Persons", new DynamicParameters()).ToList());
         return decryptedList;
     }
 }
Ejemplo n.º 2
0
 public static void SavePerson(PersonModel person)
 {
     using (IDbConnection conn = new SQLiteConnection(LoadConnectionString()))
     {
         conn.Execute("Insert into Persons (FirstName, LastName) values (@FirstName, @LastName)", StringEncrypter.Encrypt(person));
     }
 }