A collection of articles and tutorials on web development with ASP.NET by Mike Brind

Latest Entries

Entity Framework Recipe: Grouping By Year And Month

12 January 2015 20:38

ASP.NET MVC Entity Framework

This is the latest in a series of "EF Recipes" - short articles that show through practical examples how to achieve common tasks with Entity framework and ASP.NET MVC. This particular example looks at grouping data by year and month in MVC 5 with Entity Framework 6. The article is prompted by an email I got from a reader who asked how I generate the "Archives" feature in the right hand panel on each page on this site.

Click to read more about Entity Framework Recipe: Grouping By Year And Month ...

Viewed 28273 times

3 Comments for this item

Entity Framework Recipe: Alphabetical Paging In ASP.NET MVC

29 October 2014 20:53

ASP.NET MVC Entity Framework

This article looks at using the alphabet for paging data in MVC 5 with Entity Framework 6. Where it differs from most existing articles on alphabetical paging is that this article looks at generating paging links from the data instead of the alphabet. It also features a Bootstrap-friendly helper for generating the paging links.

Click to read more about Entity Framework Recipe: Alphabetical Paging In ASP.NET MVC ...

Viewed 24789 times

17 Comments for this item

Entity Framework Recipe: Hierarchical Data Management

24 October 2014 22:20

ASP.NET MVC Entity Framework

This article explores how to use Entity Framework 6 to manage the retrieval and display of hierarchical data such as you might find in a menu system. There are a number of existing items on the Internet that cover the same topic, but most of them seem unnecessarily complex and don't include any information about displaying the data once it has been retrieved.

Click to read more about Entity Framework Recipe: Hierarchical Data Management ...

Viewed 41551 times

9 Comments for this item

Scheduled Tasks In ASP.NET With Quartz.Net

07 August 2014 08:34

General ASP.NET MVC ASP.NET Web Forms ASP.NET Web Pages

A perennial question on the ASP.NET forums concerns how to schedule regular tasks as part of a web application. Typically, the requirement is to send emails once every 24 hours at a particular time each day, but it could actually be anything from tweeting on a schedule to performing maintenance tasks. Equally typically, half a dozen members on the forum dive in with recommendations to install Windows Services or schedule batch files with the Task Scheduler - regardless of the fact that most web site owners are not afforded such privileges as part of their shared hosting plan.

Click to read more about Scheduled Tasks In ASP.NET With Quartz.Net ...

Viewed 123683 times

66 Comments for this item

Using ASP.NET Identity with Razor Web Pages

04 July 2014 07:27

ASP.NET Web Pages WebMatrix Razor

ASP.NET Identity is the new membership system for ASP.NET applications and is the recommended system for new MVC 5 and Web Forms projects. Among other things, it moves membership away from being dependent on System.Web, which is the general direction that the next version of ASP.NET is taking. News on how the Web Pages framework will be impacted by this evolution in ASP.NET is scarce at the moment, and so is information on how to incorporate ASP.NET Identity into a Razor Web Pages site. This article demonstrates the steps required to make use of the ASP.NET Identity framework in your Web Pages application.

Click to read more about Using ASP.NET Identity with Razor Web Pages ...

Viewed 64125 times

12 Comments for this item

MVC 5 with EF 6 in Visual Basic - Advanced Entity Framework Scenarios

13 June 2014 13:42

VB.Net ASP.NET MVC Entity Framework

This tutorial is the last in a series of 12 that teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. This final tutorial  introduces several topics that are useful to be aware of when you go beyond the basics of developing ASP.NET web applications that use Entity Framework Code First. Step-by-step instructions walk you through the code and using Visual Studio Express For Web for the following topics:

Click to read more about MVC 5 with EF 6 in Visual Basic - Advanced Entity Framework Scenarios ...

Viewed 35923 times

2 Comments for this item

MVC 5 with EF 6 in Visual Basic - Implementing Inheritance

13 June 2014 13:42

VB.Net ASP.NET MVC Entity Framework

This tutorial is the eleventh in a series of 12 that teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. In the previous tutorial you handled concurrency exceptions. This tutorial will show you how to implement inheritance in the data model.

Click to read more about MVC 5 with EF 6 in Visual Basic - Implementing Inheritance ...

Viewed 12193 times

4 Comments for this item

MVC 5 with EF 6 in Visual Basic - Handling Concurrency

13 June 2014 13:41

VB.Net ASP.NET MVC Entity Framework

This tutorial is the tenth in a series of 12 that teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. In earlier tutorials you learned how to update data. This tutorial shows how to handle conflicts when multiple users update the same entity at the same time. You'll change the web pages that work with the Department entity so that they handle concurrency errors.

Click to read more about MVC 5 with EF 6 in Visual Basic - Handling Concurrency ...

Viewed 15814 times

0 Comments for this item

MVC 5 with EF 6 in Visual Basic - Async and Stored Procedures with the Entity Framework

13 June 2014 13:40

VB.Net ASP.NET MVC Entity Framework

This tutorial is the ninth in a series of 12 that teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. In earlier tutorials you learned how to read and update data using the synchronous programming model. In this tutorial you see how to implement the asynchronous programming model. Asynchronous code can help an application perform better because it makes better use of server resources.

Click to read more about MVC 5 with EF 6 in Visual Basic - Async and Stored Procedures with the Entity Framework ...

Viewed 19098 times

2 Comments for this item

MVC 5 with EF 6 in Visual Basic - Updating Related Data

13 June 2014 13:39

VB.Net ASP.NET MVC Entity Framework

This tutorial is the eighth in a series of 12 that teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. In the previous tutorial you displayed related data; in this tutorial you'll update related data. For most relationships, this can be done by updating either foreign key fields or navigation properties. For many-to-many relationships, the Entity Framework doesn't expose the join table directly, so you add and remove entities to and from the appropriate navigation properties.

Click to read more about MVC 5 with EF 6 in Visual Basic - Updating Related Data ...

Viewed 14429 times

2 Comments for this item

MVC 5 with EF 6 in Visual Basic - Reading Related Data

13 June 2014 13:39

VB.Net ASP.NET MVC Entity Framework

This tutorial is the seventh in a series of 12 that teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. In the previous tutorial you completed the School data model. In this tutorial you'll read and display related data — that is, data that the Entity Framework loads into navigation properties.

Click to read more about MVC 5 with EF 6 in Visual Basic - Reading Related Data ...

Viewed 13352 times

2 Comments for this item

MVC 5 with EF 6 in Visual Basic - Creating a More Complex Data Model

13 June 2014 13:38

VB.Net ASP.NET MVC Entity Framework

This tutorial is the sixth in a series of 12 that teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. In the previous tutorials you worked with a simple data model that was composed of three entities. In this tutorial you'll add more entities and relationships, and you'll customize the data model by specifying formatting, validation, and database mapping rules. You'll see two ways to customize the data model:  by adding attributes to entity classes and by adding code to the database context class.

Click to read more about MVC 5 with EF 6 in Visual Basic - Creating a More Complex Data Model ...

Viewed 25217 times

2 Comments for this item

MVC 5 with EF 6 in Visual Basic - Code First Migrations and Deployment

13 June 2014 13:37

VB.Net ASP.NET MVC Entity Framework

This tutorial is the fifth in a series of 12 that teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. This tutorial covers how to enable Code First Migrations and then deploy your database to Windows Azure. The Migrations feature enables you to change the data model and deploy your changes to production by updating the database schema without having to drop and re-create the database. The section covering deployment to Azure is optional; you can continue with the remaining tutorials without having deployed the project.

Click to read more about MVC 5 with EF 6 in Visual Basic - Code First Migrations and Deployment ...

Viewed 14804 times

0 Comments for this item

MVC 5 with EF 6 in Visual Basic - Connection Resiliency and Command Interception

13 June 2014 13:36

VB.Net ASP.NET MVC Entity Framework

This tutorial is the fourth in a series of 12 which teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. This tutorial covers how to use two features of Entity Framework 6 that are especially valuable when you are deploying to the cloud environment: connection resiliency (automatic retries for transient errors) and command interception (catch all SQL queries sent to the database in order to log or change them).

Click to read more about MVC 5 with EF 6 in Visual Basic - Connection Resiliency and Command Interception ...

Viewed 9493 times

1 Comment for this item

MVC 5 with EF 6 in Visual Basic - Sorting, Filtering and Paging

13 June 2014 13:35

VB.Net ASP.NET MVC Entity Framework

This tutorial is the third in a series of 12 which teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. This tutorial explores how to add sorting, filtering and paging to MVC 5 Views using the Entity Framework. You will also look at implementing simple Grouping.

Click to read more about MVC 5 with EF 6 in Visual Basic - Sorting, Filtering and Paging ...

Viewed 25784 times

7 Comments for this item

Recent Comments

Julian 26/09/2016 14:27
In response to Loading ASP.NET Core MVC Views From A Database Or Other Location
Fantastic, many thanks Mike! Had got half way down this road before finding your article - saved...

Abolfazl Roshanzamir 14/09/2016 05:36
In response to Loading ASP.NET Core MVC Views From A Database Or Other Location
Nice article. Thanke you so much ....

cyrus 02/09/2016 15:12
In response to ASP.NET Web Pages vNext or Razor Pages
I've got some news. As Damian stated in this link: https://github.com/aspnet/Mvc/issues/5208 “We...

Simon 01/09/2016 08:00
In response to Loading ASP.NET Core MVC Views From A Database Or Other Location
Thanks Mike, nice post and exactly what I was looking for. Like you said, I think I'll opt to the...

dave 20/08/2016 14:57
In response to ASP.NET Web Pages vNext or Razor Pages
Do SimplemembershipProvider in viewpages is supported?...

Steven 18/08/2016 04:40
In response to Entity Framework Code First and Stored Procedures
Can you provide the directives (using statements) you're using for EF7 example?...

yousaid 17/08/2016 22:08
In response to ASP.NET Web Pages vNext or Razor Pages
Increasingly, learning a Microsoft tool is no longer worth the return on investment. Too many tools...

jared 12/08/2016 05:54
In response to ASP.NET Web Pages vNext or Razor Pages
hi mike, just for clarification, is viewpages something different from webpages? is webpages still...

Jocke 08/08/2016 20:37
In response to Loading ASP.NET Core MVC Views From A Database Or Other Location
Good post! If this was to be implemented in a CMS where users can change the view files, how would I...

cyrus 05/08/2016 19:49
In response to ASP.NET Web Pages vNext or Razor Pages
I think adding these features to webpages make it complicated. msft forget webpages goal so we move...