Convert SQL Server Table-Valued parameter to C# data access wrapper -


using codesmith 7, i'm trying generate c# data access wrapper. table-valued parameters show object in datatype , systemtype.

it boils down 2 issues:

  1. is there way of accessing user defined table type through codesmith? (so can generate c# datatable columns prefilled)

  2. is there way of ascertaining parameter user defined table type, , can set public/private properties datatable instead of object?

i work codesmith....

  1. yes, should available. can access via extendedproperties object (https://codesmith.atlassian.net/wiki/display/generator/using+extended+properties). if take look, put information available in extended properties around custom types.
  2. yes, via extended properties.