I've been piddling w/ this thing for the last hour and I can't seem to figure out why it's erroring out... I have a stored proc that I'm building that takes a bunch of parameters and builds a dynamic ...

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects. Every so often, I find myself wishing that I had a utility ...

I recently wrote a .NET web application for work. I always make a data access class with methods for getting data, but I usually just point the methods to stored procedures. This time, I decided to ...

You don't have to give up using dynamic SQL just because you're using Entity Framework. The Entity Framework SqlQuery method will give you back the flexibility of dynamic SQL and still let you work ...

Everyone wants faster database queries, and both SQL developers and DBAs can turn to many time-tested methods to achieve that goal. Unfortunately, no single method is foolproof or ironclad. But even ...