Fuzzy lookup of names with a Dutch Metaphone implementation 10 February 2011 Diederik-Krols SQL Server Phonetic algorithms are heavily used to provide suggestions and corrections in spell checkers and also for searching and matching names. You could use such algorithms to populate autocomplete controls for the lookup of cities and streets, patients in a hospital, or reservations for a hotel stay. All... [More]
Building an Entity Framework 4.0 model on views: practical tips 01 February 2011 Diederik-Krols Entity Framework 4.0, SQL Server Many development teams and database administrators use views to create an abstraction layer on top of a physical data model. In this article I'll show you how to build an Entity Framework 4.0 (EF4) model upon such a set of views. I'll create a couple of views in SQL Server -some of them indexed-, im... [More]