public void DeleteRecordByIdTest()
{
var sql = new SqLiteTable("familyMoney.db", "testBase",
"(id INTEGER PRIMARY KEY, Text_Entry NVARCHAR(2048) NULL)");
sql.InitializeDatabase();
var record = new List <KeyValuePair <string, object> >
{
new KeyValuePair <string, object>("Text_Entry", "\'Some Text \'")
};
sql.AddData(record);
sql.AddData(record);
sql.AddData(record);
sql.AddData(record);
var lastRecord = sql.AddData(record);
sql.DeleteRecordById(lastRecord);
var lines = sql.SelectAll();
sql.DeleteDatabase();
Assert.AreEqual(4, lines.Count());
}
public void SqLiteInitDatabaseTest()
{
var sql = new SqLiteTable("familyMoney.db", "testBase",
"(id INTEGER PRIMARY KEY, Text_Entry NVARCHAR(2048) NULL)");
sql.InitializeDatabase();
Assert.IsTrue(true);
}