0

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

› Support Forums › Product Support › Can’t See Database Tables After Connecting Locally: What Could Be Wrong?

Tagged: 

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • March 26, 2023 at 1:39 pm #52918
    Dimitrios Tzanetos
    Member

      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?

      March 26, 2023 at 1:44 pm #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

        March 26, 2023 at 1:47 pm #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.

          March 26, 2023 at 7:43 pm #52936
          Eben Monney
          Admin

            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

            March 27, 2023 at 7:59 am #52956
            Dimitrios Tzanetos
            Member
            Topic Author

              Thanks you very much

              May 2, 2023 at 9:20 am #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?

                • This reply was modified 1 month ago by Vict Man.
                May 2, 2023 at 10:31 am #53686
                Eben Monney
                Admin
                  On May 2, 2023 at 9:20 am 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.

                   

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