Why a func delegate in c# is not be translated to sql commands

This post explains why a Func delegate is not translated to appropriate SQL commands as one would except. The article also draws some source code from Microsoft reference source code to explain what happened when .Where() method is invoked on a func delegate.