• When you walk past angel statues, you refuse to blink. [Guilty.]
  
• When you see something out of the corner of your eye, you FREAK. [Thanks to S6x2, I am guilty of this.]
  
• You carry a permanent, black marker around with you.
  
• You discover black tick marks on your body... and can’t remember when you drew them. [I actually had a black line on my arm from something I was drawing and FREAKED out when I saw it XD]
  
• You actually Google Mapped 37° 0’ 37’’N 110° 14’ 34’’W. [Guilty.]
  
• You have tried fish fingers and custard.
  
• You examine every. Crack. You see. [Guilty. And I got a LOT of weird looks when examining that crack in my taekwondo studio’s mirror. XD]
  
• You have a Sonic Screwdriver.
  
• You can’t help but read EVERYTHING WRITTEN IN CAPS in a Dalek voice. [Guiltyy.]
  
• Your favorite color is now blue. [Yep.]
  
• When someone asks what you want for your birthday/for a holiday, you list off Doctor Who items. [I actually asked my parents for a Sonic Screwdriver and Dalek clock... for a summer gift. XD]
  
• Your licence plate tags have some Doctor Who theme. [I am TOTALLY trying to get TARDIS on my licence plate tags when I get a car. A BLUE CAR.] Now, post your own! :D Keep it going! Prove you’re a true Whovian!
  

• https://www.youtube.com/watch?v=aKMS-b8dtBA
  
• https://en.wikipedia.org/wiki/Andrew_McAuley
  

• https://www.stuff.co.nz/national/crime/259404/Kayakers-widow-wrong-to-think-call-was-hoax
• https://i.stuff.co.nz/the-press/news/national/otago-southland/171393/Tasman-kayaker-ignored-advice

using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Builder; using Microsoft.AspNetCore.Hosting; using Microsoft.AspNetCore.Http; using Microsoft.Extensions.Configuration; using Microsoft.Extensions.DependencyInjection; using Microsoft.Extensions.Hosting; using Microsoft.EntityFrameworkCore; using ChinookContext; namespace WebApp { public class Startup { public Startup(IConfiguration configuration) { Configuration = configuration; } public IConfiguration Configuration { get; } // This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.AddRazorPages(); services.AddDbContext(); services.AddMvc(options => options.EnableEndpointRouting = false); } // This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IWebHostEnvironment env) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseExceptionHandler("/Error"); app.UseHsts(); } app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseRouting(); app.UseAuthorization(); app.UseEndpoints(endpoints => { endpoints.MapRazorPages(); endpoints.MapControllerRoute( name: "Update", pattern: "{controller}/{action}/{id:int?}", defaults: new { controller = "Update", action = "Index" } ); }); } } } 

using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Hosting; using Microsoft.Extensions.Configuration; using Microsoft.Extensions.Hosting; using Microsoft.Extensions.Logging; namespace WebApp { public class Program { public static void Main(string[] args) { CreateHostBuilder(args).Build().Run(); } public static IHostBuilder CreateHostBuilder(string[] args) => Host.CreateDefaultBuilder(args) .ConfigureWebHostDefaults(webBuilder => { webBuilder.UseStartup(); }); } } 

using System; using System.Collections.Generic; namespace ChinookEntities { public class Album { public int AlbumId { get; set; } // Primary Key from chinook table albums public string Title { get; set; } public int ArtistId { get; set; } // Navigation Property public Artist artists { get; set;} } public class Artist { public int ArtistId { get; set;} // Primary Key from chinook table albums public string Name { get; set;} // Navigation property and assumes one artist can have many albums public ICollection albums { get; set;} } } 

using System; using Microsoft.Data.Sqlite; using ChinookEntities; using Microsoft.EntityFrameworkCore; namespace ChinookContext { public class ChinookDatabase : DbContext { public DbSet albums { get; set; } public DbSet artists { get; set;} protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity() .HasOne(al => al.artists) .WithMany(ar => ar.albums) .HasForeignKey(al => al.ArtistId); } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { var connectionStringBuilder = new SqliteConnectionStringBuilder { DataSource = "chinook.db" }; var connectionString = connectionStringBuilder.ToString(); var connection = new SqliteConnection(connectionString); optionsBuilder.UseSqlite(connection); } } // public class Album // { // public int AlbumId { get; set; } // public string Title { get; set; } // public int ArtistId { get; set; } // } } 

@page @model WebApp.Pages.ViewAlbums @using ChinookEntities           
@Model.Heading
 
Insert New Album
 
  @foreach (Album albums in @Model.albums) {  } 
 
 
 
Title
 
Artist Name
 
 
 
 
 
@albums.Title
 
@albums.artists.Name
 
 
 @Html.AntiForgeryToken()   
 
 @Html.AntiForgeryToken()   
 
 
 
 
      

using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Mvc.RazorPages; using Microsoft.EntityFrameworkCore; using Microsoft.Extensions.Logging; using ChinookContext; using ChinookEntities; namespace WebApp.Pages { public class ViewAlbums : PageModel { public string Heading { get; set; } public List albums { get; set; } public List artists { get; set; } public void OnGet() { Heading = "Chinook Music Store"; ChinookDatabase db = new ChinookDatabase(); albums = db.albums.Include(a => a.artists).ToList(); artists = db.artists.ToList(); } } } 

@page @model Project.Pages.Insert @using ChinookEntities           
@Model.Heading
 
Go Back
 
 
 @Html.AntiForgeryToken() 
 Album Title  
 
 Artist ID  
 
 Submit 
 
 
      

using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Mvc.RazorPages; using Microsoft.Extensions.Logging; using ChinookContext; using ChinookEntities; namespace Project.Pages { public class Insert : PageModel { public string Heading { get; set; } public void OnGet() { Heading = "Chinook Albums - Insert"; } public IActionResult OnPost() { Album insAlbum = new Album() { Title = Request.Form["albTitle"], ArtistId = int.Parse(Request.Form["artID"]), }; ChinookDatabase db = new ChinookDatabase(); db.albums.Add(insAlbum); db.SaveChanges(); return Redirect("~/Index"); } } } 

@page @model Project.Pages.Delete @using ChinookEntities                

using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Mvc.RazorPages; using Microsoft.Extensions.Logging; using ChinookContext; using ChinookEntities; namespace Project.Pages { public class Delete : PageModel { public IActionResult OnPost() { ChinookDatabase db = new ChinookDatabase(); Album delAlbum = db.albums.Single(ai => ai.AlbumId == int.Parse(Request.Form["hdnAlbumId"])); db.albums.Remove(delAlbum); db.SaveChanges(); return Redirect("~/Index"); } } } 

@page "{id:int}" @model Project.Pages.Update @using ChinookEntities           
@Model.Heading
 
Go Back
 
 
 @Html.AntiForgeryToken() 
 Album Title  
 
 Artist ID  
 
 Submit 
 
 
      

using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Mvc.RazorPages; using Microsoft.Extensions.Logging; using Microsoft.EntityFrameworkCore; using ChinookContext; using ChinookEntities; namespace Project.Pages { public class Update : PageModel { public string Heading { get; set; } private readonly ChinookDatabase _db; private readonly ILogger _logger; public Update(ChinookDatabase db, ILogger logger) { _db = db; _logger = logger; } [BindProperty] public Album Album { get; set; } public async Task OnGetAsync(int? id) { if (id == null) { return NotFound(); } Album = await _db.albums.FindAsync(id); if (Album == null) { return NotFound(); } return Page(); } public async Task OnPostAsync(int? id) { if (!ModelState.IsValid) { return Page(); } var albumFromDb = await _db.albums.FindAsync(id); if (albumFromDb == null) { return NotFound(); } albumFromDb.Title = Album.Title; albumFromDb.ArtistId = Album.ArtistId; try { await _db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException ex) { _logger.LogError(ex, "Error updating album"); throw; } return RedirectToPage("~/Index"); } } }