Templates

Template to generate NUnit test for an assembly

joseph_guadagno — Sun, 09 Mar 2008 01:25:54 GMT

This template will allow you to generate NUnit test classes for existing .NET assemblies.

Dynamic Search Stored Procedure Creation

kumar106 — Tue, 26 Feb 2008 10:25:58 GMT

It creates a most efficient dynamic stored procedure

Create Procedure dbo.SearchRP_Demand
@HCID int = 0,
@OPPID varchar(20) = '',
@StartDate datetime = '',
@EndDate datetime = '',
@HeadCount int = 0,
@JobID int = 0,
@DomainId int = 0,
@DomainName varchar(100) = '',
@EmpJAILevel varchar(50) = '',
@EmpJAILevelId int = 0,
@Location varchar(50) = '',
@LocationID int = 0,
@EmployeeType varchar(100) = '',
@EmployeeTypeId int = 0,
@SGName nvarchar(50) = '',
@SGID varchar(50) = ''
AS
BEGIN
Select
[HCID],
[OPPID],
[StartDate],
[EndDate],
[HeadCount],
[JobID],
[DomainId],
[DomainName],
[EmpJAILevel],
[EmpJAILevelId],
[Location],
[LocationID],
[EmployeeType],
[EmployeeTypeId],
[SGName],
[SGID]
FROM dbo.RP_Demand
WHERE
1 = Case When @HCID = 0 Then 1 When @HCID = HCID Then 1 END AND
1 = Case When @OPPID = '' Then 1 When OPPID like '%' + @OPPID + '%' Then 1 END    AND
1 = Case When @StartDate = '' Then 1 When @StartDate = StartDate Then 1 END    AND
1 = Case When @EndDate = '' Then 1 When @EndDate = EndDate Then 1 END    AND
1 = Case When @HeadCount = 0 Then 1 When @HeadCount = HeadCount Then 1 END AND
1 = Case When @JobID = 0 Then 1 When @JobID = JobID Then 1 END AND
1 = Case When @DomainId = 0 Then 1 When @DomainId = DomainId Then 1 END AND
1 = Case When @DomainName = '' Then 1 When DomainName like '%' + @DomainName + '%' Then 1 END    AND
1 = Case When @EmpJAILevel = '' Then 1 When EmpJAILevel like '%' + @EmpJAILevel + '%' Then 1 END    AND
1 = Case When @EmpJAILevelId = 0 Then 1 When @EmpJAILevelId = EmpJAILevelId Then 1 END AND
1 = Case When @Location = '' Then 1 When Location like '%' + @Location + '%' Then 1 END    AND
1 = Case When @LocationID = 0 Then 1 When @LocationID = LocationID Then 1 END AND
1 = Case When @EmployeeType = '' Then 1 When EmployeeType like '%' + @EmployeeType + '%' Then 1 END    AND
1 = Case When @EmployeeTypeId = 0 Then 1 When @EmployeeTypeId = EmployeeTypeId Then 1 END AND
1 = Case When @SGName = '' Then 1 When SGName like '%' + @SGName + '%' Then 1 END    AND
1 = Case When @SGID = '' Then 1 When SGID like '%' + @SGID + '%' Then 1 END
END

NHibernate VB.Net templates

Kev160967 — Thu, 24 Jan 2008 12:59:31 GMT

I've adapted Scott Beeler's C# templates to generate VB.Net code instead. I've also added a few extensions (documented in the notes for each template) and tidied the code up a wee bit. The templates currently generate against our entity framework, but there are minimal (documented) changes required to remove or change this. I've left it in, as I assume most people would have similar entity base classes they'd be generating against.

One of the changes I've made is to extract some of the property generated code into subtemplates. This was because the code was duplicated for joined sub classes, and I also think it makes the main template clear and easier to follow. There are three top level templates:

NHibernate.VB.cst - this generates your basic NHibernate mapped class in VB for a specified table
NHibernate.hbm.cst - this generates the NHibernate map file for a specified table
NHibernate.VBEnum.cst - this generates a non-mapped Enum & class for a specified table

I've not yet written a wrapper to control generation for an entire database, as I plan to do this via an XML configuration file, coupled with a tool to generate the file from a database. I've uploaded it now, as I'm likely to have to get more specific to our framework before I get a chance to do this.

Hope someone finds it useful!

Kev

"Instead Of" Triggers for Sql Server

groker — Thu, 20 Dec 2007 21:59:08 GMT

Thank you to Jamison for the script I based this on. This template creates "Instead of" insert and update triggers for database tables. It uses a strait up column to column mapping, useful to run business rules involving before and after values.

ScriptTableDataFor2005.zip

Khaos — Mon, 26 Nov 2007 17:21:19 GMT

Microsoft AJAX Library templates

Milan Negovan — Mon, 26 Nov 2007 15:52:46 GMT

This collection of templates for the Microsoft AJAX Library allows you to code-gen interfaces, enumerations, classes, non-visual components, client controls, and behavior controls. Refer to readme.txt for installation instructions. I also have an overview video here.

SQL Server Audit Tables and Triggers

Jamison — Fri, 24 Aug 2007 19:37:16 GMT

CreateAuditTablesAndTriggers.cst creates audit tables and triggers for the selected tables. Uses a one audit table per source table strategy. Timestamp columns are ignored. <cheese>To get around a SQL Server issue with text and ntext columns in the "inserted" and "deleted" tables, only "inserted" data is logged.</cheese>Tested with MS SQL Server 2000.

SQL Server to SQL Server CE

Hector — Sun, 08 Jul 2007 03:06:47 GMT

This template creates SQL Server Compact 2005 Edition (CE) compatible DDL statements from a SQL Server 2005 database. It handles primary keys, but no foreign keys.

ScriptTableData2 Using Insert/Value Statements

Jamison — Tue, 12 Jun 2007 20:25:26 GMT

Script table data as a series of insert value statements. Tested with MS SQL Server 2000.

Updated CommandWrapperClass.cst which handles columns with no name

CarlosK — Thu, 17 May 2007 15:17:59 GMT

Corrected version.

Some simple modifications to CommandWrapperClass.cst which allow it to handle result set columns which have no name.

MySql Stored Procedures

phosphor — Thu, 15 Feb 2007 02:40:22 GMT

A modified version of Eric J. Smith 's stored procedure template that generates the stored procedures in a syntax compatible with MySQL's stored procedure format.

CSLA 2.0 Templates (VB)

ejsmith — Sun, 24 Sep 2006 17:01:09 GMT

Collection of CodeSmith templates for VB. These templates were tested against CSLA Framework v2.0.

CSLA 2.0 Templates (C#)

ejsmith — Sun, 24 Sep 2006 16:59:45 GMT

Collection of CodeSmith templates for C#. These templates were tested against CSLA Framework v2.0.

Create Data Transfer Objects from your Business Objects

Ripper — Fri, 14 Jul 2006 04:10:45 GMT

This template creates Data Transfer Objects from your Business Objects. Updated versions are on my blog:

http://thomasjaeger.wordpress.com/

Custom Event and Exception Class Templates

pwelter34 — Wed, 05 Apr 2006 23:15:16 GMT

The following templates generate custom exception and event classes. The classes follow the recommended pattern for each. The templates support the ability to add custom arguments to the class. These templates require CodeSmith 3.2.6.x or greater.