We have developed a Sharepoint 2010 Visual Web Part.
This web part adds some extra functionality to Sharepoint but depends on a custom database we've created to index some stuff in a scheduled job. Each Sharepoint Site has to have its "index database". So we need a way to tell the web part what is the connection string for the current sharepoint site (current context).
We have .NET experience, but very little knowledge of Sharepoint and web parts.
What is the best approach to accomplish this? Any suggestions are welcome
Thinking a little bit, I'd like a way to define custom properties (just like a connection string) during the installation of the webpart (I haven't got to this phase yet, but I've been reading this can be achieved using some Powershell commands right?)
So, is there a way to define custom properties during webpart installation, so I can have a different set of properties depending on the SP Site the webpart has been installed