Fiona Sanggang fsanggang

## golb_13_navigation.razor
... etc

<li class="nav-item px-3">
    <NavLink class="nav-link" href="posts">
    <span class="oi oi-list-rich" aria-hidden="true"></span> Posts
    </NavLink>
</li>

... etc

## golb_12_index.razor
// Pages/Post/Index.razor

@page "/posts"

@using Golb.Data
@using Golb.Services
@inject PostService service

@if (posts == null)
{

## golb_11_register_service.cs
... etc
using Golb.Services;

public void ConfigureServices(IServiceCollection services)
{
    ...etc

    services.AddTransient<PostService>();
}

## golb_10_post_service.cs
// Services/PostService.cs

using Microsoft.EntityFrameworkCore;
using System.Collections.Generic;
using System.Threading.Tasks;
using Golb.Data;

namespace Golb.Services
{
    public interface IPostService

## golb_10_check_posts_table.sql
select Name from sys.Databases
use GolbDatabase
select * from information_schema.tables
select * from information_schema.columns where table_name = 'Posts'

## golb_9_sqlcmd.bash
/opt/mssql-tools/bin/sqlcmd -S localhost -U "sa" -P "yourPasswordHere" -I

## golb_8_connect_sql_server.bash
docker exec -it sql_server bash

## golb_6_dbcontext.cs
// Data/ApplicationDbContext.cs

public class ApplicationDbContext : IdentityDbContext
{
    ...etc

    public DbSet<Post> Posts { get; set; }

    protected override void OnModelCreating(ModelBuilder builder)
    {

## golb_6_post.cs
// Data/Post.cs

using System;

namespace Golb.Data
{
    public class Post
    {
        public int Id { get; set; }
        public string Title { get; set; }

## golb_5a_install_dotnet_tools.bash
dotnet tool install --global dotnet-ef
	... etc

	<li class="nav-item px-3">
	<NavLink class="nav-link" href="posts">
	<span class="oi oi-list-rich" aria-hidden="true"></span> Posts
	</NavLink>
	</li>

	... etc
	// Pages/Post/Index.razor

	@page "/posts"

	@using Golb.Data
	@using Golb.Services
	@inject PostService service

	@if (posts == null)
	{
	... etc
	using Golb.Services;

	public void ConfigureServices(IServiceCollection services)
	{
	...etc

	services.AddTransient<PostService>();
	}
	// Services/PostService.cs

	using Microsoft.EntityFrameworkCore;
	using System.Collections.Generic;
	using System.Threading.Tasks;
	using Golb.Data;

	namespace Golb.Services
	{
	public interface IPostService
	select Name from sys.Databases
	use GolbDatabase
	select * from information_schema.tables
	select * from information_schema.columns where table_name = 'Posts'
	// Data/ApplicationDbContext.cs

	public class ApplicationDbContext : IdentityDbContext
	{
	...etc

	public DbSet<Post> Posts { get; set; }

	protected override void OnModelCreating(ModelBuilder builder)
	{
	// Data/Post.cs

	using System;

	namespace Golb.Data
	{
	public class Post
	{
	public int Id { get; set; }
	public string Title { get; set; }