Hot off the presses, and new to ASP.NET MVC (Preview 5) is an awesome capability that (in my opinion) revolutionizes the way we design web applications. This feature is being touted (by me) as “the ViewState for MVC”. First, the Challenge A common challenge of web applications is passing complex types and (more difficultly) stateful [...]
Read More >>
One of the biggest benefits of MVC is it’s direct link to Test Driven Development. Because of some of the new features of ASP.NET MVC Preview 5 (ModelBinders in particular), testing your Action methods is even easier. This article will demonstrate how easy it is to ensure the quality of your MVC app with unit [...]
Read More >>
As AJAX-enabled web sites continue to grow in popularity, the development community continues to try to solve the common problems of using AJAX. One big concern that used to require a lot of work is that of gracefully degrading your AJAX site for non-capable browsers. Thankfully, the ASP.NET MVC framework makes this an easy task. [...]
Read More >>
![]()
ASP.NET is an awesome web development platform that many developers wouldn’t ever want to part with. However, if given the option, there are definitely parts of the package that you may want to swap out. This article will show you how easy it can be to break away from the “inline-ASP” or “Web Forms” world, [...]
Read More >>
![]()
Assumptions If you are reading this article, you should already have a working knowledge of SQL and are familiar with filtering your data with a WHERE clause, or limiting your result set from joining other tables with an ON clause. The part where this article comes in is when you start to see a significant [...]
Read More >>
![]()
Creating and maintaining ‘customer’ data is a common task that most people handle by creating a single table that holds a customer’s FirstName, LastName, Address, City, State, Zip etc. But when it comes to tracking changes in a customer record this type of table fails to provide needed functionality. This article will show how to [...]
Read More >>
![]()
Often times when inserting a new record into a table that has an auto-key field (an identity field that is set to auto increment), you may need to get that new ID back to use in other SQL statments. This can be done with @@IDENTITY or SCOPE_IDENTITY(), but those methods are very limited when compared [...]
Read More >>
If you’ve used other flavors of SQL (such as MySQL or PostgreSQL) and now you have switched over to TSQL (Microsoft SQL Server) you may have noticed that there is no native way of doing pagination. In some SQL versions, pagination was as easy as “SELECT * FROM ‘myTable’ LIMIT 0, 10″ and that would [...]
Read More >>
Many articles about SQL are spread too thin with “the basics” of a SELECT, INSERT, UPDATE and a DELETE. By the time your done, you know a little about everything, and nothing useful. This article will focus on the meat of SQL, getting the data you want. We’ll start off with the simple, and move [...]
Read More >>
The previous article in the “Understanding SQL” series brought us from easy SELECT statements to more useful JOINs and subselects. This article will go into more advanced queries using Common Table Expressions (CTE) and aggregated results with the GROUP BY clause. The two don’t need to go hand in hand, but this article will utilize [...]
Read More >>
