1. Create project in .net core.

2. Add new project in that project. Choose class library.

3. Add class inside that SQLHelper project.

4. Write connection string.

5. Write sql command methods. (install Packages if required).

6. Add reference SQLHelper in the project.

7. Cal the sql command methods whenever required.

Create DataLogic class inside DataLayer and write methods to call the SQL Command methods to access the database.