Testing SQL Stored Procedures Using LINQ

Although there are several approaches you can take when testing SQL stored procedures, I have discovered that using LINQ dramatically simplifies test automation. In this month's column, I show you how to test SQL stored procedures using LINQ—specifically, using the LINQ to SQL provider. I'll assume you have intermediate level C# and SQL skills but no LINQ experience.