Generating CRUD procedure using StoredProcedures.cst

 I am trying to generate CRUD procedures on a table having column data type VarBinary(max). It seems the template is generating only "VarBinary" and not with max length. I thought I will debug this and tried to build the project under Codesmith projects - SqlSchemaProvider and getting the error "Cryptographic failure while signing assembly" and it is not able to find codesmith.snk file. Could someone help me how to build the project and If I have to fix the issue about the procedure, Do I need to fix it in SqlSchemaProvider.cs file. Please help me. I am using Codesmith prof.V4.1.

Second issue, I am not able to debug the template with VS2008. 

Thanks,

Ravi 

I'm having the same problem.  We've got a password field that is encrypted into a varbinary(100) column in our user table, but CodeSmith generates just:

@Password varbinary

instead of

@Password varbinary(100)

 The result is that when someone resets their password, the update stored procedure truncates the data to just one binary character. It's as if the stored procedure took

@Password varbinary(1)

 I'd prefer not to modify the CodeSmith application since it seems like a bug in CodeSmith rather than the StoredProcedures.cst file. 

 - Eck

 You need to fix it in BaseTemplates project. The file is SqlCodeTemplate.cs file and this is what I have done. Here is the code snippet.

        public string GetSqlParameterStatement(ColumnSchema column, bool isOutput)
        {
            string param = "@" + column.Name + " " + column.NativeType;
            if (column.NativeType.ToUpper() == "VARBINARY" && column.Size == -1) param += "(max)";
            if (column.NativeType.ToUpper() == "VARBINARY" && column.Size > 0) param += "(" + column.Size + ")";
            if (!this.IsUserDefinedType(column))
.....

Once you have the new dll "SchemaExplorer.SqlSchemaProvider.dll", copy to program files/codesmith/../AddIns

Ravi