CodeSmith Community
Your Code. Your Way. Faster!

DBDocumenter Templates


posted by pwelter34
12-19-2005

Downloads: 772
File size: 76.9kB
Views: 4,040
DBDocumenter Templates
Filed under: ,
Requirements:
  * CodeSmith v3.0 or higher
  * Actipro's CodeHighlighter component (ActiproSoftware.CodeHighlighter) (included)

ActiproSoftware.CodeHighlighter is a great syntax highlighting component that is highlighly customizable, fast, and (best of all) FREE! Please see http://www.codehighlighter.com/ for more details.

Setup & Running:

1.) Open dbdocs_properties.xml in your favorite text editor and edit your properties for your specific environment:
 
  - OutputDirectory
  This is the literal path that you want your documentation to generate to.  If this value is empty it will default to a sub-directorty called "output" in the directory that the template is located.
 
  - connectionString
  This is the connection string to the target database that you will be creating documentation for. Keep in mind that you must run this in the context of a user that has permissions to the Master database on the target server.
 
  - ServerName
  Simply the name of the target server. Unfortunately, at this time we cannot pull this information from the connection string.
 
  - DocumentationTitle
  This is the title of your documentation. This is placed as the literal title of each HTML page, and in a header on each page.

2.) Click build.bat and let it run! Keep in mind, the batch file relies on the CodeSmith console application (cs.exe), and hardcodes the assumed path to this executable (c:\Program Files\CodeSmith\v3.0\). If this differs, please edit the build.bat accordingly.

3.) Check your output directory, and you should have a ton of newly built documentation!

Comments

ejsmith wrote Re: CodeSmith DBDocumenter Templates
on 12-20-2005 12:06 AM
These templates generate top quality database documentation.
adawy44 wrote Re: DBDocumenter Templates
on 03-22-2006 10:34 AM
please Assume i have apge meant to handle the basic operations of database(insert,update,...)how can i use this CodeSmith 3.1 with VS2003 for performing this without using the stored procedures?
Red Angel wrote Re: DBDocumenter Templates
on 06-14-2006 9:58 AM
I have a / char in some of my fileds name and it cause a crash in running build.bat (i'm using Codesmith 3.1.6) here is the dump: C:\Program Files\CodeSmith\v3.0\SampleTemplates\DBDocumenter>build CodeSmith DBDocumenter Templates v3.0 Author: Jason Alexander (jason@ngallery.org), Eric J. Smith Website: http://www.ngallery.org/dbdocumenter/ ------------------------------------------------------------- Beginning documentation... System.Data.SqlClient.SqlException: Line 10: Incorrect syntax near 'EM'. Unclosed quotation mark before the character string ') p'. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior , RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(Comm andBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startR ecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior be havior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at a.a(String ) at SchemaExplorer.SqlSchemaProvider.a(String , String , String , String , Str ing , String , String ) at SchemaExplorer.SqlSchemaProvider.GetExtendedProperties(String connectionSt ring, SchemaObjectBase schemaObject) at SchemaExplorer.SchemaObjectBase.get_ExtendedProperties() at _CodeSmith.TableDetailTemplate.__RenderMethod1(TextWriter writer, Control control) at CodeSmith.Engine.DelegateControl.Render(TextWriter writer) at CodeSmith.Engine.Control.RenderChildren(TextWriter writer) at CodeSmith.Engine.CodeTemplate.Render(TextWriter writer) at CodeSmith.Engine.CodeTemplate.RenderToFile(String path, Boolean overwrite) at _CodeSmith.TablesTemplate.Render(TextWriter writer) at CodeSmith.Engine.CodeTemplate.RenderToFile(String path, Boolean overwrite) at _CodeSmith.master_cst.Render(TextWriter writer) at CodeSmithConsole.EntryPoint.a(String[] ) Done. my field name that rise the error i suppose is "Importo EM/EF", i hope this helps fixing the problem, keep up with this nice template
Red Angel wrote Re: DBDocumenter Templates
on 06-14-2006 10:10 AM
i was wrong, it wasn't the / char causing the problem but the ' char, ie my filed "Quantita' EM/EF"
KMax wrote Re: DBDocumenter Templates
on 02-06-2007 12:20 PM
Hi, I have tried to visit http://www.ngallery.org/dbdocumenter/ but I have got only this message :( Service Unavailable. Is there any problems?
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems