Mike Bosch's Blog on .NET

Announcing ASP.NET MVC 1.0 Final Release - Download Available

MikeBosch — Wed, 18 Mar 2009 15:02:00 GMT

ASP.NET MVC 1.0 is finally out. Download it now!

http://www.microsoft.com/downloads/details.aspx?FamilyID=53289097-73ce-43bf-b6a6-35e00103cb4b&displaylang=en

Updating MvcPager to work with ASP.NET MVC RC 1 (refresh)

MikeBosch — Sun, 01 Feb 2009 16:18:00 GMT

At first glance, upgrading to the RC1 was quite a debacle. First of all, any link that I created using the much more performant Html.RouteLink (instead of Html.ActionLink) just stopped working. It turns out there was a regression bug in the RC that caused this. The ASP.NET MVC team quickly released a refresh which fixed the problem.

The next problem came when I noticed Stephen Walther's paging helper stopped working. It would throw a null reference exception whenever I used the Html.Pager() helper method. The issue was a breaking change in the RC1 with the location the RequestContext.

To fix the issue, you can download the solution from Stephen's site. Open up the solution and change all the references to the latest ASP.NET MVC assemblies. When you compile the main project, you'll find an error in the PagerBuilder.cs class at line 165. All you have to do is update this line to:

var urlHelper = new UrlHelper(_helper.ViewContext.RequestContext);

Compile the project and replace the assembly in your ASP.NET MVC project. I'm sure Stephen will update the project eventually so you could just download the latest version.

Hope this helps!

Hierarchical Treeview with ASP.NET MVC & jQuery

MikeBosch — Tue, 25 Nov 2008 21:20:00 GMT

First of all, an apology for being so quiet over the past few weeks. I've been putting my blogging aside for a while to chase some pet projects I'm working on. More on that later.

I did, however, run into a particular situation that I thought would be of interest to anyone adopting ASP.NET MVC and looking for some goodies from jQuery. Many of you have no doubt started testing the waters with jQuery since it was announced that Microsoft will be shipping the next version of .NET with it included. If you haven't used jQuery yet, prepare to fall in love!

In this post, I'm going to cover a simple way to build a deep, hierarchical and feature-rich tree structure with only one line of jQuery script. jQuery has a huge library of plugins covering all sorts of functionality. For this, we'll be using a neat plugin from for treeviews. Here's what you need:
jQuery
jQuery Treeview Plugin

This structure will consist of a category/sub-category relationship that is able to support n-levels of sub-categories with no changes. To demonstrate, let's look at the SQL table that supports the structure.

Notice the rows with ParentCategoryID set to NULL are the parent categories. Each row with a ParentCategoryID is a sub-category and relates to it's parent category. The numbers show the level in outline view.

The jQuery Treeview plug-in requires the resulting HTML to be in a particular unordered list (<ul>) element to parse the tree correctly. Since we don't know how many levels to expect, we are going to call the MVC user control that renders each node recursively. This control accepts a single Category item.

We render the name of that category and then check if it has any categories associated with it. If it does, we recursively render the control again.

In the controller, we are simply passing in the categories where the ParentCategoryID == null.

On the host view (Index.aspx), we create the root unordered list with an ID of "treeview" and pass in an array of the Parent categories (categories where the ParentCategoryID == null) from the controller.

Here's a look at the output WITHOUT the jQuery magic.

Now all we have to do is add the libraries we're going to use and hook up the Treeview plugin.

Note: I always use the jQuery script from the Google API's. By referencing it from Google's server, you get to ride along their CDN, compression, etc. capabilities. As an added bonus, if your user has already visited a site that referenced the same library, the jQuery library would be cached on their browser so they don't take the hit of having to download it again. Sweet!

In our jQuery script, we just get the ul's element ID and call the plugin's treeview() method with no options.

When we refresh the page, we see jQuery has done its magic and now we have collapsable, rich tree view.

There's a ton more options in the Treeview plugin that you can check out for yourself, including async loading with ajax, and tons of customizations. ASP.NET MVC and jQuery - a match made in heaven!

Hope this helps!

RESTFul Ruby on Rails Resource for ASP.NET MVC ideas

MikeBosch — Tue, 21 Oct 2008 02:49:00 GMT

I've been feverishly adapting and experimenting with the ASP.NET MVC Framework since the very first CTP. I must admit, it keeps getting better with every release. This past week was the official BETA release and I'm loving it.

It has been a challenge for developers new to the concepts of MVC to find reference samples to help architect MVC web applications. For this, I've suggested to look towards more mature MVC frameworks such as Ruby on Rails for common patterns in MVC applications. RoR is not difficult to read and you'll certainly be able to follow the program logic. I've HIGHLY recommend you take a look at this white paper exploring RESTFul Rails and then see how you can apply it to ASP.NET MVC.

GiftListr Beta - ASP.NET MVC Facebook Application

MikeBosch — Tue, 05 Aug 2008 15:26:00 GMT

UPDATE: Installation of .NET 3.5 SP 1 on my web hosting completely killed this app! I'm currently going through the process of upgrading it but it will be down for a while.

I am officially announcing the beta release of the GiftListr for Facebook application.

GiftListr is the only truly universal gift registry allowing you to add products from ANY website without limitations. Just browse stores the way you usually do when you shop online. Once you find the item you want, simply copy-and-paste the url into the GiftListr application. GiftListr will then download all the product information and product images available. You can add notes to each item and share you gift list with friends.

The application is built entirely on ASP.NET MVC and makes extensive use of the jQuery library. It also uses the Facebook Developer Toolkit available on CodePlex. I would love to hear some feedback from the ASP.NET community. Let me know what you think. Any features you'd like to see? Would you be willing to contribute to it if I add it to CodePlex as a community project?

Part II - Fluent Filters, IQueryable and Linq To Sql for Easy Data Access

MikeBosch — Fri, 01 Aug 2008 12:00:00 GMT

I decided to write a second part to my previous post on extending the IQueryable interface to create a really neat and organized data access layer with Linq To Sql. The cool thing about this practice is that it nicely separates individual filters for integration testing and then lets you combine them to form much more complex queries.

I added a new filter, CreatedBefore, which simply filters on the created date of the blog.

I can now use this by itself or daisy-chain it with the other filters I've created. The resulting T-SQL is below. Note the new CreateDate filter's effect on it.

Linq to Sql gets even cooler! Let's say a Blog had associated Posts (a standard one-to-many, parent-child relationship). This would result in a entity model similar to the one below.

Using the same filters I already created for the Blog entity and combining it with the DataLoadOptions property of the data context, I can now get not just the filtered Blog entities, but their associated Posts in just one trip to the database! Nice!

I've blogged about how to use the DataLoadOptions in a previous post. Setting this as usual gives you the immediate result you're looking for.

The generated T-SQL statements start to get a little uglier, but I'll take the Pepsi challenge when it comes to some custom SQL a developer might have written for this same functionality.

Hope this helps!

Fluent Filters, IQueryable and Linq To Sql for Easy Data Access

MikeBosch — Thu, 31 Jul 2008 13:00:00 GMT

Inspired by Rob Conery's great work on his MVC Storefront screencasts, I decided to look into his Pipes and Filters implementation and attempt to create my own. Although there was a lot of critical commentary on some of the design decisions, I found myself very intrigued by this fluent interface implementation. I haven't referenced back to the specific code samples so if it differs significantly, please keep in mind that this was certainly inspired by it.

A very nice feature of Linq to Sql is that it delays query execution until you start enumerating over the collection. This lets the developer build complex queries programatically and make only one call to the database. Linq to Sql is smart enough to derive the resulting T-SQL to produce your result set.

For this scenario, let's assume we want to select blogs that are tagged with specific tags and the blog name starts with a certain string. Below we can see a simple entity model that shows the relationships among the Blog, BlogTag and tag tables.

Let's keep the domain-specific language for our extension method names. I'll create two extension methods: "AreTaggedWith" and "BlogNameStartsWith". The former will accept a string array of tags and the latter will accept a string parameter. Both of these methods extend the IQueryable<Blog> interface and return the same.

We can then "daisy-chain" these all together to create are linq query before actually enumerating (and therefore executing) the final query. This will produce a nice looking, fluent interface for our data access layer.

Using SQL Server Profiler, we can take a look at the query that Linq to Sql actually generated and how it is executed with input parameters and all.

Looking at the query above, I'd love to hear your thoughts on whether this is the most tuned query for this scenario. Did Linq to Sql did a good job generating the query?

Using mbUnit's RowTest Attribute in a TDD Scenario

MikeBosch — Wed, 30 Jul 2008 14:00:00 GMT

Part of a project I'm working on requires users to tag certain items. These tags are subscribed to by other systems and are also used to provide some neat auto-complete features for other inputs throughout the site. Since new tags can be added by a user, I want to make sure that when the tag is added, the capitalization is in Title Case. Here's a quick demonstration of how to use mbUnit's RowTest feature to allow you to test more scenarios with less code. First, lets take a standard, single scenario test:

As you can see above, I am setting an expectation on my repository that when it is called, it will insert the original input as a properly formatted string. The formatting will be implemented within my service class. Running this yielded a filed test - RED (good!).

Now let's implement this feature:

I decided to create a string extension method which uses the little known ToTitleCase method of the TextInfo class. This method accepts a string and returns it as a title-cased string. Also note how we can split the dot-notation across lines making it much cleaner. Below is the actual service call which will format the string and call my IRepository method:

After implementing this, I went back to the test and ran it. Success!

At this point, something occurred to me. The tag name "test tag" is easy to verify. However, how will this implementation handle capitalization rules? For example, if I enter "LCD Repair" as a tag, it should NOT format it to "Lcd Repair". This is where the RowTest feature shines. Instead of writing a new test for each of these scenarios, I just converted my "Test" attribute to "RowTest" and changed the method signature.

As we can see, the method signature matches the individual Row parameters. When we run this test again, it executes the test once for each row. When you actually look at the test runner, it shows up as 3 individual tests so each row can fail independently.

Hope this helps!

ASP.NET MVC Hosting Recommendation (if you're on a budget)

MikeBosch — Tue, 22 Jul 2008 17:44:00 GMT

If you are looking for ASP.NET hosting, I HIGHLY recommend you check out DailyRazor.com.

I wouldn't usually write up about a hosting company unless I really liked what they were offering. I think they have the best deal out there for ASP.NET hosting. I recommended them to a friend who was looking to host his site and he was extremely grateful. I figured the rest of the ASP.NET community might appreciate it as well. I'm actually hosting a few websites with them using the ASP.NET MVC Framework and have no complaints. I am especially impressed with their technical support. They respond quickly and solve issues with very little "back and forth".

They also have this "quadruple promotion" that lets you upgrade any plan (starting from 5.95/month) to quadruple the features you get. The cheapest package of 5.95/month gets you 8 websites and 8 MSSQL 2005 databases. This is the best deal I've found on hosting. I think you also get 15% off of your order. If you're looking for hosting, I highly recommend these guys. Make sure you ask about the "quadruple promotion" if you don't see an add for it. Check them out: http://www.dailyrazor.com.

Debugging Running Processes in Visual Studio

MikeBosch — Fri, 20 Jun 2008 12:30:00 GMT

I recently was overhearing the conversation a colleague of mine was having about debugging a large Win Forms application. It seems he was jumping through some major hoops to be able to debug the application. Without getting too much into the architecture of the solution, it was instantiating other applications through a messaging system backend to communicate between apps. In order to debug it, the team was using some code workarounds to kill processes, muddle around with new threads and processes, create a new process in debug which then impersonates some other process etc. At least that’s what I think was happening.

This kind of debugging situation can be solved easily by using the "Attach to Process" debug functionality in Visual Studio. I was surprised that the team didn't know about this feature so I wanted to post a quick "How-To" on using it so others can benefit from it.

A couple of prerequisites must exist in order to attach to a running process.
(1) The source must match the running application
(2) The running application must have been compiled in debug mode

It's fairly simple. When you open up the source in Visual Studio, just navigate to the Debug menu and you'll find a menu item "Attach to Process".

When you select this, you will be presented with a window that shows all your running processes. Simply click on the process you want to attach to and you're done.

If you're debugging a web application and using IIS to debug, you can even attach to the ASP.NET worker process "aspnet_wp.exe". This will allow you to break on external requests to your web app. If you're using the ASP.NET development server, you'll also find this on the list of processes you can attach to.

Hope this helps.

A "Friday the Thirteenths" Solution

MikeBosch — Mon, 09 Jun 2008 16:26:00 GMT

There was a recent post on LessThanDot to create a small application to find all the "Friday the 13th's" occuring in a range of dates. Here is my simple solution to the challenge. I also made it flexible enought to find any occurrence of a day / day of week combination within that range. It runs surprisingly quick even when looking over the next 500 years.

Also, if you like my color scheme, I've made it available for download here.

Showcase of "Live" ASP.NET MVC Sites

MikeBosch — Mon, 05 May 2008 12:00:00 GMT

It looks like people are starting to deploy sites based on the ASP.NET MVC Framework already. I've been trying to collect some examples and here's what I got so far.

GiftListr Facebook Application - First and foremost, my own Facebook application. Read more.
FlingMix.com - FlingMix.com is a craigslist-like dating / adult personals site built using ASP.NET MVC. WARNING!!! MIGHT NOT BE SAFE FOR WORK.
Kigg - Kigg is a Digg like application developed with ASP.NET MVC
RowTube.net - RowTube is a place to view the latest rowing videos.
Shinyzhu.com - ShinyPortal is a mini portal created by ASP.NET MVC Preview 2.
Yonkly.com - Twitter clone done in ASP.NET MVC.
Jobtree.com.au - Looks like some sort of job site done in ASP.NET MVC.
AboutJasonJung.com - Small personal blog site of Jason Jung
MyTPI.com - Site about golf health and fitness
LizzabethBrown.com - Real estate site.
NewPerceptionsTech.com - New Perceptions Technology is a custom software solutions provider specializing in website development
GetRocketShip.com - Hosted website CMS service for small businesses using MVC

If you have a site that you're developing using the ASP.NET MVC Framework, please let me know about it so I can include it here.

Real World Website Architectures

MikeBosch — Wed, 23 Apr 2008 13:49:00 GMT

Have you ever wondered how major sites are logically and physically built? Not as some high level with shaded boxes but at real platform level details.

I’ve been looking for a site like this for a while. No theory here, just real details about the servers, platforms, db’s, caching, apache mods etc. that the “big boys” use – Facebook, Digg, YouTube, craigslist, MySpace, Wikipedia, PlentyOfFish, Amazon and more...

http://highscalability.com

Using the ComponentController in ASP.NET MVC CTP 2

MikeBosch — Mon, 10 Mar 2008 16:45:00 GMT

ASP.NET MVC CTP 2 shipped with a new controller class which you may have missed. Community feedback begged for a better way to handle component pages that don't rely on the main page's view data. A classic example might be a stock ticker. We would want a reusable component that you can place in other pages.

The ComponentController allows you to call a controller action from within the page itself. It's use is very similar to the regular controller. You basically create a new class the inherits ComponentController. Then you create public methods as the actions of the controller. Within the action method, you can implement whatever logic you need the component to perform. You finally call RenderView to render the view just like the regular controllers.

It's important to note that the ComponentController doesn't look in the same places as the regular controller when finding the views. On this CTP, all component views need to reside in the right directory for the RenderView method to find it. The convention is Components/[ComponentControllerName]/Views/[ViewName] directory. In this case, the name of my controller is MyComponentController and the view name is CustomerOrderView

I'm not a big fan of forcing convention this since I may want to put my components wherever I please, but I digress. Let's look at the controller.

This very simple controller has a single action named ShowCustomerOrders. This method calls my order repository and returns a list of orders for a customer. I will be able to use this on any view where I need a quick summary of the customer orders. It accepts a CustomerID and renders a view named CustomerOrderView.

From within the page, I'm using the lambda notion to make the call to this controller. The Html helper has a method called "RenderComponent". I specify my component controller and the action it should call. In this case we are passing the customer ID "1". This can be easily replaced with some of the view's ViewData properties.

Taking a look at the view that my component will render, we see it is a simple list using a strongly-typed CustomerOrder[] as the ViewData.

That's all there is to it. When we run the page, our customer orders show up where I placed the call to the RenderComponent method.

Hope this helps!

UPDATE: I uploaded the source code for the example. Download it here.

ASP.NET MVC Tip # 7 - Using a CAPTCHA with MVC

MikeBosch — Fri, 07 Mar 2008 17:17:00 GMT

Problem:

You need a CAPTCHA to use when submitting forms in MVC

Solution:

For this I will defer to an excellent explanation:

http://www.coderjournal.com/2008/03/aspnet-mvc-captcha/