0

Can’t See Database Tables After Connecting Locally: What Could Be Wrong?

Tagged: 

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #52918

    I’ve connected to my local database on my machine as per the connection string, but I’m unable to see the tables described in the migration folders. What could be the reason for this, and am I making any mistakes?

    #52920
    Dimitrios Tzanetos
    Member
    Topic Author

      Im using the free Quick-Application Startup (Angular 15 & ASP .NET 7 Web Api) Project from Visual Studio Marketplace

      #52924
      Dimitrios Tzanetos
      Member
      Topic Author

        Interestingly, when I start the project, it runs without any errors! This adds to the confusion about not being able to see the tables after connecting to the local database.

        #52936

        If you haven’t modified the connection string and you’re on Windows you can use this connection string to connect to the default Development database:
        (localdb)\MSSQLLocalDB

        #52956
        Dimitrios Tzanetos
        Member
        Topic Author

          Thanks you very much

          #53683
          Vict Man
          Member

            My appsetting.json looks like this.

             

            “ConnectionStrings”: {
            “DefaultConnection”: “Server=(localdb)\MSSQLLocalDB;Database=QuickApp;Trusted_Connection=True;MultipleActiveResultSets=true”
            },

             

            The project builds successfully but I can’t see the database and any tables in MySQL Server Management Studio.

            Can you help me, please?

            #53686
            On Vict Man posted

            My appsetting.json looks like this.

             

            “ConnectionStrings”: {
            “DefaultConnection”: “Server=(localdb)\MSSQLLocalDB;Database=QuickApp;Trusted_Connection=True;MultipleActiveResultSets=true”
            },

             

            The project builds successfully but I can’t see the database and any tables in MySQL Server Management Studio.

            Can you help me, please?

            The ConnectionString you specified points to an SQL Local Database and not a “MySQL” server.

            You can connect to this using the “Microsoft SQL Server Management Studio” or any MS SQL database management tool of your choice using (localdb)\MSSQLLocalDB as the server name.

             

          Viewing 7 posts - 1 through 7 (of 7 total)
          • You must be logged in to reply to this topic.