This project is a short tutorial series of about 4.5 hours which shows you how to build a basic website using ASP.NET MVC, Linq 2 SQL and SQL Server.
It has been designed as a tutorial for my son Joshua to follow, as he is currently learning HTML & CSS. He wanted to extend his knowledge and learn how to build a dynamic website powered by a database.
The project takes you through the steps of building a basic version of the BBC Sport Football website (because Joshua is football mad), consisting of setting up teams, matches, match reports and a dynamically generated league table - all built with C# and ASP.NET MVC.
Note: I don't necessarily use best practices in these tutorials - in fact, I should use ViewModel instead of ViewData in most of these examples, but it is a good grounding in setting up a very basic website that interacts with a database in a plausible client scenario.
Enjoy it for what it is :)
This is the introductory video explaining how to get started.
In this part, we'll learn how to set up the database using Linq 2 SQL and SQL Server.
In this episode, we start adding our teams to the database manually.
In this episode, we start setting up an admin screen for adding teams into the database
In this episode, we start setting up an admin screen for adding football matches into the database.
In this episode, we continue setting up an admin screen for adding football matches into the database.
In this episode, we start setting up an admin screen for adding match reports into the database.
In this episode, we start pulling in all of the information that we've created in our admin system onto the front-end of the website so that it is automatically updated whenever we add new stuff.
In this episode, we create a team page which shows all home and away matches for a specific team, as well as a filter to only show historical matches between it and another team.
In this episode, we create a dynamically generated league table based on all of the matches we've entered into the database. We show how to extend the functionality of the website very easily with minimal effort, providing visitors with even more useful information.
I hope you enjoyed the tutorial series - watch out for more.;