// Built-in Record class version
//
void LinqSelect_Record()
{
//FilterExpression filterExp = FilterExpression.Parse( "LastName IN ('Fuller', 'Peacock')" );
FileDbNs.Table employees = _db.SelectRecords("LastName IN ('Fuller', 'Peacock')");
var query =
from e in employees
select new
{
ID = e["ID"],
Name = e["FirstName"] + " " + e["LastName"],
BirthDate = e["BirthDate"]
};
foreach (var employee in query)
{
Debug.WriteLine(employee.ToString());
}
}
private void BtnGetRecordsWithContains_Click(object sender, RoutedEventArgs e)
{
try
{
// different ways to search for LastName CONTAINS 'lever' with ignore case
// pre-compiled filter (which could be re-used repeatedly)
// this is the lowest level way to create a FilterExpression
var filterExp = new FilterExpression("LastName", "lever", ComparisonOperatorEnum.Contains, MatchTypeEnum.IgnoreCase);
// use ~ on the field name to indicate ignore case
filterExp = FilterExpression.Parse("~LastName CONTAINS 'lever'");
// using string expression directly in SelectRecords - it calls FilterExpression.Parse as above
FileDbNs.Table table = _db.SelectRecords("~LastName CONTAINS 'lever'");
displayRecords(table);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
