Jerry Young's Tech Blog

Email Approval Considerations

2017-06-28T17:06:00.000-05:00

Recently wrote a service for handling lazy approvals. IE someone gets an email that they can reply to with an "approved" or "rejected" response and the system uses that to continue its workflow/process.

I can't share the code for it but wanted to overview some of the challenges/considerations I ran into in case anyone is looking to write their own.

1. Validation: I originally added a custom MessageId into the emails that I logged along with the recipient address so I could validate an email response was "valid". However, replying to a message generates a new MessageId and the original wasn't available to me in the 3rd party IMAP library I used.

2. Parsing: When trying to determine what request the email approval was in reference to there is parsing involved. This can get tricky if the email has been forwarded, replied to several times, or the subject altered. I found in one case when testing a peer replied and their web-based email client put some unexpected formatting into the message. A good solution is to use TDD (test driven design) and build some good tests to validate these scenarios as they arise.

3. Responses: To allow for some flexibility I had to create a dictionary of words/phrases that tied back to the response I was expecting. IE "approved" would be considered approved if the response was "yes" or "affirmative".

4. Approval process workflow: What happens when you reply approved but quickly change your mind and reply rejected? Does the last response become valid? Is the 1st response valid? If the response is invalid do you allow users to reply until a valid response is given?

Deep Object Comparison

2016-09-19T18:43:00.000-05:00

As I mentioned in my last post you can't compare reference types using the == operator because it compares the memory addresses not the values. So even with everything being the same two objects will never equal each other.

Below is some sample code that actually does a deep comparison of object to figure out if they are similar or not.

By deep I mean it will recursively follow all enumerations down to their lowest levels and compare them as well.

You might notice that there is no comparison to check the objects are the same type. If you are not familiar with T it is a generic and forces the compiler to ensure objects are of the same type to be passed into this method.

You'll also notice that values are compared as strings but for my purposes and at least to get you started this is sufficient.

If there was data you wanted to return you could also modify the return type to be a response object with a bool to indicate if objects are the same and a list of which fields differed per your needs.

public bool ObjectsAreSame(T a, T b)
{
bool result = true;
var t = a.GetType();
var properties = t.GetProperties();

foreach (var p in properties)
{
if (typeof(IEnumerable).IsAssignableFrom(p.GetType()) || typeof(IEnumerable<>).IsAssignableFrom(p.GetType()))
{
ObjectsAreSame(a.GetType().GetProperty(p.Name).GetValue(a, null), b.GetType().GetProperty(p.Name).GetValue(b, null));
}
else
{
if (a.GetType().GetProperty(p.Name).GetValue(a, null) != null && a.GetType().GetProperty(p.Name).GetValue(b, null) != null)
{
if ((a.GetType().GetProperty(p.Name).GetValue(a, null).ToString()) != (b.GetType().GetProperty(p.Name).GetValue(b, null).ToString()))
{
result = false;
break;
}
}
}
}

return result;
}

C# Value vs Reference Types

2016-09-15T21:59:00.001-05:00

A refresher for those who may have forgotten about the wild world of value versus reference type.

Assume you have an object as follows:

public class Person

{

public string FirstName {get;set;}

public string LastName {get;set;}

}

Now assume the following code is executed:

Person a = new Person() { FirstName = "John", LastName = "Doe"};

Person b = new Person() { FirstName = "John", LastName = "Doe"};

Asset.AreEqual(a,b);

This asset will fail. At initial glance you might think "but the values are the same". Yes, they are. But that is not what is being evaluated! Because a class is a reference type what is being asserted is that the memory location of a is the same as b. In this case, they are not because they are two separate objects.

There are several ways to address this. One way would be to override the Equals method on the Person object and do a field by field comparison. Another way might be to override the ToString method which would return a value type that could be compared.

The way I prefer to do this is to create a method that uses reflection (and generics, recursion) thoroughly compare all the object's fields. This way there is no refactoring if fields are added/removed/changed.

Value types, however, will pass this asset. For example:

string a = "Hello!";

string b = "Hello!";

Asset.AreEqual(a.b);

In this case, we're not checking the reference but actually comparing the values.

Another interesting thing here that trips people up is if you pass an object by reference then all changes in a method will be reflected in the original object; not so in a value type.

Assume something like this:

public void ChangeName(Person aPerson)

{

aPerson.FirstName = "Billy";

}

public void DoSomething()

{

Person a = new Person() { FirstName = "John", LastName = "Doe"};

ChangeName(a);

Asset.AreEqual(a.FirstName, "Billy");

}

This will work because ChangeName received the memory reference to a and updated the name. For a reference type, this will not work.

Entity Framework - Foreign Key Fields

2016-08-23T00:29:00.000-05:00

Something to keep in mind when working with objects that require a foreign key value; Entity Framework can handle this automatically.

If you have an object that requires a foreign key value you might have found yourself calling SaveChanges to save one object to the database to get its ID so you could insert it into another object.

The better way is to use the ForeignKey property on your corresponding property. The convention is [ForeignKey("ForeignTableNameHere")]. You'll also want to a a public property for the foreign table as well.

Now you can call SaveChanges once at the very end and the foreign key will get set across all the necessary objects.

OleDB Alternative

2015-02-18T11:57:00.002-06:00

Had an interesting issue come up using OleDB worth noting...

I was working on a project to import data from a tab delimited file into SQL using SqlBulkCopy. The OleDb file count matched the record inserted file count but comparing the output to the old application with the same data produced different results.

I dropped the file into Excel and it also showed the same results as OleDb. However, when opened in Notepad++ it became apparent that OleDb and Excel (presumably using OleDb to import the file) was merging some of the row data into a description column in the file.

So from all appearances it looked like the process was working but in reality it wasn't.

The workaround was to replace using OleDb with TextFieldParser. You can find plenty of examples of how this works by searching for it. You will need to add a reference Microsoft.VisualBasic.FileIO which is odd but that's where they put the TextFieldParser.

Once I implemented this change to read the file into a DataTable the results matched the old application.

SharePoint Online Tidbits

2014-07-11T20:31:00.000-05:00

I've been working on a project of late that is using SharePoint Online 2013 as part of the solution. It was not a platform I chose but one that already existed and I was asked to continue building on. For those who might be evaluating a cloud SharePoint solution or those who are just starting to work in it these are my tips, tricks, and tidbits. Please keep in mind this post is specifically about SharePoint Online 2013 and that on premise SharePoint 2013 has differences and limitations that can be overcome.

1. Be aware of the threshold limit. You can't change this online (you can on premise). If you have any type of data request that has to deal with more than 5,000 records it won't work.

- If you have 5001 items or more in your "All Items" view; it won't work.
- If you need to search that field by a single key with more than 5000 results; it won't work.
- Same deal with an API call.

Having said that... Yes... you can have lists with over 5,000 items and still work with them. The big key to this is multiple indexed fields. You can build views that use those multiple indexes and CAML queries via the API as well. A client has 1.5 million rows in several SP Online lists that they're querying in this manner. Do I recommend it? No. But it is possible.

2. Service durability. I'm not sure how they have the Office 365 cloud setup but our instance constantly has problems. Some days I can't login to the Office 365 admin site. Some days users can't save pages with content web parts. Some days something is in extended recovery and other things are slow or quirky. It has caused issues especially at inopportune times.

3. DEV/QA/Prod Environments. Out of the box this concept really doesn't exist. You can't really bundle up a site and deploy it to another site. There are really 2 ways to try and do this. One is saving a list or page as a template (with or without content). It works ok in the same site or in a subsite of the site. You can export large amounts of data to Excel and import them into other sites but it doesn't preserve the meta data. By that I mean Site A might be a drop-down list but Site B that drop-down will be a text box. Not to mention intenal field name issues (see below). You can export an entire site as a template too but it has a 50mb limit.

Keep in mind that SharePoint isn't really a traditional IT application. In that I mean you don't have deliverables (EXEs, DLLs, SQL scripts, etc) that you can deploy to various environments. It is really a publishing model. You checkout a page, you save the changes, and when you're ready for it to go "live" you check it in.

When you want to have a QA team test your solution/changes end-to-end you have a lot of work to build a suitable QA site or even a DEV site. I've done it but it is tedious.

4. Scripting is your friend. Angular, KnockOut, JQuery, or plain old JavaScript. Drop them into a Script Editor Web Part and fire away. We used BxSlider, SimpleModal, KnockOut, the SharePoint JS, etc with no issues. We're also looking at using Bootstrap for responsive UI.

SharePoint Online does NOT want you running resource intensive things on their cloud solution so the more things you push to scripting the happier everyone will be with this solution. See 9/10 for SharePoint/Offsite App tidbits.

5. Internal field names can be an issue. Say I have Site A and I created a List called MyList. And in my list I have firstnnname and Last Name. I realize after I created the list that I misspelled first name and didn't follow the same convention (spacing and case). I rename "firstnname" to "First Name". Everything will seem OK until you use an API.

When you use the API two things happen to be aware of...

First, you'll notice in an API call that there is no "First Name" or "Last Name" field! First Name will appear in the XML as firstnnname. "Last Name" will appear as Last_x0020_Name.

SharePoint will use whatever the original name of the field was. So often times a list will have a "Title" field which will always be Title in the API even if you rename it. And spaces will be replaced by "_x0020_" because is how SP handles spaces.

Oh hey... remember #3 when I talked about Excel exports? That's the second thing. If you exported this hypothetical MyList via Excel there is no meta data. So when you call the API it WON'T be firstnnname! It will be First_x0020_Name because that is what SharePoint is going to put into the column header which the Import will use to create the column name.

6. The API is useful but it has limitations. I used the SharePoint library and Knockout JS (KO) to query lists and bind them to KO templates. It allowed me to do basically an MVC-eqsue solution inside of SharePoint. However, the API can't get AD groups and such. It can pull attributes but not groups. My workaround was to create a Script Editor Web Part with a target (advanced -> target audience) of an AD Group that set a variable in JavaScript that I could use to determine which user group had logged in. We only had 1 group that had different content but you could get very complex very quickly with this approach.

I'll also add that luckily only the pieces applicable to the user are rendered so even if you have a bunch of stuff on a page if you're using Target Audiences the intended audience will only get the content rendered for them.

7. Targeting individual list items. You can do this with a Content Query Web Part (CQWB). It is smart enough if you go into a list and enable target audiences to return only the items that the logged in user has access to. You CAN'T add a List Web Part that has target audiences set on list items and expect it to work. It will show ALL list items.

I found the CQWP limiting because it offered you 4 fields (title, description, link url, and image url [names might be slightly different]) and basically looked like search results. Apparently you can use CSR (Client-Side Rendering) to doll these up any way you want but my solution didn't do that because I was doing back-end coding and we didn't have a UI/UX resource and didn't know once we got one if he or she would be able to do this.

8. CSS. Good and bad SharePoint has branding/master page/master template type functionality. It is great if you want a consistent look and feel but my team found early on that when we were redoing parts of a site that SharePoint was trumping our CSS. The hack and slash solution is to specify a style element on page elements and style away. The better approach is to make sure your CSS you are referencing has greater specificity than SharePoint. To that end anything we wanted to style had a class name and we styled the class not the HTML elements themselves.

9. Custom SharePoint Apps are a mixed bag. They have some limitations which you can see on the link provided below. I also find them to be a little slow to load and respond. It also stinks that an app will be unavailable while a new build is uploaded. I can edit and save a page in SharePoint with the published version alive and well all day long.

http://msdn.microsoft.com/en-us/library/ff798382.aspx

10. Cross domain is an option. You can setup a relying party and do stuff with SharePoint Online on premise and IFrame in content. A vendor ran into issues with token lifetime which required you to re-authenticate with ADFS inside the frame.

IIS and .NET

2014-03-30T16:06:00.000-05:00

A few things that came up during a deployment that I thought would be worth noting for anyone migrating to a new server...

1. Make sure that the full .NET install is performed. There is a "client" profile which doesn't include everything and some things are in a different assembly than the "full" framework. You need to specifically target the client framework in your build to use it.

2. The 2.0 and 3.0 frameworks register MIME types and handlers in IIS that you'll need for ASP.NET and WCF. You can run aspnet_regiis in the 2.0 and 3.0 folders to get this done manually. Your 4.0 framework project will have issues if these things were not done.

-JY

WCF Concurrency and Instances

2014-02-27T18:39:00.000-06:00

A quick tidbit regarding WCF in terms of performance.

You may be used to using the [ServiceContract] attribute to decorate your WCF method without giving it a second thought. Then as time goes on you may notice that as more users hit your service the performance isn't what you were expecting.

One of the drawbacks to just using [ServiceContract] is that be default it is to create a new instance of your service which only handles one call. This is fine if you need to do session management but in many cases a REST service will not.

A good practice is to decorate your methods with [ServiceBehavior] which allows you to change how the service operates. By using this behavior and settings the InstanceContextMode to Single you now have a service where all clients calling will use the same instance. So if you are caching data then the performance from that can be realized. In the default mode each client gets its own instance which takes up memory and doesn't serve anyone except the same caller on sequent calls.

Note: You thread safety becomes important in this case.

You can also change the ConcurrencyMode to determine how a call is handled. In Single mode only one call is handled at a time. So if you had a method that returned a number that is incremented continually, no call would get the same number because each call would wait until previous calls completed.

In a Multiple concurrency mode you would have to wrap the incrementing number with a lock or other thread safe mechanism otherwise you might get a conflict or deadlock because too many operations are trying to perform operations against the simple number field.

There is a 3rd mode called Reentrant which would be a special case that I've chosen not to cover here.

So in summary, look at adding the InstanceContextMode and ConcurrencyMode attributes found in the ServiceBehavior attribute instead of just a ServiceContract attribute to better control how your WCF service operates and to tweak performance based on how you need to service to scale/perform.

GAC Priority over Local

2014-02-12T19:22:00.000-06:00

Something to keep in mind that came up today on a project. If you have a DLL installed in the GAC and the same DLL in the local folder of the application then GAC will take priority.

In the case we ran across today there was a wrapper DLL given to multiple teams and someone installed the DLL in the GAC. There was a bug that was found and updated in the wrapper but the DLL in the GAC wasn't updated.

This would be a good reason to version your DLL as well. If the version in the GAC doesn't match the local folder then the local folder would be utilized.

SQL Field Encryption

2014-02-06T06:56:00.000-06:00

If you need to encrypt some data for security in SQL here is how you go about it...

1. You need to create a master key in your database if one does not already exist
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'YourPassword';

2. Create a certificate.
CREATE CERTIFICATE YourCertificateName WITH SUBJECT = 'Some Description';

3. Create a symmetric key.
CREATE SYMMETRIC KEY YourKeyName WITH ALGORITHM = DES
ENCRYPTION BY CERTIFICATE YourCertificateName;

4. To encrypt a field. Example below will encrypt each YourField column in table YourTable. NOTE: Be sure to set your encrypted fields to varbinary(128) so you can see the field value. Otherwise the field may appear blank.
OPEN SYMMETRIC KEY YourKeyName DECRYPTION BY CERTIFICATE YourCertificateName;
UPDATE YourTable SET YourField = EncryptByKey(Key_GUID('YourKeyName'), YourFieldName);
CLOSE SYMMETRIC KEY YourKeyName;

5. To decrypt your field. This will put the field YourField back to plain text in the output query.

OPEN SYMMETRIC KEY YourKeyName DECRYPTION BY CERTIFICATE YourCertificateName;

SELECT CONVERT(VARCHAR, DecryptByKey(YourField)
AS 'Decrypted Field'
FROM YourTAble;

CLOSE SYMMETRIC KEY YourKeyName;

WHS 2011 Web Access Setup

2014-02-05T18:55:00.000-06:00

In order to be able to access your WHS 2011 server remotely via the web you'll have a couple of setup steps.

1. Enable Web Access. Open the Dashboard and one of the tasks will be enabling the web access. It will enable it but it may fail due to router settings.

2. Enable port forwarding on your router. Technically, you could DMZ the server but its not secure or the preferred method. Port forwarding is a better option. You'll want to record the internal IP that your server is on and forward the appropriate ports to your server.

Ports to forward:
443 is HTTPS which is what the remote access site included with WHS will run under.
3389 is the RDP port if you want to remotely access your server using Remote Desktop.
80 is HTTP is you're going to host a website or something.

There are other ports for mail, ftp, etc if you're interested in enabling those for your purposes.

If you're looking for a free solution to access your server with a friendly name rather than the public IP (which can change) I would recommend looking at No-Ip.com. They have an executable that can run as a service to update their DNS when yours changes. So you get a friendly IP even without a static public IP and its free.

Windows Home Server 2011 Client Connector Woes

2014-02-02T22:53:00.001-06:00

I tried to fire up my original Windows Home Server (WHS) machine but one of the drives was failing and the system wouldn't boot due to file corruption.

So I built a new box running WHS2011 which I was able to buy for $50 at the local computer parts store. That version is basically a flavor of Windows Server and even has IIS installed so its great for a home development box for whatever projects you have.

Unfortunately, upgrading wasn't simple. The new connector software complained there was already a version of the connector installed. The version installed didn't want to uninstall.

I tried to manually delete the files and some registry entries but the new connector still complained. Additionally, it caused my active window to lose focus because an installer was trying to load up constantly.

After a few hours I figured it all out. I went through every entry in the registry with "Windows Home Server" and deleted it. This made the connector installer work, but it would fail part way through and rollback.

I found a Microsoft KB article about a service needing to be enabled and at least set to manual if not started. The name escapes me but it was Media Center related. As it turned out I deleted some registry entries for WHS related to Media Center thinking the new connector install would replace them.

To fix this issue I went to Programs & Features and uninstalled all the "Media Features" which required a reboot then installed them again. Then the new connector installed no problems and everything works great.

Suggestions that might help you circumvent these issues:
1. Create a restore point on your system and save backups of the registry.
2. Uninstall the old WHS connector while your old server is still running or before upgrading the software. I think part of the uninstall issue might have been the uninstaller trying to remove the user from the WHS machine and couldn't because mine was offline.
3. Try using a different uninstall program like CCleaner.

WCF Service Response Time Slow?

2014-01-15T16:59:00.001-06:00

Recently ran into an issue testing a WCF web service deployed on a server. A call to a very light service was taking upwards of 15 seconds to return a response.

The service had logging which revealed the call into the service until a response was returned was a fraction of a second.

I decided to do a Fiddler2 trace against a test program to see what was happening and suddenly the service was returning nearly instantly. I continued to test and everything looked fine. I then closed Fiddler2 and then the slow response time returned!

What I ultimately discovered was Fiddler was un-checking the "Automatically Detect Settings" on the Internet Options. This can be found under Control Panel\Network and Internet\Internet Options\Connections\LAN Settings. That setting was apparently set as part of the configuration of my work machine. So that was what was causing the slowness.

I later recalled you can fix this in your WCF bindings by setting useDefaultWebProxy to "false" which ignores this setting.

Raspberry Pi -- First Impressions

2013-12-31T11:23:00.000-06:00

Overview

I recently purchased a Raspberry Pi board to play around with its capabilities. I've used the Arduino boards before and I think they serve a purpose but I wanted something with a little more horsepower that could run apps as well.

Setup

When the Pi arrived I had some initial problems but nothing too major. When I plugged in the Pi nothing happened even with the SD card installed. I was confused on this and there was no clear answers online.

It turns out that the installer I downloaded for Fedora Remix was old and I ended up having to download the new installer and newest builder of Fedora Remix. The newly installed image worked great and the Pi started right up.

I was impressed as well that a Gear Head USB keyboard and a USB mouse I had laying around worked instantly without any setup. It launched me into the GUI (Xfce) and walked me thought some basic install steps.

Impressions

Running via the GUI is a little sluggish. I found that browsing the web was a little slower than I would have preferred. I'm not sure if overclocking from 700mhz to 1Ghz will make a big difference in that regard or not.

I wanted to see if the Pi could render video and attempted to launch some type of streaming video. Netflix didn't work through Midori. Amazon wanted to download the Flash player which I started to do but didn't seem to finish. I will investigate these more. I will also attempt to run YouTue.

Next Steps

I want to try and get Spotify to stream from the Pi along with testing the GPIO. I'll see if I can get Netflix or Amazon Instant Video to run and see if it runs well. Eventually as well I want to use this to stream media from other computers in my household.

Card Shuffling

2013-10-25T15:51:00.000-05:00

I was playing around with building a card game engine and ran across something interesting. My solution as I found all over the internet was to use Random() to generate a random number and use that to "order" the list (array) representing the deck.

My "test" game was basically high card where each player had a deck and drew a card. The person with the highest card won the hand. As I ran the test either Player 1 won or the game was a draw. Player 2 never won.

As it turns out Random is not very good at generating random numbers. It uses a fixed algorithm such that the result are very predictable. Also, it is an expensive operation as it is not very efficient.

A sort is actually a better solution and using sometime to generate random unique values works better. I don't take credit for this code but here is an example of the better implementation:

var cards = Enumerable.Range(0, 51);
var shuffledcards = cards.OrderBy(a => Guid.NewGuid());

WebBrowser Control: Password Field Won't Populate

2013-09-23T14:10:00.001-05:00

I ran into this issue between version of IE. On IE10 on a password field using the WebBrower's SetAttribute method works to set the "Value" field of a password field. This does not work on IE 8 or 9. Instead, you have to use the "InnerText" attribute. To make sure 10 still works I have to set both the Value in addition to the InnerText value for the older browsers.

Using Silverlight Toolkits

2013-01-18T00:24:00.000-06:00

Quick tip: When using the Silverlight Toolkits keep in mind they typically target a specific version of Silverlight.

I recently installed Silverlight 5 and the Silverlight 5 toolkit. I added a reference to a v5 component and it appeared in my designer but my code behind gave an error it couldn't find the reference to the control.

As it turns out someone else on my team using TFS didn't have Silverlight 5 installed (only 4) and checked in to TFS with the project target as v4. Switching it back to v5 fixed the issue.

So be sure to check the target version if you're having trouble with a control from one of the toolkits!

Silverlight initalization error

2012-12-05T10:56:00.001-06:00

So I was copying and pasting some classes into my Silverlight project and when I ran it gave me a pop-up window saying it couldn't initialize the Silverlight app.

A cursory look revealed that I had accidentally deleted the "ClientBin" folder from my Silverlight web project (remember that there is the client piece and the web piece on SL apps). I added the folder back but the XAP file wasn't there!

I did a search and didn't find the solution for this but I figured it out so I wanted to make it available.

You'll need to go into the project properties (right click on the .WEB project and choose properties). Under the Silverlight Applications tab you will need to add the application.

Click "Add" then choose "use an existing Silverlight project in the solution" and add the SL project into the project.

As part of this it will also recreate the ASPX and HTML page(s) if you accidentally deleted those as well.

The exact message from the browser is: "Error: Unhandled Error in Silverlight Application
Code: 2104 Category: InitializeError Message: Could not download the Silverlight application. Check web server settings".

Silverlight Binding Error

2012-11-28T16:52:00.001-06:00

I ran into an error in Silverlight (v4) today and thought I might take a moment to document the problem in case anyone runs across the same issue.

I created a data grid and was assigning the columns manually. I decided to leave one column without a binding because it will be a combo box field and I wasn't ready to tackle that yet.

When I ran my app I received and error when I bound my objects to the grid. Since this is just a sandbox proof-of-concept thing I didn't have it wrapped with a try...catch so it actually came up as an unhandled exception in Internet Explorer.

The error will be "Value cannot be null." And you might drill down and find an error about an unexpected value as well.

The problem is that you have a field without a binding. So I removed this field (you may opt to add a binding to it) and problem solved.

Unable to install or run the application. The application requires...

2012-09-25T12:40:00.001-05:00

Ran into an error today doing a Click Once style deployment on my new PC. The end-user was getting an error ""Unable to install or run the application. The application requires ..." which proceeds to list the missing DLL and that it needs to be installed in the GAC.

I checked the reference and "Copy Local" was set to true so I knew the DLL was in the directory when the app runs locally but I found out that Click Once has a way of managing its dependency files.

When you right click on the project it brings up the project properties window. In VS2010 under the "Publish" tab there is an "Application Files" button. When you click this button it lists all the assemblies and gives you the option under the "Publish Status" column to choose if you want to include these files automatically in the deployment.

If you set to "Include" then its there but if its set to "Prerequisite" it will want that file to be installed on the machine prior to running the Click Once. Exclude is also an option but I don't think it does the prerequisite check.

Detecting Version in C# / .NET

2012-05-02T17:16:00.000-05:00

I've found occasion recently to know the version of Windows that a person is using in order to make a call to the correct API. Mainly, this has been a concern with clients using Windows XP and now moving onto Windows 7 and finding compatibility issues with 3rd party components.

By using System.Environment.OSVersion.Version we can look at the version of Windows running and determine the best source of action. The two properties we are concerned with are "Major" and "Minor".

You can find a complete list by searching for "System.Environment.OSVersion.Version" but basically, here is the rundown:

Major 5 will be 2000, XP, or 2003. You can tell by the minor version which one it is. Window 2000 is 0, XP is 1, and 2003 is 2.

Major 6 will be Vista, 2008, or 7. Minor 0 is Vista, 2008 is 1, and Windows 7 is 2.

There is also a "Platform" property that will tell you if the machine is running Windows or Unix or WinCE, etc. Since I know my client is running Windows XP or 7 ... I don't concern my self with that but you might need to.

So a quick example... maybe I need to load a different form with a Windows XP or Windows 7 specific control. I could do something like this:

If (System.Environment.OSVersion.Version.Major == 6)
{
//We're running Vista, 2008, or 7
//Load a form with the Windows 7 component
}
else
{
//We're running 2000, XP, or 2003. Hopefully not still on NT or older!!!
//Load a form with old Windows components
}

Database Connectivity in .NET

2012-02-23T23:07:00.000-06:00

Something to keep in mind about database connectivity in .NET is to always ensure your connection is being disposed of properly.

Many times as developers we code according to the "happy path" which can lead to some undesirable behaviors when an unhappy path occurs.

Here is a quick example (excuse any typos as I'm doing this from memory):

SqlConnection cnn = new SqlConnection(myConnectionString);
cnn.Open();
SqlDataReader reader = cnn.ExecuteReader(someQueryOrCommand);
cnn.Close();

We open a connection, get some data, and we close the connection. Easy, right? Probably works 99% of the time with no problems.

What happens if we timeout during the execution of our SQL query or command? Most of us are/should be using a try...catch block to catch that exception and deal with that error instead of having the app crash due to an un-handled exception.

A potentially big problem exists regardless of the try...catch block. Each time this code is executed and fails for whatever reason we are leaving an orphaned connection. If this happens enough times, we run out of available connections on the server and SQL is not responsive.

Commonly I see this problem when the database is performing slowly and causing a lot of database calls to timeout. A user may repeatedly retry a piece of functionality or may repeatedly close and re-open the application trying to get it to run. These orphan connections typically make the problem worse to the point that the server has to be rebooted.

A good way to handle/prevent trashing your available connection is by using a "finally" block in addition to the try...catch.

The finally block will execute regardless if the outcome of the code (IE, regardless if it goes through the try code with no problems or it hits the exception code block).

Pseudocode for this solution looks like this:

SqlConnection cnn = null;

try
{

cnn = new SqlConnection(myConnectionString);
cnn.Open();
SqlDataReader reader = cnn.ExecuteReader(someQueryOrCommand);

}
catch (Exception ex)
{
// do something here
}
finally
{
if (cnn != null && cnn.State == ConnectionState.Open)
cnn.Close();
}

Missing .NET Functionality

2012-02-16T13:00:00.000-06:00

Something I've noticed recently in .NET4 is that certain functionality doesn't seem to be available.

Consider the following line:

string value = ConfigurationSettings.AppSettings["somevalue"];

I get a warning in the compiler "Warning 'System.Configuration.ConfigurationSettings.AppSettings' is obsolete: "This method is obsolete, it has

been replaced by

System.Configuration!System.Configuration.ConfigurationManager.AppSettings"

However, when I type ConfigurationManager, nothing shows up in Intellisense!

The solution to this is to go to "Add reference" and add the reference to "System.Configuration" in your solution.  Now, that functionality is available.

This is also the case for the "HttpWebRequest" object location in System.Web.

I'm not sure why 4.0 requires this whereas it just worked in older versions of .NET but it is what it is.

The Power of (Kindle) Fire

2011-11-18T09:29:00.001-06:00

I may do a video review of the Fire at some point because I'm tired of silly unboxing videos and people fumbling through the Kindle Fire UI making stupid comments. But for now ... here is my article on the Fire as requested by some friends of mine.

First off let's clear some things up. This device has been dubbed an iPad killer. In some ways (which we will discuss) it could be but in other ways its not. The truth is one is chicken and the other is beef. Some people prefer one, some people prefer the other. And hey, some people might prefer pork of seafood. [Man, I'm getting hungry.] No the Fire doesn't have a camera, 3G, microphone, GPS, or a pretentious price tag. It is a $199 device and an iPad is a $600 device. Personally, I think its a smart move too.

Your smart phone will have all the features I mentioned and already has a data plan attached to it. So for someone like me who is a "bang for the buck" individual I don't want to pay for duplicate features and a second data plan. For some people this won't be an issue or concern. Great! That's fine.

So what is the Kindle Fire? Its a device to consume Amazon content (magazines, books, music, movies, tv shows, etc), run apps, and do some web browsing. In that regard (except for using iTunes content) it sounds just like an iPad at 1/3 the cost.

What do I like about the Fire? It is not too bulky so you can use it with one hand. Content can be stored in the Cloud or on the device. Purchasing content is easy and there is good integration between the Amazon site on your PC and the Kindle device. For example, if I purchase content on Amazon it will be available on the Kindle to download or view.

What don't I like about the Fire? The "8GB" storage is actually closer to 6.5 with everything that is pre-loaded. Since you can store content on the Cloud that's not too big of a deal but if you're trying to load up on movies (less of an issue with books or music) then you might not have enough space. Allegedly you can store about 10 movies on the Kindle Fire. The plus side of this is that if you're connected to wireless you can pull content from your private cloud storage or stream movies.

What do I like about the Amazon content? The selection is there. Most new media is available for download. The pricing is slightly better (say $15 for a new popular movie) vs $20 for the physical media. There is also rental options that make content available for $1.99 - $5.99. Most TV shows are about $1.99 for an episode or the season can be purchased.

Music prices seem to be fairly consistent about $0.99 a song but album prices can vary. Obviously book prices vary along with magazine subscriptions.

With Prime you get free streaming of videos and some limited "loaner book" selections. The content isn't necessarily newer stuff but its not all junk. Where it really shines is the amount of kid friendly content (Sesame Street, etc).

What do I dislike about the Amazon content? I'd prefer newer content over quantity of content for the Prime stuff. As far as I know there is no "add-on" to download music for a flat rate like Zune Pass or others. Some of the content (like Amazon's audio books; Audibles) doesn't seem well integrated with Fire yet.

Apps are lacking as well. I can get some of the more popular apps (Angry Birds, Facebook, Pandora, etc) on my device but ones like ESPN Fantasy Football don't appear to exist.

Amazon Prime? For $80/yr which includes free 2-day shipping on Amazon orders I think Prime is one of the better deals going on. That is basically $6.66 (nice) per month and includes not only streaming content but the loaner books (1 per month). So better deal than Netflix, etc.

Is this device good for kids? Yes, if supervised. There is no filtering/parental controls for web browsing or content downloads. And since even free content requires having all your billing stuff setup there isn't much to prevent your child from running up a huge bill on content.

In the first night of using the Fire and trying to get my kid to bed I was able to read her several children's books and stream episodes of Sesame Street. The finale I bought Kung Fu Panda ($6.99) and was able to stream it instantly. I later downloaded it so we can watch it on the go.

Other thoughts? Kindle doesn't have much in the way of inputs. It has a mini stereo jack and a power plug. The included power cable is a wall cable so I'm not sure if you had a USB cable with the correct connector if you could access the Fire or not. (IE as a mounted drive.)

Since you're purchasing digital content (not tied to a device) it seems like you could watch the same content on a computer or connect a computer to your TV and watch it that way. That seems pretty neat to me because now you're not having to re-purchase media.

Again, no SD ports or anything but you can upload content on the Amazon site to their cloud so that is handy. I think you can even upload non-Amazon music content as well.

Web browsing experience is closer to PC than Smart Phones are. Wasn't overly fast but wasn't overly slow either.

Final verdict: Great device if you have modest needs and the price is very reasonable.

The type initializer for ... threw an exception

2011-08-26T16:48:00.000-05:00

I was given some old code that I needed to port/partially rewrite. The code had some funky things like a class trying to reference a static class as its base (which C# doesn't allow). My guess is someone started to rewrite the code before they checked it into source control and never completed it.

Anyhow, I wrote a test app for this code after making a few tweaks and when this particular object was initialized it hit the declaration for the constructor and quit. For some reason, .NET didn't throw any exceptions; it just stopped executing the code.

I wrapped my call with a try catch and caught the following: "The type initializer for 'NameOfClassICalled' threw an exception". [This was a TypeInitializationException.]

After carefully stepping through the code I found my simple yet elusive mistake. The code was initializing the base class which has static methods it was trying to load. These static methods used the ConfigurationManager which uses the App.config... which I failed to include in my project.

Adding my app.config with the proper entries and I was off to the cases. Reminder: The parent assemblies config is the one that is used by assemblies called during execution.