CodeSmith Community

Hi fellow nettier builders

I would like to change the template generating the stored procedures. Like the automatic check on timestamp columns i would like to implement that if a table has a column Active:bit then this should be included in the where sentence for Get methods.

 Any suggestions to fix this thing is most welcome much appriciated.

Thanks!

Ole

Found the solution

In file Dataaccesslayer.sqlclient/StoredProceduresXml.cst

I've added to the if (IncludeGetList) section:

<%if (ActiveCol != null){%>
    WHERE
     Active = 1
    <%}%>

And above in the

// Holds the ActiveCol column if there's any
  ColumnSchema ActiveCol = null;

foreach (ColumnSchema column in cols)
  {
   if ( ! IsIdentityColumn(column) && ! IsComputed(column) )
    colsUpdatable.Add(column);
    
   if (column.NativeType.ToLower() == "timestamp")
    RowVersion = column;
    
   if (column.Name.ToLower() == "active" && column.NativeType.ToLower() == "bit")
    ActiveCol = column;
  }