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

Latest Entries

Conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value

09 April 2014 13:45

Entity Framework

I managed to generate this error twice within a few days while working with the Entity Framework and SQL Server 2012. I had to resort to searching for a resolution on both occasions so I'm posting about it to sear the cause and solution into my brain.

Click to read more about Conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value ...

Viewed 61494 times

7 Comments for this item

Migrating Classic ASP To ASP.NET Razor Web Pages Part Three- Include Files And Reusable Code

10 March 2014 13:23

Classic ASP VB.Net ASP.NET Web Pages WebMatrix Razor

This is the third in a series of articles that explore how to migrate classic ASP web sites to the ASP.NET Web Pages framework. I covered Razor syntax and data access in the previous articles. This article shows how to deal with reusable code that typically inhabits include files in classic ASP.

Click to read more about Migrating Classic ASP To ASP.NET Razor Web Pages Part Three- Include Files And Reusable Code ...

Viewed 21862 times

6 Comments for this item

Migrating Classic ASP To ASP.NET Razor Web Pages Part Two- Data Access

03 March 2014 13:26

Classic ASP VB.Net ASP.NET Web Pages WebMatrix

The first article in this series explored the differences (and similarities) between classic ASP inline syntax and Razor syntax, the templating technology behind ASP.NET Razor Web Pages. The work required so far to port intermixed HTML and simple conditional and selection statements across from classic ASP to Razor didn't require a lot of effort. That is about to change in this article as I look at data access.

Click to read more about Migrating Classic ASP To ASP.NET Razor Web Pages Part Two- Data Access ...

Viewed 26226 times

6 Comments for this item

Migrating Classic ASP To ASP.NET Razor Web Pages Part One- Razor Syntax And Visual Basic

24 February 2014 13:25

Classic ASP ASP.NET Web Pages WebMatrix Razor

You have a classic ASP application that needs migrating to ASP.NET. You are comfortable working with classic ASP. but ASP.NET is fairly new to you. So what do you do? This article is the first in a series that looks at your options and proposes an approach to the migration that follows the path of least resistance.

Click to read more about Migrating Classic ASP To ASP.NET Razor Web Pages Part One- Razor Syntax And Visual Basic ...

Viewed 68251 times

7 Comments for this item

Creating Reusable Components For ASP.NET Razor Web Pages

04 February 2014 19:39

ASP.NET Web Pages WebMatrix

There are a number of ways that you can maximise code re-use within a Razor Web Pages site: Layout pages, helpers, functions and so on. As you build more sites, you soon find that you are repeating code between them. You might have a collection of custom utility functions and extension methods, for example that you find yourself copying and pasting across sites. Over time, this will become a maintenance nightmare as different versions of the methods live in different sites. This article shows how to solve that problem easily by creating a library that can be shared across multiple sites.

Click to read more about Creating Reusable Components For ASP.NET Razor Web Pages ...

Viewed 22020 times

8 Comments for this item

Adding a New Row In The Razor WebGrid

23 January 2014 08:10

ASP.NET Web Pages WebMatrix Razor WebGrid

The Razor WebGrid isn't just used for displaying data. I have already looked at how to edit data inline within the WebGrid, so this article looks at how to add new rows of data. within a rendered grid.

Click to read more about Adding a New Row In The Razor WebGrid ...

Viewed 41469 times

3 Comments for this item

Request Validation In ASP.NET Web Pages

18 December 2013 11:24

ASP.NET Web Pages WebMatrix Razor

Cross Site Scripting (XSS) attacks are the third on the Open Web Application Security Project's (OWASP) 2013 list of security vulnerabilities. This article looks at the defence mechanisms built into ASP.NET that protect against such attacks and how you can disable those defences in ASP.NET Razor Web Pages in a safe manner when you need to.

Click to read more about Request Validation In ASP.NET Web Pages ...

Viewed 62249 times

8 Comments for this item

Check Duplicate User Names In ASP.NET Web Pages Sites

29 November 2013 15:22

AJAX jQuery ASP.NET Web Pages WebMatrix Razor

The Web Pages Starter Site template provides a useful starting point for developing a Razor Web Pages site that includes membership. But it doesn't include any mechanism for preventing duplicate user names. This article offers one solution to the problem that uses jQuery.

Click to read more about Check Duplicate User Names In ASP.NET Web Pages Sites ...

Viewed 28966 times

9 Comments for this item

Posting Data With jQuery AJAX In ASP.NET Razor Web Pages

06 November 2013 19:38

AJAX jQuery ASP.NET Web Pages WebMatrix Razor

There have been a few questions recently about what you can post to the server using jQuery AJAX and where to find whatever you posted. This article looks at using the jQuery ajax method in ASP.NET Razor Web Pages and explores how different options have different results.

Click to read more about Posting Data With jQuery AJAX In ASP.NET Razor Web Pages ...

Viewed 266062 times

17 Comments for this item

Saving jQuery Sortables In ASP.NET Razor Web Pages

28 October 2013 20:04

jQuery ASP.NET Web Pages WebMatrix Razor

jQuery Sortables offer a way to specify the order of a collection of items through an easy drag and drop interface. I have just been working on the next release of Web Pages CMS and am in the process of implementing Sortables for managing the display order of menu items. This article looks at how they can be used in Razor Web Pages and shows one way of saving the resulting order to a database.

Click to read more about Saving jQuery Sortables In ASP.NET Razor Web Pages ...

Viewed 35355 times

0 Comments for this item

Managing Checkboxes And Radios In ASP.NET Razor Web Pages

14 October 2013 21:04

ASP.NET Web Pages WebMatrix Razor

Checkboxes and radio buttons cause more confusion than any other form control in ASP.NET Razor Web Pages. This article takes an in depth look at them and tackles the most frequently asked questions that they generate.

Click to read more about Managing Checkboxes And Radios In ASP.NET Razor Web Pages ...

Viewed 164095 times

6 Comments for this item

Code First Migrations With ASP.NET Web Pages Sites

28 August 2013 20:14

Visual Studio Entity Framework ASP.NET Web Pages WebMatrix

Entity Framework Code First Migrations enable changes to your model to be propagated to your database through code. Prior to the introduction of migrations, changes to the model resulted in the database being recreated from scratch with attendant loss of data. During development, this may not cause too many problems, but once the database has been deployed into production, it's another story. Migrations solve the problem in that changes are applied to the database schema without loss of data.

Click to read more about Code First Migrations With ASP.NET Web Pages Sites ...

Viewed 72934 times

5 Comments for this item

Windows Authentication With ASP.NET Web Pages

07 August 2013 19:34

ASP.NET Web Pages WebMatrix

The default authentication mechanism built into ASP.NET Web Pages site templates is Forms Authentication via the SimpleMembershipProvider, which is designed to enable authentication of users against a database. This requires the user to know their user name and password, and to enter those whenever they want to log in to access restricted areas within a site. If you are using the ASP.NET Web Pages framework to build an Intranet site that will be hosted within your own corporate network (i.e. client machines and web server are in the same domain), you can use Integrated Windows Authentication instead which simplifies authentication dramatically.

Click to read more about Windows Authentication With ASP.NET Web Pages ...

Viewed 200481 times

12 Comments for this item

Implementing Customers Also Bought In ASP.NET Web Pages

01 August 2013 15:32

ASP.NET Web Pages WebMatrix Razor

Most successful e-commerce sites implement a mechanism that draws the customer's attention to other products that might be of interest to them. These products are selected on the basis that shoppers who purchased the item currently being viewed by the customer also bought other products. This article looks at a away of implementing this kind of facility in an ASP.NET Web Pages site.

Click to read more about Implementing Customers Also Bought In ASP.NET Web Pages ...

Viewed 18119 times

5 Comments for this item

How To Check If A Query Returns Data In ASP.NET Web Pages

03 July 2013 14:01

ASP.NET Web Pages WebMatrix Razor

If you execute a query against a database, you need to know if any data was returned. But what is the best way to test for the presence of data when using the Web Pages Database helper?

Click to read more about How To Check If A Query Returns Data In ASP.NET Web Pages ...

Viewed 70395 times

12 Comments for this item

Recent Comments

Sivu 19/10/2016 08:21
In response to Entity Framework Core TrackGraph For Disconnected Data
Oh that's very very very nice ! Thanks for the write up Mike, much appreciated for the taking the to...

Mark 12/10/2016 16:42
In response to ASP.NET Web Pages vNext or Razor Pages
Although "Web Pages" was removed from the roadmap, has it just been renamed to "Razor Pages"?...

Satyabrata 12/10/2016 09:20
In response to Entity Framework Core TrackGraph For Disconnected Data
Nice article. Please write more articles featuring ASP.Net web pages. Thank you...

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