Good afternoon Ladies and Gents,
In my neverending quest to do things the best that I can, I come to you for suggestions. I recently have come into a situation that required me to use SQL stored procedures in my C# applications. I had been using LINQ to SQL and EF previously and had no experience with stored procedures. Embracing the SPROC methods but also providing same compatibility and object modeling as LINQ/EF I came up with the following class. I want to know how I can improve it.
Usage w/o parameters:
List<GenericClass> list = new StoredProcedureModel(_sqlConn, "ProcedureName").ToList<GenericClass>();
StoredProcedureModel spm = new StoredProcedureModel(sqlConnectionString, procedureName);
List<GenericClass> list = spm.ToList<GenericClass>();
/// Class to project SQL stored procedures into a strongly typed generic list.
/// The SQL column names must match the generic's parameters. Parameters that
/// don't match
View Complete Post