Project Case Study

Word-Link
Project Page

A modern digital crossword experience built with high-performance C# backend and a lightweight SQL foundation. Engineered for clarity, speed, and precision.

Stack ASP.NET Core MVC 10.0 SQLite 3.0 Tailwind CSS

Overview

The Vision

Word-Link reimagines the classic crossword for the minimalist age. By stripping away visual clutter, we focus on the core cognitive challenge: linking vocabulary through an architectural grid.

The Performance

Leveraging .NET 10, the application achieves sub-50ms puzzle generation and verification, ensuring a seamless user flow without frustrating latency.

Explore Philosophy

Pure Editorial

Key Architecture

layers

MVC Pattern

Strict separation of concerns using ASP.NET Core MVC. Models manage word relations, Views handle the crisp minimalist UI, and Controllers orchestrate solving logic.

bolt

Fast Middleware

Custom middleware for puzzle state persistence and session management, optimized for the .NET 10 Kestrel web server with zero overhead.

security

Secure Core

Built-in protection against common web vulnerabilities, utilizing modern .NET security defaults and strongly-typed data access.

Database
Schema

A serverless, high-performance database engine chosen for its portability and zero-configuration deployment.

Storage Engine SQLite 3.0

ORM EF Core 8.0

Total Tables 03

word_link_main.db

CREATE TABLE "Puzzles" (
    "Id" INTEGER PRIMARY KEY,
    "GridSize" INTEGER NOT NULL,
    "GridData" TEXT NOT NULL,
    "ActiveDate" TEXT NOT NULL,
    "Difficulty" TEXT NOT NULL
);

CREATE TABLE "Clues" (
    "Id" INTEGER PRIMARY KEY,
    "PuzzleId" INTEGER NOT NULL,
    "Number" INTEGER NOT NULL,
    "Direction" TEXT NOT NULL,
    "Text" TEXT NOT NULL,
    "Answer" TEXT NOT NULL,
    "StartRow" INTEGER NOT NULL,
    "StartCol" INTEGER NOT NULL
);

CREATE TABLE "GlobalStats" (
    "Id" INTEGER PRIMARY KEY,
    "PuzzleId" INTEGER NOT NULL,
    "SolveCount" INTEGER NOT NULL
);

Ready to Solve?

Experience the Precision of Word-Link Today.

Play Now View Source