Skip to content

Project is only for educational purposes. Uses a ASP.NET Core project with EFCore and SQl Server Express for CRUD

Notifications You must be signed in to change notification settings

super-sebajin/CovidDataSetsApi

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 

Repository files navigation

CovidDataSetsApi

CovidDataSetsApi is a ASP.NET Core Web API that exposes endpoints to gather data from various public data sets related to the ongoing SARS-CoV-2 virus pandemic, and stores them in a relational database.

  • Main development branch is dev1

Data Sets Currently In Use:

Data Set Name HTTP Method URL
"Visualize COVID-19 cases over time in the U.S." GET Data Set Url

How to set database and run project:

  • Clone the repository, of course, adn run dotnet build to ensure that the project builds.
  • To run this project, an initial migration would have to be run in order to map entities to their respective tables. (dotnet ef CLI tool is assumed to be installed)
  • The project uses SQL Server Express for development, and assumes it to be installed so make sure to have a database engine compatible with .Net and have the following in the project's appsettings.json as follows:
{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "ConnectionStrings": {
    "CovidDataSetsDatabase": "Server=DATABASE-ENGINE;Database=CovidDataSetsDb;Trusted_Connection= True"
  },
  "AllowedHosts": "*"
}

then make sure that the proper services are configured in the Program.cs for use with the database engine that will be used.

  • Run dotnet ef migrations add InitialCreate and dotnet ef database update and EntityFramework will go ahead and create the tables based on the entities in the project's DataAccessLayer folder.
  • Run dotnet build and then dotnet run to run the project.

About

Project is only for educational purposes. Uses a ASP.NET Core project with EFCore and SQl Server Express for CRUD

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published