Scott Batary sgbj

## Program.cs
// Based on ASP.NET Core's ConnectionBuilder

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

var pipeline = new Pipeline()
    .Use((context, next) =>
    {

## DbExtensions.cs
public static class DbExtensions
{
    public static IDbCommand CreateCommand(this IDbConnection connection, FormattableString sql)
    {
        var command = connection.CreateCommand();
        var substitutions = new object[sql.ArgumentCount];

        for (var i = 0; i < sql.ArgumentCount; i++)
        {
            var parameter = command.CreateParameter();

## Index.cshtml.cs
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
using Microsoft.EntityFrameworkCore;
using Todo.Data;
using Todo.Models;

namespace Todo.Pages

## Index.cshtml
@page
@using System.Linq
@using Todo.Pages
@model IndexModel
@addTagHelper *, Microsoft.AspNetCore.Mvc.TagHelpers

<!doctype html>
<html lang="en">
<head>
    <meta charset="utf-8">

## gist:10edc1332aa6d6ad34c7c924393e126c
<form method="POST">
    <button asp-page-handler="create"></button>
</form>

public async Task<IActionResult> OnPostCreateAsync()
{
    ...
}

## Index.cshtml.cs
using Microsoft.AspNetCore.Mvc.RazorPages;

namespace Todo.Pages
{
    public class IndexModel : PageModel
    {
        public void OnGet()
        {
        }
    }

## Startup.cs
using System.IO;
using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Hosting;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.FileProviders;
using Todo.Data;

namespace Todo
{

## Startup.cs
app.Run(async (context) =>
{
    await context.Response.WriteAsync("Hello World!");
});

## TodoDbContext.cs
using Microsoft.EntityFrameworkCore;
using Todo.Models;

namespace Todo.Data
{
    public class TodoDbContext : DbContext
    {
        public TodoDbContext(DbContextOptions<TodoDbContext> options) : base(options)
        {
        }

## TodoItem.cs
namespace Todo.Models
{
    public class TodoItem
    {
        public int Id { get; set; }
        public string Description { get; set; }
        public bool IsCompleted { get; set; }
    }
}
	// Based on ASP.NET Core's ConnectionBuilder

	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Threading.Tasks;

	var pipeline = new Pipeline()
	.Use((context, next) =>
	{
	public static class DbExtensions
	{
	public static IDbCommand CreateCommand(this IDbConnection connection, FormattableString sql)
	{
	var command = connection.CreateCommand();
	var substitutions = new object[sql.ArgumentCount];

	for (var i = 0; i < sql.ArgumentCount; i++)
	{
	var parameter = command.CreateParameter();
	@page
	@using System.Linq
	@using Todo.Pages
	@model IndexModel
	@addTagHelper *, Microsoft.AspNetCore.Mvc.TagHelpers

	<!doctype html>
	<html lang="en">
	<head>
	<meta charset="utf-8">
	<form method="POST">
	<button asp-page-handler="create"></button>
	</form>

	public async Task<IActionResult> OnPostCreateAsync()
	{
	...
	}
	using Microsoft.AspNetCore.Mvc.RazorPages;

	namespace Todo.Pages
	{
	public class IndexModel : PageModel
	{
	public void OnGet()
	{
	}
	}
	using System.IO;
	using Microsoft.AspNetCore.Builder;
	using Microsoft.AspNetCore.Hosting;
	using Microsoft.EntityFrameworkCore;
	using Microsoft.Extensions.DependencyInjection;
	using Microsoft.Extensions.FileProviders;
	using Todo.Data;

	namespace Todo
	{
	app.Run(async (context) =>
	{
	await context.Response.WriteAsync("Hello World!");
	});
	using Microsoft.EntityFrameworkCore;
	using Todo.Models;

	namespace Todo.Data
	{
	public class TodoDbContext : DbContext
	{
	public TodoDbContext(DbContextOptions<TodoDbContext> options) : base(options)
	{
	}
	namespace Todo.Models
	{
	public class TodoItem
	{
	public int Id { get; set; }
	public string Description { get; set; }
	public bool IsCompleted { get; set; }
	}
	}