.net - Entity Framework Where(Func<Car, bool>) clause not going to server -
i want pass "where" clause method via method parameter have found clause not getting sent database server. query actual fetches of records , "where" applied ef in client application. here example demonstrate problem: // id name colour // ----------------------- // 3 red_car red // 4 white_car white // 5 blue_car blue using (qdbentities db = new qdbentities()) { // #1 - no variable "where" - sent server, result correct. foreach (var car in db.cars.where(r => r.colour == "red")) console.writeline(car.id + " " + car.name); // output: 3 red_car // profiler: ... [dbo].[car] [extent1] // n'red' = [extent1].[colour] // #2 - using variable "where" - not sent server, result correct. func<car, bool> = new func<car, bool>(r => r.colour == "red"); foreach (var car in db.cars.where(where)) console.writeline(car.id
