@bkubicek I am surprised that a possible rewrite is necessary since you can use stored procedures inside of Entity Framework. I had the same problem for...

Amen brother!

As a developer having finished a couple of large projects using an ORM (Entity Framework) I can tell you that they add more than they take away. Most DBAs...

It is common wisdom that using sp_ will decrease performance since these procedures will first be searched within the Master database rather than in the database that it was...

I would suggest looking into the SOUNDEX functionality built into SQL Server http://msdn.microsoft.com/en-us/library/aa259235(SQL.80).aspx. This could help in certain instances while in your particular example in probably wouldn’t....