Technology News, Technology Resources, Technology Articles

Model Binders in ASP.NET MVC

October 29th, 2009

MVC Model Binders Demo Screen ShotHot 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 >>

Author: admin Categories: Web Programming Tags:


Test Driven Development with ASP.NET MVC

October 29th, 2009

New ASP.NET MVC Preview 5 project in Visual Studio 2008One 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 >>

Author: admin Categories: Web Programming Tags:


MVC AJAX Sites That Gracefully Degrade

October 29th, 2009

ASP.NET MVC - AJAX application that gracefully degrades part 1As 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 >>

Author: admin Categories: Web Programming Tags:


Creating a Custom View Engine in ASP.NET MVC

October 29th, 2009

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

Author: admin Categories: Web Programming Tags:


SQL Performance – Clustered Indexes

October 29th, 2009

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

Author: admin Categories: Database Programming Tags:


How To: Maintain Customer Payment History

October 29th, 2009

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

Author: admin Categories: Database Programming Tags:


Get Identity Field and More From Inserts

October 29th, 2009

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

Author: admin Categories: Database Programming Tags:


Pagination In SQL Server 2005

October 29th, 2009

SQL results for 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 >>

Author: admin Categories: Database Programming Tags: ,


Understanding SQL: SELECT The Data You Want

October 29th, 2009

SQL results from joining the orders table to the orderitems tableMany 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 >>

Author: admin Categories: Database Programming Tags:


Understanding SQL: Complex Queries

October 29th, 2009

Latest order time and total items purchased per customerThe 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 >>

Author: admin Categories: Database Programming Tags: