Skip to content

Database

Jump to bottom
Sam Kazerouni edited this page Nov 4, 2016 · 21 revisions

Database technology analysis

Web Services

Our Glimpse.Core Client application communicates with the Web Service ASP.NET project using HTTP Request & Response. The Web Service is the gateway for any communication with the database. The Repository layer of our application communicates with the Web Service and the Web services accesses the database using GET,POST. The responses are then received by Web Service and sent to the client.

WebServices.png

How to connect to Azure Microsoft Database?

  1. Open Visual Studio

  2. Open Server Explorer in Views tab

  3. Right click on Data Connections in Server Explorer and Add Connection

  4. Select MySQL Database as Data source.

  5. Enter the following:

    • Server name: glimpsetarget.database.windows.net
    • User name: adming
    • Password: ******** (ask team lead)

  6. Select the database name: "glimpsedb"

  7. Click OK, you should see in Server Explorer that you are connected to Server "glimpsetarget", remote database "glimpsedb". Expand the db and you will see all tables.

Clone this wiki locally