how can I connect sqlserver with VScode and to create user registration page

Question

User-1355965324 posted

Hi

I am new in VScode . I want to create the user registration page in VS code . How can I create the connection profile to the local database in sqlserver  in VS code . Please can you advise me. Then I want to insert the user details into the database. Please can you advise

Pol

Answer 1

User-893317190 posted

Hi polachan,

Connecting to sqlserver in vs code in the same as connecting to sqlserver in visual studio.

If you are developing .net core project ,you could refer to the link below to learn how to  connect to sqlserver in vs code

https://medium.freecodecamp.org/how-to-perform-crud-operations-with-asp-net-core-using-vs-code-and-ado-net-b12404aef708

If you are using entity framework , you could refer to https://dzone.com/articles/crud-operation-with-aspnet-core-mvc-using-visual-s

Here is another basic guide https://www.c-sharpcorner.com/article/build-your-first-asp-net-mvc-core-application-with-visual-studio-code/

Best regards,

Ackerly Xu