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