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

Latest Entries

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 24292 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 38753 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 114748 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 62859 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 35108 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 12006 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 15534 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 18826 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 14178 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 12992 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 24598 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 14360 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 9291 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 24962 times

7 Comments for this item

MVC 5 with EF 6 in Visual Basic - Implementing Basic CRUD Functionality

13 June 2014 13:34

VB.Net ASP.NET MVC Entity Framework

This tutorial is the second in a series of 12 which teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic. Here, we look at implementing basic CRUD (Create, Read, Update and Delete) using the scaffolding that ASP.NET MVC provides, as well as customising the resulting code.

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

Viewed 15328 times

9 Comments for this item

Recent Comments

Jerrie Pelser 23/07/2016 05:08
In response to Loading ASP.NET Core MVC Views From A Database Or Other Location
Very cool concept Mike!...

Satyabrata 20/07/2016 20:54
In response to ASP.NET Web Pages vNext or Razor Pages
Thanks for sharing ...

infocyde 18/07/2016 00:40
In response to ASP.NET Web Pages vNext or Razor Pages
Curious to see if a new release of webmatrix will happen or if that is dead in the water....

Don 15/07/2016 16:58
In response to ASP.NET Web Pages vNext or Razor Pages
Thanks Mike! Wonder if the MVC Lite is the Controllerless Views approach referred to on the Web Dev...

Jose Negro 30/06/2016 16:02
In response to Entity Framework Code First and Stored Procedures
Thank you very much for so clear examples....

A. Truong 29/06/2016 15:25
In response to The Best Way To Import Data From Excel To SQL Server via ASP.NET
Awesome work! Lifesaver....

satyabrata 19/06/2016 18:53
In response to Entity Framework Code First and Stored Procedures
Nice article. Thanks. The menu on this website not working in mobile....

satyabrata 16/05/2016 06:28
In response to Implementing SQL Server Full-Text Search In An ASP.NET MVC Web Application With Entity Framework
This is great. Thanks for sharing....

sharey 06/05/2016 13:15
In response to The Best Way To Import Data From Excel To SQL Server via ASP.NET
nice work gentleman.Really helpfull....

Satyabrata Mohapatra 20/04/2016 04:36
In response to The Best Way To Import Data From Excel To SQL Server via ASP.NET
Another beauty !!!! Thanks for sharing....