The way you have tried to implemented "database server" side Regex
processing is not going to work because there is no way to push pure .Net methods to SQL.
There is a way to achieve the same behaviour using some additional tools, but they are dependent on the relational server that you are targeting and it's version.
Please tell us which database server you are targeting and we will send you a step by step guide how to implement it using OpenAccess.
Additionally you may want to apply Regex
transformations to the name
parameter before pushing it into the LINQ query. It will save some time during execution.
OpenAccess ORM Q2 2013 brings you a more powerful code generation and a unique Bulk Operations support with LINQ syntax. Check out the list of new functionality and improvements shipped with this release.