Another website project for motoring magazine collectors

John Avis by | February 3, 2016 | Web Development Computers & Internet

I'm working on a new website for one of my hobbies – car magazine collecting.

I'm working on a new website for one of my hobbies – car magazine collecting.

I wanted a website where I could create an index of the contents of each magazine so I would be able to search for articles about particular makes and models.

I also wanted to be able to track which issues I have, which ones I want, and which ones I don't want and would like to sell.

A wiki-like website where anyone could add and update magazine contents sounded ideal.

I love and have taken some inspiration from that site for how to handle members, permissions and points.

So, what to develop in?

Well I work in ASP.NET Web Forms in my day job but I do get a bit annoyed by some of its features – mainly the bloat and issues with ViewState. It would have been the quickest option as I am so familiar with it.

I thought about ASP.NET MVC and I really should take a leap into this as it seems it is now the professional choice for ASP.NET development. However, I don't like it.

I decided upon ASP.NET Web Pages. One of the main reasons is that I can do development changes and fixes easily without the need for compilation and redeployment. Just a change to a cshtml file is all that's needed.

Although Web Pages is regarded as a framework for beginners, it does expose all the benefits of ASP.NET and C#, so it is just as capable as any of the other choices.

On the client side I have chosen to start with Bootstrap 4. Although still in Alpha stage I thought it would be a good idea to get acquainted with it, and enjoy the benefits of smaller file size, improvements and new features.

And what about data access?

Because this (not profitable) website would be run on a low-cost shared hosting plan, performance would be fairly critical. My original plan for data access was to use the SqlClient namespace and SqlDataReaders, etc for everything. After all, that's similar to how we did things in the "old days" - raw SQL and straight from database to web page.

However, it didn't take long for me to tire of doing it this way. I prefer writing raw SQL but years of Linq to SQL and Entity Framework made me yearn for strongly typed queries and results.

So I started switching over the Linq to SQL. A lot less bloat than EF but it really speeds development. Some of my more complex queries are a bit of a pain in Linq but that's the price you pay. Still, I hope someone answers my call for a better system that integrates application and database, and allows us to write raw SQL in our application better than Linq does. is online but still a work in progress.

Related Posts

Intermittent "Unable to read data from the transport connection: net_io_connectionclosed" errors

by John Avis | May 6, 2020

If you are having intermittent problems sending email in .NET using System.Net.Mail consider switching libraries.

500 Internal Server Error after migrating from IIS 7.5 to IIS 10

by John Avis | November 4, 2019

As support ends for Microsoft Windows Server 2008 I have recently gone through migrating some websites to a new server running Windows Server 2016 and IIS 10 but some of the websites did not work.

tagInput: A simple jQuery plugin for tag entry using Bootstrap 4

by John Avis | October 15, 2019

For a website project I needed a way to enter multiple tags. I just wanted something simple that I could easily modify to suit my own needs, so I wrote my own.


There are no comments yet. Be the first to leave a comment!

Leave a Comment



...random postings about web development and programming, Internet, computers and electronics topics.

I recommend ASPnix for web hosting and Crazy Domains for domain registration.


Get the latest posts delivered to your inbox.