Tools for accessing databases from .NET code

Question

I was given a C # database that uses a SQL Server 2005 database. I would like to get an overview of the tables and database procedures that use the method bodies in the code to access; in the case of tables, I would also like to know the type of access (CREATE, DROP, SELECT, INSERT, UPDATE or DELETE). A String looking for these keywords and table / procedure names will take me a long way, except that the code uses very little bare SQL, mostly using DataSets and DataAdapters, and who knows what else.

This is not the first time I have been in this situation (with different languages ​​and DBMS).

What tools exist to help me with this task? Can you recommend an improvement on my idea of ​​finding strings?

PS: There is another question about SQL Server dependencies with some relevant answers.

Answer 1

sql server profiler. it will register every single call along with the procedure text ... and then you can export the profile trace to the table and query it :-)

http://msdn.microsoft.com/en-us/library/ms187929.aspx