Connecting ASP.NET Core to SQL server

Question

I am learning ASP.NET framework. I have created a simple To Do List with React.js on the front end, and ASP.NET Core on the backend. It seems I am connecting to the database with no problems. But I have added a simple table to the server for the purposes of testing the connection which look something like this: 1 Create a To Do List but when I launch the app on localhost, nothing is displayed, as depicted in this picture loading..., which suggests the back end is not functioning properly. Here is my connection string: "DBConString": "jdbc:sqlserver://localhost;database=master" and other relevant connection info```

        {
            services.AddControllersWithViews();
            var ConnectionString = Configuration.GetConnectionString("DBConString");
            services.AddDbContext<ToDoListDBContext>(options =>
                options.UseSqlServer(ConnectionString));
            services.AddMvc();
            services.AddCors();```

    app.UseEndpoints(endpoints =>
            {
                endpoints.MapControllerRoute(
                    name: "default",
                    pattern: "{controller=ToDosController}/{action=Index}/{id?}");
            });

Also some screenshots that show my successful connection to the database in my IDE: successful connection to database in Rider If anyone could share some insight into why this is not working, it'd be much appreciated!

Have you tried debugging the application to see what the application is doing? Follow through on your database request and see if you're getting anything in return. — Chris
– Chris, Commented May 13, 2021 at 17:51
You likely don't want to be connecting to your master SQL Server database as your connection string indicates. — Timothy G.
– Timothy G., Commented May 13, 2021 at 17:51
As Timothy noted, you should not be using 'master' as your schema. You will want to create a new database to hold your table. With that said, your connection string seems to be a little off? It should look more like so: "data source=localhost;initial catalog=master;integrated security=True;" 'integrated security' unless you have SQL Server Authentication - with a specific user/pass set (e.g., sa and sa's password in your case to use master). You'll also want to take a look at this to use a transient scope: stackoverflow.com/questions/41923804/… — jimnkey
– jimnkey, Commented May 13, 2021 at 18:35

Slava Knyazev · Accepted Answer · 2021-05-13 17:48:25Z

2

ConnectionStrings in .NET Core have a special format that needs to be followed.

Take a look here to see what you need: https://www.connectionstrings.com/sql-server/

answered May 13, 2021 at 17:48

Slava Knyazev

6,0991 gold badge27 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connecting ASP.NET Core to SQL server

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related