Calling custom stored procedures using CodeSmith

Calling a custom stored procedure using the .NetTiers template in CodeSmith couldn’t be easier. You just make sure your procedure uses the standard naming convention of _{TableName}_{CustomMethodName} and Bam!, your accessor is available on the appropriate Table related class.

However (there’s always a “however”) there is one thing to make sure everything returns nicely.  Make sure the fields returned in your custom stored procedure match up with those in your table, otherwise your custom method will return a generic DataSet.  By returning all the fields from your base table, .NetTiers is smart enough to provide you with a nice, enumerable, TList<myTableEntity> return value.  Handy!