public void QueryEmptyValues() { InsertEmptyValues(false); using (var context = GetAllTypesDataContext()) { Assert.AreEqual(1, context.AllTypes.Count(x => VfpFunctions.Empty(x.BinaryChar) == true)); Assert.AreEqual(0, context.AllTypes.Count(x => VfpFunctions.Empty(x.BinaryChar) == false)); Assert.AreEqual(1, context.AllTypes.Count(x => VfpFunctions.Empty(x.BinaryMemo) == true)); Assert.AreEqual(0, context.AllTypes.Count(x => VfpFunctions.Empty(x.BinaryMemo) == false)); Assert.AreEqual(1, context.AllTypes.Count(x => VfpFunctions.Empty(x.BinaryVarChar) == true)); Assert.AreEqual(0, context.AllTypes.Count(x => VfpFunctions.Empty(x.BinaryVarChar) == false)); Assert.AreEqual(1, context.AllTypes.Count(x => VfpFunctions.Empty(x.Char) == true)); Assert.AreEqual(0, context.AllTypes.Count(x => VfpFunctions.Empty(x.Char) == false)); Assert.AreEqual(1, context.AllTypes.Count(x => VfpFunctions.Empty(x.Currency) == true)); Assert.AreEqual(0, context.AllTypes.Count(x => VfpFunctions.Empty(x.Currency) == false)); Assert.AreEqual(1, context.AllTypes.Count(x => VfpFunctions.Empty(x.Date) == true)); Assert.AreEqual(0, context.AllTypes.Count(x => VfpFunctions.Empty(x.Date) == false)); Assert.AreEqual(1, context.AllTypes.Count(x => VfpFunctions.Empty(x.DateTime) == true)); Assert.AreEqual(0, context.AllTypes.Count(x => VfpFunctions.Empty(x.DateTime) == false)); Assert.AreEqual(1, context.AllTypes.Count(x => VfpFunctions.Empty(x.Decimal) == true)); Assert.AreEqual(0, context.AllTypes.Count(x => VfpFunctions.Empty(x.Decimal) == false)); Assert.AreEqual(1, context.AllTypes.Count(x => VfpFunctions.Empty(x.Double) == true)); Assert.AreEqual(0, context.AllTypes.Count(x => VfpFunctions.Empty(x.Double) == false)); Assert.AreEqual(1, context.AllTypes.Count(x => VfpFunctions.Empty(x.Float) == true)); Assert.AreEqual(0, context.AllTypes.Count(x => VfpFunctions.Empty(x.Float) == false)); Assert.AreEqual(1, context.AllTypes.Count(x => VfpFunctions.Empty(x.Integer) == true)); Assert.AreEqual(0, context.AllTypes.Count(x => VfpFunctions.Empty(x.Integer) == false)); Assert.AreEqual(1, context.AllTypes.Count(x => VfpFunctions.Empty(x.Logical) == true)); Assert.AreEqual(0, context.AllTypes.Count(x => VfpFunctions.Empty(x.Logical) == false)); Assert.AreEqual(1, context.AllTypes.Count(x => VfpFunctions.Empty(x.Long) == true)); Assert.AreEqual(0, context.AllTypes.Count(x => VfpFunctions.Empty(x.Long) == false)); Assert.AreEqual(1, context.AllTypes.Count(x => VfpFunctions.Empty(x.Memo) == true)); Assert.AreEqual(0, context.AllTypes.Count(x => VfpFunctions.Empty(x.Memo) == false)); Assert.AreEqual(1, context.AllTypes.Count(x => VfpFunctions.Empty(x.VarChar) == true)); Assert.AreEqual(0, context.AllTypes.Count(x => VfpFunctions.Empty(x.VarChar) == false)); } }