Database connectivity in sitefinity

Posted by Community Admin on 04-Aug-2018 05:23

Database connectivity in sitefinity

All Replies

Posted by Community Admin on 28-Jan-2016 00:00

hi,I have a separate database and i want to show some data on my SF site after querying from this database. after searching i got we need to add connection string in dataconfig.config file . but I don't have any dataconfig.config file in my site when opened with visual studio. I am new to sitefinity and this is a high priority issue to solve . can any one help.

Posted by Community Admin on 28-Jan-2016 00:00

First off, if I understand correctly the connection you are adding is going to be used to query a non-Sitefinity database. That being the case, it is not necessary to store the connection string in the dataconfig.config. The other option is to store the connection string in the web.config. This will allow you to retrieve the connection string just like you would in a non-Sitefinity asp.net web application.

 

If you still want to store the connection string in the dataconfig.config than you must select the "Show All Files" option in Visual Studio.  This is achieved by clicking the icon highlighted in the attached screenshot.

This thread is closed