##To Do List

###Description Simple to do list with tasks and categories. With unit testing using Microsoft SQL Server, Nancy 1.3.0, XUnit 2.1.0. CRUD functionality for categories. Illustrates many to many relationships.

###Instructions Download source code and run the following lines in PowerShell from the project folder

> dnvm install latest
> dnu restore
> dnx kestrel

App production database named todo_extended created using these commands in PowerShell SQLCMD

1> CREATE DATABASE todo_extended;
2> GO
1> USE todo;
2> GO
1> CREATE TABLE tasks
2> (
3>   id INT IDENTITY (1,1),
4>   description VARCHAR(255)
6> );
7> CREATE TABLE categories
8> (
9>   id INT IDENTITY (1,1),
10>  name VARCHAR(255)
11> );
12> CREATE TABLE categories_tasks
13> (
14>   id INT IDENTITY (1,1),
15>  category_id INT,
16>  task_id INT
17> );
18> GO

Testing database is a clone of this named todo_extended_test

To run tests, use the PowerShell command > dnx test