SQL Data Retriever

Inspiration

I needed something similar for my lengthy home project.

What it does

Connects to a centralized server hosting your SQL admin account information so that client's don't need to have this information to retrieve SQL queries.

How I built it

I used C# and the .Net framework to create a TCP connection between host and client that will provoke the client to ask for a particular SQL query with paramaters and the server will return said information from the SQL database.

Challenges I ran into

Connecting to and disconnecting became an issue half way through along with other factors such as DNS.

Accomplishments that I'm proud of

It works.

What I learned

How to create a product that is reusable and attachable to seemingly any project.

What's next for SQL Data Retriever

This will be attached to my long standing development project and potentially released as an open source framework that will allow it to be easily implementable to anyone's project.

Built With

• .net
• c#
• sql
• tcpconnection