Database Projects

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?

-Matt

1 comment
Comment actions Permalink

Hello Matt,

Thank you very much for feedback! Could you please provide any concrete examples
of the tasks that ReSharper should be able to perform?

Andrey Serebryansky
Senior Support Engineer
JetBrains, Inc
http://www.jetbrains.com
"Develop with pleasure!"

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?

-Matt

---
Original message URL:
http://devnet.jetbrains.net/message/5277223#5277223



0

Please sign in to leave a comment.