DC Snoop

DC Snoop is web application that provides a searchable database of Washington, DC voter registration information. It is built using ASP.Net Core, Entity Framework Core, PostgreSQL, and a little HTML and jQuery for the UI.

Setup

This is a standard ASP.Net Core application, so it follows the standard ASP.NET Core setup.

Prerequisites

Install the latest version of .Net Core
Install and run PostgreSQL

Updating the configuration

Update the connection string in appsettings.json to match the settings you used when installing PostgreSQL.

Build and Run

Restoring Nuget depencencies - From the root directory on the command line run

dotnet restore

Setup the database - From the root directory on the command line run

dotnet ef database update

Build and run - From the root directory on the command line run

dotnet run

The application should now be running on localhost:5000. The RESTful API exposes three methods.

http://localhost:5000/api/person/{id}
http://localhost:5000/api/address/{id}
http://localhost:5000/api/search?term={search_terms}

In the UI folder open index.html in your favorite browser to view the UI. You may need to update the URL used for AJAX calls within UI/js/app.js to connect to your locally running API.

Additional Notes