Recently I started to write the MyGeneration template which is uncommon. Basically all template generates stored procedures that are common that is Load,LoadByPrimaryKey,LoadByForeignKey,Insert,Update,Delete. But we need some custom functionality like search. For that we need to write stored procedure, entity and code that access the stored procedure and return result.
I made a MyGeneration template which can allow you to do that. Currently it is in initial testing phase. Once it is completed, I will post it on the MyGeneration Template Library. Also I will post once it would be on MyGenerationSoftware website. If you need this template urgently, you can message me on this post.