Tools for design recovery (reengineering) of C# source code with embedded sql statements ?

16 Sep 2005 12:32 PM

Aksel Lindberg

Wonder if somebody know if it exist som tools that makes it possible to get
a graphical overview of relationships between C# source code components and
their's interaction with the database tables/elemts (E.g SQL server
database)

A typecial rewengineering tool to get a grasp of a system with many
components acessing multiple tables in a rdm system.

A tool that parses the C# code for sql/(databse interaction) and presents
the interaction grahical in som way?

Many thanks

Aksel

16 Sep 2005 12:57 PM

David Portas

You can use SQL Server's Profiler to capture SQL statements issued by
an application if that helps. Of course it's good practice to perform
all database interaction through stored procedures and if your code
follows that practice then your task is presumably just a matter of
identifying which proc names are referenced where and then documenting
the procs, which might be done quite simply by querying the SYSCOMMENTS
table.

--
David Portas
SQL Server MVP
--

16 Sep 2005 2:16 PM

JT

In additional to using Profiler to trace objects referenced during runtime,
there are companies who have reverse engineering and project diagraming
products. Rational is one company that comes to mind.
http://www.devx.com/enterprise/Article/9749
http://www.objectsbydesign.com/tools/umltools_byCompany.html

A much cheaper alternative, that may serve your purpose, is to use a regular
expression based text search tool like Agent Ransack to parse your project
files for occurances of code that executes ADO commands, declares a data
bound object, etc. There is even a free version:
http://www.mythicsoft.com/agentransack/

Show quote

"Aksel Lindberg" <aksel.lindb***@ericsson.com> wrote in message
news:dgee18$vkl$1@news.al.sw.ericsson.se...
> Wonder if somebody know if it exist som tools that makes it possible to
> get a graphical overview of relationships between C# source code
> components and their's interaction with the database tables/elemts (E.g
> SQL server database)
>
> A typecial rewengineering tool to get a grasp of a system with many
> components acessing multiple tables in a rdm system.
>
> A tool that parses the C# code for sql/(databse interaction) and presents
> the interaction grahical in som way?
>
> Many thanks
>
> Aksel
>
>
>
>

28 Sep 2005 2:48 PM

dbahooker

aksel are you a kid in school?

i just have never imagine something like this.. are you really scared
of a cuople of hundred sql statements?

can't you just copy and paste them?

throw a little bit of elbow grease into it