I have inherited a large application written as a .NET C# web project.
It's complete except it's missing the database component. Therefore all tables, procedures etc that originally ran in a Microsoft SQL Server now no longer exist and I don't think I will ever be able to find them again.
I have started to trawl through the code with a bunch of paper note lets, whenever a find a table I don't have a note for, I write it and the columns in that query on the note.
The problem is this approach is slow and very very error prone. It's very hard for me to identify foreign keys and relationships within the tables etc just by perusing the code base.
Am I missing a trick here? Are there any clever bits of software I can run across my code base that will help me to understand the database which originally backed this application?
Many thanks for any and all insight!