ASP.NET MVC, SQL, Entity Framework, Azure - Life is good with Microsoft and TechNet Wiki
I recently posted an article about the new TechNet Ninja Belt Calculator, which I have been developing, where I touched upon the "Intranet tool" that I developed on Azure for us to manage all of the data generated from our various activities.
I thought this would be the perfect opportunity to wax lyrical about some of the wonderful technologies behind the website, in case it helps inspire anyone to choose the Microsoft way, to realise their ambitions.
While I'm here, I'll draw upon the Wiki itself, to highlight some of its most relevant documents that will help you get started, if you want to take the "easy life" approach :D
I simply love Azure. It is by far the best cloud solution, simplest to get into and quickest to get up and running, for websites and databases and so much more!
I showed a client today how simple it is to become a "cloud user" (simple account registration, 1 month free) and how they can have a server up and running in within seconds.
There are over 55,000 search results for "Azure" across TechNet.
You couldn't LIVE long enough to read everything that's been written about Azure!
- Jonathan Gao [MSFT] has written a great series of "Azure and SQL Database Tutorials", starting here. For some reason the index page has been marked as spam and deleted.
- Carsten Siemens has collated a great selection of essential links for every Azure developer, new and old, in the Microsoft Azure Portal. An essential bookmark.
- MVP Karthikeyan Anbarasan has posted an excellent starter article called "Develop and Deploy Your First Azure Application"
- An essential first tool when debugging a deployment in Azure is simply explained in How to Remotely Debug Azure Websites by Shreeharsh Ambli
Microsoft have a database solution for everyone. Free, light, huge, always on, secure, reliable, whatever the need, you can rely on the MS way.
There are over 140,000 articles in TechNet relating to SQL. There is literally nothing you can do, that hasn't been written about. Many times over.
The starting place is The SQL Server Portal wherein you will find links to:
- SQL Server 2012 Portal
- SQL Server General & Database Engine Resources on the TechNet Wiki
- Transact-SQL Portal
- SQL Server Reporting Services Portal
- SQL Server Integration Services Portal
- SQL Server Analysis Services Portal
- Windows Azure SQL Database TechNet Wiki Articles Index
One of the great features of MVC is that it has screen size checks and resizing built into the default template! The screen shrinks, and the page realigns to fit all in, with new mobile default style layout and icons.
- ASP.NET MVC 5 - Bootstrap 3.0 in 3 Steps
- ASP.NET MVC 5 - Connect with Azure SQLServer Database
- ASP.NET MVC 5 - Routing
- ASP.NET MVC 5 – Demo Authentication App with Facebook and Google
- ASP.NET MVC 5 – CRUD operations with Entity Framework 6 on Visual Studio 2013
- How to Publish ASP.NET MVC Web Application to Windows Azure
I remember the days of painful fingers, typing in reams and reams of boilerplate code that was needed to interact with a database with ADO.
Thank you Microsoft, for giving us the Entity Framework way of doing things - taking the pain out of database layers!
EF6 brings a multiple context fix that had me tearing my hair out on one occasion, when trying to combine "SimpleMembersip Provider" into an old application's existing EF5 context.
- Developing Modern Mobile Web Apps The Entity Framework 4.0 and ASP.NET Web Forms – Getting Started
- Getting Started with the Entity Framework 4.1 using ASP.NET MVC 3
- Getting Started with Entity Framework 6 Code First using MVC 5
- The Entity Framework FAQ
- ASP.NET MVC 5 – CRUD operations with Entity Framework 6 on Visual Studio 201
- You can read a complete E-book - Getting Started with Entity Framework 6 Code First using MVC 5
Getting started with a Microsoft solution is by far the best way to get results. The wealth of information available across TechNet Wiki provides everything you need to get started and to support you throughout your journey.
I am running several websites and databases on my Azure account, and I use them quite frequently. Yet my monthly usage bill is under £5 per month!
It really does save you money to use cloud computing, and the Microsoft MSDN and TechNet community, along with TechNet Wiki will help you every step of the way!
Finally, if you like to read e-books, then TechNet has one more gem for everyone to bookmark. It's the E-Book Gallery for Microsoft Technologies. This amazing collection of e-books just keeps on growing!