Recently someone asked how to break apart multiple values stored together in a single field. I’ve written a number of variations of functions that perform this task in SQL Server. Purpose Some of you may ask why would you ever do such a thing. You
I have read lots of articles in the past couple years about provider model being either an anti-pattern, or not a pattern at all. Most people would agree that you should strive for SOLID code when working in a languages that supports object oriented programming.
Provider Model was introduced in 2004 during the beta’s for .net 2.0. Rob Howard: “The pattern itself is exceedingly simple and is given the name “provider” since it provides the functionality for an API. Defined, a provider is simply a contract between an API and