Search code examples
c#asp.netdatabaseazurescaffolding

where do I find the connection string in azure data studio since I am using mac and to scaffold I am going to need it


I am having trouble finding the structure(syntax) of the connection string of azure data studio with visual studio so I can scaffold data into it

I tried many ways but I am not really sure which one is the right one, since it's my first time using visual studio and db on mac


Solution

  • Thank you @Stringeater for your comment.

    If you want to connect Azure SQL database in visual studio you can find Connection strings option in SQL database tab

    enter image description here

    By using above required connection strings you are able connect database in visual studio. Otherwise as @Stringeater said check this for SQL server connection strings.

    Sample Connection String:

    Driver={ODBC Driver 17 for SQL Server};Server=<serverName>;Database=<datanaseName>;UID=<userName>;PWD=<password>;