This is an ASP.NET 5 WEB API with Consumer Complaints data(as of 09/23/2016) from http://catalog.data.gov/dataset/consumer-complaint-database#topic=consumer_navigation.

Technology used:
Entity Framwork v6.1 Data First
Sql Server 2016 Developer Edition (local installation)
Unity IoC(WEB API)
Moq(Unit testing)
Async/Await pattern(and sync calls)
Facebook and Google Auth Provider

Main features:
1. GET api/Complaints: List 10 of the Complaints records, see details below;
2. GET api/Complaints/{id}: List individual Complaint record by Id;
3. PUT api/Complaints/{id}: with Complaint Data;
4. POST api/Complaint: with Complaint Data;
5. DELETE api/Complaints/{id}: delete a complaint
6. GET api/TopComplaints: List 10 of the grouped(by Company Name) Complaints records, will do paging later;
7. GET api/TopComplaints/{zip}: List 10 of the grouped(by Company Name) Complaints records filtered by the zip code, will do paging later;
8. Account and Auth APIs... (br/>

GET api/Complaints routing examples: api/Complaints/{CompanyName}/{zip}/{pageSize}/{pageNumber}/{orderBy}
GET api/Complaints
GET api/Complaints/Discover
GET api/Complaints/Discover/334XX
GET api/Complaints/Discover/334XX/3
GET api/Complaints/Discover/334XX/3/3
GET api/Complaints/Discover/334XX/3/3/-DateReceived

Note:
1. Some of the functionalities are tested(Unit test, manual test, integration test) while others to be tested.
2. The Complaint Id(last column) is rebased when migration with Entity Framework v6.

Screenshot