<%-- Name: Blake Niemyjski --%> <%@ CodeTemplate Language="C#" TargetLanguage="Text" CompilerVersion="v3.5" Description="Shows off how to use SQL Functions." %> <%@ Property Name="SourceDatabase" Type="SchemaExplorer.DatabaseSchema" Category="Required" Description="Database that contain the stored procedures." IncludeFunctions="True" %> <%-- Register referenced assemblies. --%> <%@ Assembly Name="CodeSmith.CustomProperties" %> <%@ Assembly Name="SchemaExplorer" %> <%-- Import commonly used namespaces. --%> <%@ Import Namespace="CodeSmith.CustomProperties" %> <%@ Import Namespace="SchemaExplorer" %> <%@ Import Namespace="SchemaExplorer.Extensions" %> <% foreach (CommandSchema command in SourceDatabase.Commands) { %> Name: <%= command.Name %> Return Value: <%= command.Parameters["@RETURN_VALUE"].SystemType %> Is CLR: <%= command.ExtendedProperties.GetByKey(ExtendedPropertyNames.IsCLR) %> Is Aggregate Function: <%= command.ExtendedProperties.GetByKey(ExtendedPropertyNames.IsAggregateFunction) %> Is Scalar Function: <%= command.ExtendedProperties.GetByKey(ExtendedPropertyNames.IsScalarFunction) %> Is Table Valued Function: <%= command.ExtendedProperties.GetByKey(ExtendedPropertyNames.IsTableValuedFunction) %> Is Inline Table Valued Function: <%= command.ExtendedProperties.GetByKey(ExtendedPropertyNames.IsInlineTableValuedFunction) %> Is Multi Statement Table Valued Function: <%= command.ExtendedProperties.GetByKey(ExtendedPropertyNames.IsMultiStatementTableValuedFunction)%> <% } %>