Adding Search functionality for external list in SharePoint

This post describes adding search functionality to external list that created using SharePoint designer. Create a list based on external content type and give a name, when you browse this list for editing, you will notice that values can be selected from the data picker control as shown below