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; } }
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)); } }