Project consist of 4 projects namely, Business Logic Layer, Data Access Layer, ASP.NET Core Web API and MVC Web Application as front-end.
Used SQL Server as requested and the Database name is SuppliersDB.
File, 'Create Table and Insert Statement' is attached to create the table and insert data into the database for retrieval.