Work Around Your ASP.Net Session Serialization Issues

OK. We’re going to assume everyone here knows about ASP.Net Session state. We also will assume that you know there’s 3 modes, InProc (default), State Server, and SQL. The latter two will be the topic of discussion here. The biggest difference between the InProc and out of process state management systems is that the objects…


Creating Nullable<T> When You Don’t Know T

This bit came about from a post from Brad Wilson back in July that some of my Magenic buddies sent me. I won’t repeat what his issues are (you can read it for yourself) but here’s the solutions to his misunderstandings regarding nullable types. Maybe I’m missing something here that’s subtle in his requirements but…


Handy Extension Methods

This entry was edited July 16th, 2008 to include an additional extension method courtesy of Alex James //Copyright (c) 2008 James Zimmerman //Permission is hereby granted, free of charge, to any person obtaining a copy //of this software and associated documentation files (the “Software”), to //deal in the Software without restriction, including without limitation the…


Server Side Pagination in T-SQL / LINQ

OK it came as a shock to me that so many people were building huge sets of query data that they are binding in their UI and then deciding to page it at like 10 rows per page. I’m not talking about 1 or 2 or even 3 pages of data, I’m talking about hundreds…


SIDs in T-SQL

If you are in a situation where you need to pass a windows domain user into SQL then you might want to think about this. The most reliable way is to use the user’s SID (security identifier) because SIDs never change (aliases can possibly change); however, it may not be technically feasible. An example of…


Who says that Microsoft doesn’t have a sense of humor?

Here’s my team at Microsoft’s EULA Microsoft CorporationEnterprise Services and Business ProcessesTeam MongooseEND USER LICENSE AGREEMENTIMPORTANT – READ THIS CAREFULLY: This End User License Agreement is a legal agreement between you (either an individual, business entity, currently active identity of an individual with Multiple Personality Disorder, octopus overlord, or otherworldly entity), and Team Mongoose –…


Threads, meet Transactions…

Using multi threading and transactions in .Net OK this is a pretty simple idea but one that I don’t think people grok very well. Or at least the code I keep running into doesn’t make one think that the writers of said code get ambient transactions in the least bit. Basically what I am talking…