Ef6 + mysql bug, ef6mysqlbug

Ef6 + mysql bug, ef6mysqlbug

EntityFramework6 In the mysql database, a bug occurs when you sort by using linq.

Expression <Func <blog, bool> expr_filter = p => (area = ""? True: p. areaName = area );

IQueryable <blog> viewBlog = blogList_AllList.Where (expr_filter). OrderByDescending (p => p. createDate );

The above code will report an inexplicable nullrefrenceException

After trial, it is concluded that if expression uses the Three-object operator to implement dynamic SQL, it cannot use orderBy, and the two can only use one

Remedy: The expression does not use the three-object operator and is implemented using the if... else... condition.

At present, mysql does not seem to provide any solutions, and it is hoped that the trainees will not be killed.