I'd like to submit a feature request for a future release of ReSharper - or perhaps someone would like to do this as a plugin.
One of ReSharper's strengths is the ability to navigate between symbols, find usages, etc. But this doesn't work for database projects. I quite often include a database project as part of my application's solution so everything is kept together. Often when I'm tracing things, I get down to a stored procedure and then I have to manually go look it up in the database project. It would be very useful if I could just right click on the procedure name and go to it, just like any other method call. Similarly, in my database project, I should be able to "find usages" on a stored procedure and have it show all calls to it in my c# code.
If one wanted to take it even further and fully support database projects, it would be great to be able to refactor inside stored procs, navigate to tables, functions, etc. There are other tools on the market that do this now, but they don't integrate back into c#. So the main value of doing this in resharper would be the back-and-forth references between c# and sql.
Any thoughts, comments, or ideas? I haven't dug in to the development of resharper plugins yet - would this even be possible with a plugin? Or can resharper not be told to look at the database projects or sql file types?