public void Clean()
{
var deleted = fileDb.DeleteRecords(new FilterExpression(expiresField, DateTime.UtcNow, ComparisonOperatorEnum.LessThan));
if (deleted > 0)
{
Debug.WriteLine("FileDbCache: Deleted {0} expired items.", deleted);
fileDb.Clean();
}
}
private void BtnRemoveByValue_Click(object sender, RoutedEventArgs e)
{
try
{
FilterExpression searchExp = new FilterExpression("FirstName", "Nancy", EqualityEnum.Equal, MatchTypeEnum.UseCase);
int numDeleted = _db.DeleteRecords(searchExp);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public int DeleteRecord()
{
FileDb _db = new FileDb();
_db.Open(DBFILE, false);
// the easy way, using the expression parser
// FilterExpressionGroup srchExpGrp = FilterExpressionGroup.Parse
//("(FirstName ~= 'andrew' OR FirstName ~= 'nancy') AND LastName = 'Fuller'");
FilterExpressionGroup srchExpGrp = FilterExpressionGroup.Parse
("FirstName = 'Nancy'");
var ret = _db.DeleteRecords(srchExpGrp);
_db.Dispose();
return(ret);
}
public int DeleteRecord()
{
FileDb _db = new FileDb();
_db.Open(DBFILE, false);
// the easy way, using the expression parser
// FilterExpressionGroup srchExpGrp = FilterExpressionGroup.Parse
//("(FirstName ~= 'andrew' OR FirstName ~= 'nancy') AND LastName = 'Fuller'");
FilterExpressionGroup srchExpGrp = FilterExpressionGroup.Parse
("FirstName = 'Nancy'");
var ret = _db.DeleteRecords(srchExpGrp);
_db.Dispose();
return ret;
}
