As I'm not that skilled in Windows Phone 8 development I would like to discuss/ask what is the best way to connect my Windows Phone 8 to a SQL Server database, I don't want to use Azure as I have already have the database present on server using for website. Please can anyone give me complete tutorial for the same or help in achieving it? And after connection, I want to fire select queries only from wp8 app using text box inputs from user
Check here Windows Phone 8 access to SQL remote Database
Microsoft does not allow direct connection to remote databases, so you need to have a service ont the server connected to the database, that serves the content with http requests (using xml or json to represent the data)