public void NonExistingEntitiesWithDifferentColumnNameShouldBeSelected() { using (var db = new NumberContext()) { // Save 200 numbers (1 to 200) to the database. var firstParity = new Parity() { Name = "Parity#1", UpdatedAt = DateTime.Now, UpdatedBy = "Me" }; var secondParity = new Parity() { Name = "Parity#2", UpdatedAt = DateTime.Now, UpdatedBy = "Me" }; db.BulkInsertAll(new BulkInsertRequest <Parity> { Entities = new List <Parity> { firstParity, secondParity }, EnableRecursiveInsert = EnableRecursiveInsert.Yes }); var thirdParyity = new Parity() { Name = "Parity#3", UpdatedAt = DateTime.Now, UpdatedBy = "Me" }; var parities = new List <Parity>(); parities.AddRange(db.Parities.ToArray()); parities.Add(thirdParyity); List <Parity> nonExistingParity = db.BulkSelectNotExisting <Parity, Parity>(new BulkSelectRequest <Parity>() { Items = new List <Parity> { firstParity, secondParity, thirdParyity }, KeyPropertyMappings = new[] { new KeyPropertyMapping { ItemPropertyName = "Id", EntityPropertyName = "Id" }, } }).ToList(); Assert.AreEqual(1, nonExistingParity.Count); } }