Another website project for motoring magazine collectors

John Avis by | February 3, 2016 | General

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

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 stackoverflow.com 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.

magazinecollector.net is online but still a work in progress.

Related Posts

General

Limiting the maximum volume in Microsoft Windows 7 and 10

by John Avis | December 11, 2018

Do you want to limit the audio volume on a computer running on Windows 7 or 10?


General

You need a password system!

by John Avis | October 10, 2018

For your security it is critical that you use strong passwords that are unique for each website.


General

What happened to Trading Post Australia?

by John Avis | February 14, 2018

While looking for a new car to buy – without much success – I looked further afield than the usual carsales.com.au and gumtree.com.au and found myself at tradingpost.com.au. Oh how they have gone down hill...

Comments

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

Leave a Comment
Tags
ASP.NET Html Forms ASP.NET MVC ASP.NET Web Forms ASP.NET Web Pages Bootstrap C# Classic ASP Cool Websites Databases eBay and PayPal Electrical Repairs General Hardware HTML/CSS Jquery/Javascript Media Center Mobile Phones Responsive Web Design SEO and Social Networking Web Design Web Development Web Security web+db Website Hosting Windows XP Youtube

About me

...mostly about web development and programming, with a little bit of anything else related to the Internet, computers and technology.

Subscribe

Get the latest posts delivered to your inbox.