WebApiToDoListDemo

Demo .NET Core Web Api project with logging and database operations using linq2db.

Project with tests (mock & test database) included.

SqlServer database script:

CREATE DATABASE [ToDoList]
GO
USE [ToDoList]
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ToDoList](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NULL,
	[IsComplete] [bit] NOT NULL,
	[DateCreated] [datetime] NOT NULL,
	[DateCompleted] [datetime] NULL,
 CONSTRAINT [PK_ToDoList] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
))
GO

ALTER TABLE [dbo].[ToDoList] ADD  CONSTRAINT [DF_ToDoList_IsComplete]  DEFAULT ((0)) FOR [IsComplete]
GO

ALTER TABLE [dbo].[ToDoList] ADD  CONSTRAINT [DF_ToDoList_DateCreated]  DEFAULT (getdate()) FOR [DateCreated]
GO