VB.NET to C# Differences

by Fred Mastro 11. March 2010 16:05

Found this great link today by Dr. Frank McCown over at Harding University Computer Science Dept from 2009.

http://www.harding.edu/fmccown/vbnet_csharp_comparison.html

VB.NET

Program Structure

Imports System
Namespace Hello
   Class HelloWorld
      Overloads Shared Sub Main(ByVal args() As String)
         Dim name As String = "VB.NET"
'See if an argument was passed from the command line
          If args.Length = 1 Then name = args(0)
          Console.WriteLine("Hello, " & name & "!")
      End Sub
   End Class
End Namespace

using System;
namespace Hello {
   public class HelloWorld {
      public static void Main(string[] args) {
         string name = "C#";
// See if an argument was passed from the command line
         if (args.Length == 1)
            name = args[0];
         Console.WriteLine("Hello, " + name + "!");
      }
   }
}

VB.NET

Comments

' Single line only
REM Single line only
''' <summary>XML comments</summary>

// Single line
/* Multiple
line */
/// <summary>XML comments on single line</summary>
/** <summary>XML comments on multiple lines</summary> */

VB.NET

Data Types

Value Types
Boolean
Byte, SByte
Char
Short, UShort, Integer, UInteger, Long, ULong
Single, Double
Decimal
Date

Reference Types
Object
String

Initializing
Dim correct As Boolean = True
Dim b As Byte = &H2A 'hex
Dim o As Byte = &O52 'octal
Dim person As Object = Nothing
Dim name As String = "Dwight"
Dim grade As Char = "B"c
Dim today As Date = #12/31/2007 12:15:00 PM#
Dim amount As Decimal = 35.99@
Dim gpa As Single = 2.9!
Dim pi As Double = 3.14159265
Dim lTotal As Long = 123456L
Dim sTotal As Short = 123S
Dim usTotal As UShort = 123US
Dim uiTotal As UInteger = 123UI
Dim ulTotal As ULong = 123UL

Type Information
Dim x As Integer
Console.WriteLine(x.GetType())          ' Prints System.Int32
Console.WriteLine(GetType(Integer))   ' Prints System.Int32
Console.WriteLine(TypeName(x))        ' Prints Integer

Type Conversion
Dim d As Single = 3.5
Dim i As Integer = CType(d, Integer) ' set to 4 (Banker's rounding)
i = CInt(d) ' same result as CType
i = Int(d) ' set to 3 (Int function truncates the decimal)

Value Types
bool
byte, sbyte
char
short, ushort, int, uint, long, ulong
float, double
decimal
DateTime (not a built-in C# type)

Reference Types
object
string

Initializing
bool correct = true;
byte b = 0x2A; // hex
object person = null;
string name = "Dwight";
char grade = 'B';
DateTime today = DateTime.Parse("12/31/2007 12:15:00");
decimal amount = 35.99m;
float gpa = 2.9f;
double pi = 3.14159265;
long lTotal = 123456L;
short sTotal = 123;
ushort usTotal = 123;
uint uiTotal = 123;
ulong ulTotal = 123;

Type Information
int x;
Console.WriteLine(x.GetType());              // Prints System.Int32
Console.WriteLine(typeof(int));               // Prints System.Int32
Console.WriteLine(x.GetType().Name);   // prints Int32

Type Conversion
float d = 3.5f;
int i = (int)d; // set to 3 (truncates decimal)

VB.NET

Constants

Const MAX_STUDENTS As Integer = 25

' Can set to a const or var; may be initialized in a constructor
ReadOnly MIN_DIAMETER As Single = 4.93

const int MAX_STUDENTS = 25;

// Can set to a const or var; may be initialized in a constructor
readonly float MIN_DIAMETER = 4.93f;

VB.NET

Enumerations

Enum Action
Start
[Stop]   ' Stop is a reserved word
Rewind
Forward
End Enum
Enum Status
Flunk = 50
Pass = 70
Excel = 90
End Enum

Dim a As Action = Action.Stop
If a <> Action.Start Then _
   Console.WriteLine(a.ToString & " is " & a)     ' Prints "Stop is 1"
Console.WriteLine(Status.Pass)     ' Prints 70
Console.WriteLine(Status.Pass.ToString())     ' Prints Pass

enum Action {Start, Stop, Rewind, Forward};
enum Status {Flunk = 50, Pass = 70, Excel = 90};
Action a = Action.Stop;
if (a != Action.Start)
Console.WriteLine(a + " is " + (int) a);    // Prints "Stop is 1"
Console.WriteLine((int) Status.Pass);    // Prints 70
Console.WriteLine(Status.Pass);      // Prints Pass

VB.NET

Operators

Comparison
= < > <= >= <>

Arithmetic
+ - * /
Mod
\ (integer division)
^ (raise to a power)

Assignment
= += -= *= /= \= ^= <<= >>= &=

Bitwise
And Or Xor Not << >>

Logical
AndAlso OrElse And Or Xor Not

Note: AndAlso and OrElse perform short-circuit logical evaluations

String Concatenation
&

Comparison
== < > <= >= !=

Arithmetic
+ - * /
% (mod)
/ (integer division if both operands are ints)
Math.Pow(x, y)

Assignment
= += -= *= /= %= &= |= ^= <<= >>= ++ --

Bitwise
& | ^ ~ << >>

Logical
&& || & | ^ !

Note: && and || perform short-circuit logical evaluations

String Concatenation
+

VB.NET

Choices

' Ternary/Conditional operator (Iff evaluates 2nd and 3rd expressions)
greeting = If(age < 20, "What's up?", "Hello")

' One line doesn't require "End If"
If age < 20 Then greeting = "What's up?"
If age < 20 Then greeting = "What's up?" Else greeting = "Hello"

' Use : to put two commands on same line
If x <> 100 AndAlso y < 5 Then x *= 5 : y *= 2

' Preferred
If x <> 100 AndAlso y < 5 Then
x *= 5
y *= 2
End If

' To break up any long single line use _
If whenYouHaveAReally < longLine And _
itNeedsToBeBrokenInto2 > Lines Then _
UseTheUnderscore(charToBreakItUp)

'If x > 5 Then
x *= y
ElseIf x = 5 OrElse y Mod 2 = 0 Then
x += y
ElseIf x < 10 Then
x -= y
Else
x /= y
End If

Select Case color   ' Must be a primitive data type
Case "pink", "red"
    r += 1
Case "blue"
    b += 1
Case "green"
    g += 1
Case Else
    other += 1
End Select

// Ternary/Conditional operator
greeting = age < 20 ? "What's up?" : "Hello";

if (age < 20)
greeting = "What's up?";
else
greeting = "Hello";

// Multiple statements must be enclosed in {}
if (x != 100 && y < 5) {
x *= 5;
y *= 2;
}

No need for _ or : since ; is used to terminate each statement.

if (x > 5)
x *= y;
else if (x == 5 || y % 2 == 0)
x += y;
else if (x < 10)
x -= y;
else
x /= y;

// Every case must end with break or goto case
switch (color) {                          // Must be integer or string
case "pink":
case "red":    r++;    break;
case "blue":   b++;   break;
case "green": g++;   break;
default:    other++; break; // break necessary on default
}

VB.NET

Loops

Pre-test Loops:
While c < 10 c += 1 End While	Do Until c = 10 c += 1 Loop
Do While c < 10 c += 1 Loop	For c = 2 To 10 Step 2 Console.WriteLine(c) Next
Post-test Loops:
Do c += 1 Loop While c < 10	Do c += 1 Loop Until c = 10

' Array or collection looping
Dim names As String() = {"Fred", "Sue", "Barney"}
For Each s As String In names
Console.WriteLine(s)
Next

' Breaking out of loops
Dim i As Integer = 0
While (True)
If (i = 5) Then Exit While
i += 1
End While

' Continue to next iteration
For i = 0 To 4
If i < 4 Then Continue For
Console.WriteLine(i) ' Only prints 4
Next

Pre-test Loops:

// no "until" keyword
while (c < 10)
c++;
for (c = 2; c <= 10; c += 2)
Console.WriteLine(c);

Post-test Loop:
do
c++;
while (c < 10);

// Array or collection looping
string[] names = {"Fred", "Sue", "Barney"};
foreach (string s in names)
Console.WriteLine(s);

// Breaking out of loops
int i = 0;
while (true) {
if (i == 5)
break;
i++;
}

// Continue to next iteration
for (i = 0; i < 5; i++) {
if (i < 4)
continue;
Console.WriteLine(i); // Only prints 4
}

VB.NET

Arrays

Dim nums() As Integer = {1, 2, 3}
For i As Integer = 0 To nums.Length - 1
Console.WriteLine(nums(i))
Next
' 4 is the index of the last element, so it holds 5 elements
Dim names(4) As String
names(0) = "David"
names(5) = "Bobby" ' Throws System.IndexOutOfRangeException
' Resize the array, keeping the existing values (Preserve is optional)
ReDim Preserve names(6)

Dim twoD(rows-1, cols-1) As Single
twoD(2, 0) = 4.5
Dim jagged()() As Integer = { _
New Integer(4) {}, New Integer(1) {}, New Integer(2) {} }
jagged(0)(4) = 5

int[] nums = {1, 2, 3};
for (int i = 0; i < nums.Length; i++)
Console.WriteLine(nums[i]);
// 5 is the size of the array
string[] names = new string[5];
names[0] = "David";
names[5] = "Bobby"; // Throws System.IndexOutOfRangeException
// C# can't dynamically resize an array. Just copy into new array.
string[] names2 = new string[7];
Array.Copy(names, names2, names.Length); // or names.CopyTo(names2, 0);

float[,] twoD = new float[rows, cols];
twoD[2,0] = 4.5f;

int[][] jagged = new int[3][] {
new int[5], new int[2], new int[3] };
jagged[0][4] = 5;

VB.NET

Functions

' Pass by value (in, default), reference (in/out), and reference (out)
Sub TestFunc(ByVal x As Integer, ByRef y As Integer, ByRefz As Integer)
x += 1
y += 1
z = 5
End Sub

Dim a = 1, b = 1, c As Integer ' c set to zero by default
TestFunc(a, b, c)
Console.WriteLine("{0} {1} {2}", a, b, c) ' 1 2 5

' Accept variable number of arguments
Function Sum(ByVal ParamArray nums As Integer()) As Integer
Sum = 0
For Each i As Integer In nums
Sum += i
Next
End Function ' Or use Return statement like C#
Dim total As Integer = Sum(4, 3, 2, 1) ' returns 10

' Optional parameters must be listed last and must have a default value
Sub SayHello(ByVal name As String, Optional ByVal prefix As String = "")
Console.WriteLine("Greetings, " & prefix & " " & name)
End Sub
SayHello("Strangelove", "Dr.")
SayHello("Madonna")

// Pass by value (in, default), reference (in/out), and reference (out)
void TestFunc(int x, ref int y, out int z) {
x++;
y++;
z = 5;
}

int a = 1, b = 1, c; // c doesn't need initializing
TestFunc(a, ref b, out c);
Console.WriteLine("{0} {1} {2}", a, b, c); // 1 2 5

// Accept variable number of arguments
int Sum(params int[] nums) {
int sum = 0;
foreach (int i in nums)
sum += i;
return sum;
}

int total = Sum(4, 3, 2, 1); // returns 10

/* C# doesn't support optional arguments/parameters. Just create two different versions of the same function. */
void SayHello(string name, string prefix) {
Console.WriteLine("Greetings, " + prefix + " " + name);
}
void SayHello(string name) {
SayHello(name, "");
}

VB.NET

Strings

Special character constants (all also accessible from ControlChars class)
vbCrLf, vbCr, vbLf, vbNewLine
vbNullString
vbTab
vbBack
vbFormFeed
vbVerticalTab
""

' String concatenation (use & or +)
Dim school As String = "Harding" & vbTab
school = school & "University" ' school is "Harding (tab) University"

' Chars
Dim letter As Char = school.Chars(0)   ' letter is H
letter = Convert.ToChar(65)                ' letter is A
letter = Chr(65)                                 ' same thing
Dim word() As Char = school.ToCharArray() ' word holds Harding

' No string literal operator
Dim msg As String = "File is c:\temp\x.dat"

' String comparison
Dim mascot As String = "Bisons"
If (mascot = "Bisons") Then   ' true
If (mascot.Equals("Bisons")) Then   ' true
If (mascot.ToUpper().Equals("BISONS")) Then ' true
If (mascot.CompareTo("Bisons") = 0) Then   ' true

' String matching with Like - Regex is more powerful
If ("John 3:16" Like "Jo[Hh]? #:*") Then 'true

' Substring
s = mascot.Substring(2, 3)) ' s is "son"

' Replacement
s = mascot.Replace("sons", "nomial")) ' s is "Binomial"

' Split
Dim names As String = "Frank,Becky,Ethan,Braden"
Dim parts() As String = names.Split(",".ToCharArray()) ' One name in each slot

' Date to string
Dim dt As New DateTime(1973, 10, 12)
Dim s As String = "My birthday: " & dt.ToString("MMM dd, yyyy") ' Oct 12, 1973

' Integer to String
Dim x As Integer = 2
Dim y As String = x.ToString() ' y is "2"

' String to Integer
Dim x As Integer = Convert.ToInt32("-5") ' x is -5

' Mutable string
Dim buffer As New System.Text.StringBuilder("two ")
buffer.Append("three ")
buffer.Insert(0, "one ")
buffer.Replace("two", "TWO")
Console.WriteLine(buffer) ' Prints "one TWO three"

Escape sequences
\r    // carriage-return
\n    // line-feed
\t    // tab
\\    // backslash
\"    // quote

// String concatenation
string school = "Harding\t";
school = school + "University"; // school is "Harding (tab) University"

// Chars
char letter = school[0];            // letter is H
letter = Convert.ToChar(65);     // letter is A
letter = (char)65;                    // same thing
char[] word = school.ToCharArray();   // word holds Harding

// String literal
string msg = @"File is c:\temp\x.dat";
// same as
string msg = "File is c:\\temp\\x.dat";

// String comparison
string mascot = "Bisons";
if (mascot == "Bisons")    // true
if (mascot.Equals("Bisons"))   // true
if (mascot.ToUpper().Equals("BISONS"))   // true
if (mascot.CompareTo("Bisons") == 0)    // true

// String matching - No Like equivalent, use Regex

// Substring
s = mascot.Substring(2, 3)) // s is "son"

// Replacement
s = mascot.Replace("sons", "nomial")) // s is "Binomial"

// Split
string names = "Frank,Becky,Ethan,Braden";
string[] parts = names.Split(",".ToCharArray()); // One name in each slot

// Date to string
DateTime dt = new DateTime(1973, 10, 12);
string s = dt.ToString("MMM dd, yyyy"); // Oct 12, 1973

// int to string
int x = 2;
string y = x.ToString(); // y is "2"

// string to int
int x = Convert.ToInt32("-5"); // x is -5

// Mutable string
System.Text.StringBuilder buffer = new System.Text.StringBuilder("two ");
buffer.Append("three ");
buffer.Insert(0, "one ");
buffer.Replace("two", "TWO");
Console.WriteLine(buffer); // Prints "one TWO three"

VB.NET

Regular Expressions

Imports System.Text.RegularExpressions

' Match a string pattern
Dim r As New Regex("j[aeiou]h?. \d:*", RegexOptions.IgnoreCase Or _
        RegexOptions.Compiled)
If (r.Match("John 3:16").Success) Then   'true
    Console.WriteLine("Match")
End If

' Find and remember all matching patterns
Dim s As String = "My number is 305-1881, not 305-1818."
Dim r As New Regex("(\d+-\d+)")
Dim m As Match = r.Match(s)     ' Matches 305-1881 and 305-1818
While m.Success
    Console.WriteLine("Found number: " & m.Groups(1).Value & " at position " _
            & m.Groups(1).Index.ToString)
    m = m.NextMatch()
End While

' Remeber multiple parts of matched pattern
Dim r As New Regex("(\d\d):(\d\d) (am|pm)")
Dim m As Match = r.Match("We left at 03:15 pm.")
If m.Success Then
    Console.WriteLine("Hour: " & m.Groups(1).ToString)       ' 03
    Console.WriteLine("Min: " & m.Groups(2).ToString)         ' 15
    Console.WriteLine("Ending: " & m.Groups(3).ToString)   ' pm
End If

' Replace all occurrances of a pattern
Dim r As New Regex("h\w+?d", RegexOptions.IgnoreCase)
Dim s As String = r.Replace("I heard this was HARD!", "easy") ' I easy this was easy!

' Replace matched patterns
Dim s As String = Regex.Replace("123 < 456", "(\d+) . (\d+)", "$2 > $1") ' 456 > 123

' Split a string based on a pattern
Dim names As String = "Frank, Becky, Ethan, Braden"
Dim r As New Regex(",\s*")
Dim parts() As String = r.Split(names) ' One name in each slot

using System.Text.RegularExpressions;

// Match a string pattern
Regex r = new Regex(@"j[aeiou]h?. \d:*", RegexOptions.IgnoreCase |
        RegexOptions.Compiled);
if (r.Match("John 3:16").Success)   // true
    Console.WriteLine("Match");

// Find and remember all matching patterns
string s = "My number is 305-1881, not 305-1818.";
Regex r = new Regex("(\\d+-\\d+)");
// Matches 305-1881 and 305-1818
for (Match m = r.Match(s); m.Success; m = m.NextMatch())
Console.WriteLine("Found number: " + m.Groups[1] + " at position " +
m.Groups[1].Index);

// Remeber multiple parts of matched pattern
Regex r = new Regex("@(\d\d):(\d\d) (am|pm)");
Match m = r.Match("We left at 03:15 pm.");
if (m.Success) {
    Console.WriteLine("Hour: " + m.Groups[1]);       // 03
    Console.WriteLine("Min: " + m.Groups[2]);         // 15
    Console.WriteLine("Ending: " + m.Groups[3]);   // pm
}

// Replace all occurrances of a pattern
Regex r = new Regex("h\\w+?d", RegexOptions.IgnoreCase);
string s = r.Replace("I heard this was HARD!", "easy")); // I easy this was easy!

// Replace matched patterns
string s = Regex.Replace("123 < 456", @"(\d+) . (\d+)", "$2 > $1"); // 456 > 123

// Split a string based on a pattern
string names = "Frank, Becky, Ethan, Braden";
Regex r = new Regex(@",\s*");
string[] parts = r.Split(names); // One name in each slot

VB.NET

Exception Handling

' Throw an exception
Dim ex As New Exception("Something is really wrong.")
Throw ex

' Catch an exception
Try
y = 0
x = 10 / y
Catch ex As Exception When y = 0 ' Argument and When is optional
Console.WriteLine(ex.Message)
Finally
Beep()
End Try

' Deprecated unstructured error handling
On Error GoTo MyErrorHandler
...
MyErrorHandler: Console.WriteLine(Err.Description)

// Throw an exception
Exception up = new Exception("Something is really wrong.");
throw up; // ha ha

// Catch an exception
try {
y = 0;
x = 10 / y;
}
catch (Exception ex) { // Argument is optional, no "When" keyword
Console.WriteLine(ex.Message);
}
finally {
Microsoft.VisualBasic.Interaction.Beep();
}

VB.NET

Namespaces

Namespace Harding.Compsci.Graphics
...
End Namespace

' or

Namespace Harding
Namespace Compsci
Namespace Graphics
...
End Namespace
End Namespace
End Namespace

Imports Harding.Compsci.Graphics

namespace Harding.Compsci.Graphics {
...
}

// or

namespace Harding {
namespace Compsci {
namespace Graphics {
...
}
}
}

using Harding.Compsci.Graphics;

VB.NET

Classes / Interfaces

Accessibility keywords
Public
Private
Friend
Protected
Protected Friend
Shared

' Inheritance
Class FootballGame
Inherits Competition
...
End Class

' Interface definition
Interface IAlarmClock
...
End Interface

// Extending an interface
Interface IAlarmClock
Inherits IClock
...
End Interface

// Interface implementation
Class WristWatch
Implements IAlarmClock, ITimer
...
End Class

Accessibility keywords
public
private
internal
protected
protected internal
static

// Inheritance
class FootballGame : Competition {
...
}

// Interface definition
interface IAlarmClock {
...
}

// Extending an interface
interface IAlarmClock : IClock {
...
}

// Interface implementation
class WristWatch : IAlarmClock, ITimer {
...
}

VB.NET

Constructors / Destructors

Class SuperHero
Private _powerLevel As Integer
Public Sub New()
    _powerLevel = 0
End Sub
Public Sub New(ByVal powerLevel As Integer)
    Me._powerLevel = powerLevel
End Sub
Protected Overrides Sub Finalize()
' Desctructor code to free unmanaged resources
    MyBase.Finalize()
End Sub
End Class

class SuperHero {
private int _powerLevel;
public SuperHero() {
     _powerLevel = 0;
}
public SuperHero(int powerLevel) {
    this._powerLevel= powerLevel;
}
~SuperHero() {
// Destructor code to free unmanaged resources.
    // Implicitly creates a Finalize method
}
}

VB.NET

Using Objects

Dim hero As SuperHero = New SuperHero
' or
Dim hero As New SuperHero

With hero
.Name = "SpamMan"
.PowerLevel = 3
End With

hero.Defend("Laura Jones")
hero.Rest() ' Calling Shared method
' or
SuperHero.Rest()

Dim hero2 As SuperHero = hero ' Both reference the same object
hero2.Name = "WormWoman"
Console.WriteLine(hero.Name) ' Prints WormWoman

hero = Nothing ' Free the object

If hero Is Nothing Then _
hero = New SuperHero

Dim obj As Object = New SuperHero
If TypeOf obj Is SuperHero Then _
Console.WriteLine("Is a SuperHero object.")

' Mark object for quick disposal
Using reader As StreamReader = File.OpenText("test.txt")
Dim line As String = reader.ReadLine()
While Not line Is Nothing
Console.WriteLine(line)
line = reader.ReadLine()
End While
End Using

SuperHero hero = new SuperHero();

// No "With" construct
hero.Name = "SpamMan";
hero.PowerLevel = 3;

hero.Defend("Laura Jones");
SuperHero.Rest(); // Calling static method

SuperHero hero2 = hero; // Both reference the same object
hero2.Name = "WormWoman";
Console.WriteLine(hero.Name); // Prints WormWoman

hero = null ; // Free the object

if (hero == null)
hero = new SuperHero();

Object obj = new SuperHero();
if (obj is SuperHero)
Console.WriteLine("Is a SuperHero object.");

// Mark object for quick disposal
using (StreamReader reader = File.OpenText("test.txt")) {
string line;
while ((line = reader.ReadLine()) != null)
Console.WriteLine(line);
}

VB.NET

Structs

Structure StudentRecord
Public name As String
Public gpa As Single
Public Sub New(ByVal name As String, ByVal gpa As Single)
Me.name = name
Me.gpa = gpa
End Sub
End Structure

Dim stu As StudentRecord = New StudentRecord("Bob", 3.5)
Dim stu2 As StudentRecord = stu
stu2.name = "Sue"
Console.WriteLine(stu.name) ' Prints Bob
Console.WriteLine(stu2.name) ' Prints Sue

struct StudentRecord {
public string name;
public float gpa;
public StudentRecord(string name, float gpa) {
this.name = name;
this.gpa = gpa;
}
}

StudentRecord stu = new StudentRecord("Bob", 3.5f);
StudentRecord stu2 = stu;
stu2.name = "Sue";
Console.WriteLine(stu.name);    // Prints Bob
Console.WriteLine(stu2.name);   // Prints Sue

VB.NET

Properties

Private _size As Integer
Public Property Size() As Integer
Get
    Return _size
End Get
Set (ByVal Value As Integer)
    If Value < 0 Then
      _size = 0
    Else
      _size = Value
    End If
End Set
End Property

foo.Size += 1

private int _size;
public int Size {
get {
    return _size;
}
set {
    if (value < 0)
      _size = 0;
    else
      _size = value;
}
}

foo.Size++;

VB.NET

Delegates / Events

Delegate Sub MsgArrivedEventHandler(ByVal message As String)

Event MsgArrivedEvent As MsgArrivedEventHandler

' or to define an event which declares a delegate implicitly
Event MsgArrivedEvent(ByVal message As String)

AddHandler MsgArrivedEvent, AddressOfMy_MsgArrivedCallback
' Won't throw an exception if obj is Nothing
RaiseEvent MsgArrivedEvent("Test message")
RemoveHandler MsgArrivedEvent, AddressOfMy_MsgArrivedCallback

Imports System.Windows.Forms

Dim WithEvents MyButton As Button ' WithEvents can't be used on local variable
MyButton = New Button

Private Sub MyButton_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles MyButton.Click
MessageBox.Show(Me, "Button was clicked", "Info", _
MessageBoxButtons.OK, MessageBoxIcon.Information)
End Sub

delegate void MsgArrivedEventHandler(string message);

event MsgArrivedEventHandler MsgArrivedEvent;

// Delegates must be used with events in C#
MsgArrivedEvent += new MsgArrivedEventHandler(My_MsgArrivedEventCallback);
MsgArrivedEvent("Test message"); // Throws exception if obj is null
MsgArrivedEvent -= new MsgArrivedEventHandler(My_MsgArrivedEventCallback);

using System.Windows.Forms;

Button MyButton = new Button();
MyButton.Click += new System.EventHandler(MyButton_Click);

private void MyButton_Click(object sender, System.EventArgs e) {
MessageBox.Show(this, "Button was clicked", "Info",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}

VB.NET

Console I/O

Console.Write("What's your name? ")
Dim name As String = Console.ReadLine()
Console.Write("How old are you? ")
Dim age As Integer = Val(Console.ReadLine())
Console.WriteLine("{0} is {1} years old.", name, age)
' or
Console.WriteLine(name & " is " & age & " years old.")
Dim c As Integer
c = Console.Read() ' Read single char
Console.WriteLine(c) ' Prints 65 if user enters "A"

Console.Write("What's your name? ");
string name = Console.ReadLine();
Console.Write("How old are you? ");
int age = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("{0} is {1} years old.", name, age);
// or
Console.WriteLine(name + " is " + age + " years old.");

int c = Console.Read(); // Read single char
Console.WriteLine(c); // Prints 65 if user enters "A"

VB.NET

File I/O

Imports System.IO

' Write out to text file
Dim writer As StreamWriter = File.CreateText("c:\myfile.txt")
writer.WriteLine("Out to file.")
writer.Close()

' Read all lines from text file
Dim reader As StreamReader = File.OpenText("c:\myfile.txt")
Dim line As String = reader.ReadLine()
While Not line Is Nothing
Console.WriteLine(line)
line = reader.ReadLine()
End While
reader.Close()

' Write out to binary file
Dim str As String = "Text data"
Dim num As Integer = 123
Dim binWriter As NewBinaryWriter(File.OpenWrite("c:\myfile.dat"))
binWriter.Write(str)
binWriter.Write(num)
binWriter.Close()

' Read from binary file
Dim binReader As NewBinaryReader(File.OpenRead("c:\myfile.dat"))
str = binReader.ReadString()
num = binReader.ReadInt32()
binReader.Close()

using System.IO;

// Write out to text file
StreamWriter writer = File.CreateText("c:\\myfile.txt");
writer.WriteLine("Out to file.");
writer.Close();

// Read all lines from text file
StreamReader reader = File.OpenText("c:\\myfile.txt");
string line = reader.ReadLine();
while (line != null) {
Console.WriteLine(line);
line = reader.ReadLine();
}
reader.Close();

// Write out to binary file
string str = "Text data";
int num = 123;
BinaryWriter binWriter = new BinaryWriter(File.OpenWrite("c:\\myfile.dat"));
binWriter.Write(str);
binWriter.Write(num);
binWriter.Close();

// Read from binary file
BinaryReader binReader = new BinaryReader(File.OpenRead("c:\\myfile.dat"));
str = binReader.ReadString();
num = binReader.ReadInt32();
binReader.Close();

db43471b-f17d-4288-940a-179906f71966|0|.0

Tags: vb.net, programming, c#

Microsoft Certification Step-By-Step Road Map for .NET Development, SQL 2008 Server, Team Foundation and Sharepoint

by Fred Mastro 6. January 2010 22:13

I’ve put together, from the Microsoft Site a Step-By-Step plan for getting certifications by Microsoft in the areas of .Net 3.5 Development, Team Foundation Server, Sharepoint and SQL 2008.

I’ve listed in order that you need to study and take exams that makes the most sense. The links go back to the Microsoft site Training/Certification pages. This list is to make it easy. Just follow it down and you study the book or e-learning class, then you take the listed exam and you get the listed certification.

Step Order	Study Press Book or E-Learning	Take This Exam	Get This Certification
	.NET 3.5 Development Track (See Notes for 2.0 Track)
1	Microsoft Press Book · MCTS Self-Paced Training Kit (Exam 70-536): Microsoft .NET Framework--Application Development Foundation, Second Edition Microsoft E-Learning · 5161AE: Advanced development with the Microsoft .NET Framework 2.0 Foundation (16 Hours) · 5160AE: Core development with the Microsoft .NET Framework 2.0 Foundation (14 Hours)	Exam 70-536
2	Microsoft Press Book · MCTS Self-Paced Training Kit (Exam 70-562): Microsoft .NET Framework 3.5 - ASP.NET Microsoft E-Learning · 6463AE: Visual Studio 2008: ASP.NET 3.5 (20 Hours)	Exam 70-562	MCTS: .NET Framework 3.5, ASP.NET Applications
3	Classroom Training · 01: Learning Plan for Designing and Developing ASP.NET Applications Using the Microsoft .NET Framework 3.5 (Exam 70-564) (1 Forms)	Exam 70-564	MCPD: ASP.NET Developer 3.5 on Visual Studio 2008
Note: 2.0 Track	Since the previous exam has no book at this time, you can also take the .NET 2.0 Track Instead take Exam, Exam 70-528 and Exam 70-547 instead for 2.0 Certification.		MCTS: .NET Framework 2.0, ASP.NET Applications AND MCPD: Web Developer on Visual Studio 2005
4	Microsoft Press Book · MCTS Self-Paced Training Kit (Exam 70-505): Microsoft .NET Framework 3.5 -- Windows Forms Application Development · MCTS Self-Paced Training Kit (Exam 70-526): Microsoft .NET Framework 2.0 Windows-Based Client Development Microsoft E-Learning · 2546AE: Core Windows Client Development with Microsoft Visual Studio 2005 (18 Hours) · 2542AE: Advanced Data Access with Microsoft Visual Studio 2005 (12 Hours) · 2547AE: Advanced Windows Client Programming with Microsoft Visual Studio 2005 (12 Hours) · 2541AE: Core Data Access with Microsoft Visual Studio 2005 (16 Hours)	Exam 70-505
5	Classroom Training · 001: Learning Plan for Designing and Developing Windows Applications Using the Microsoft .NET Framework 3.5 (Exam 70-563) (1 Forms)	Exam 70-563	MCPD: Windows Developer 3.5 on Visual Studio 2008
Note: 2.0 Track	Since the previous exam has no book at this time, you can also take the .NET 2.0 Track Instead take Exam, Exam 70-526 and Exam 70-548 instead for 2.0 Certification.		MCPD: Windows Developer on Visual Studio 2005
6	Microsoft Press Book · MCTS Self-Paced Training Kit (Exam 70-561): Microsoft .NET Framework 3.5 - ADO.NET Microsoft E-Learning · 6464AE: Visual Studio 2008: ADO.NET 3.5 (20 Hours)	Exam 70-561
7	Microsoft Press Book · MCTS Self-Paced Training Kit (Exam 70-503): Microsoft .NET Framework 3.0—Windows Communication Foundation Microsoft E-Learning · 6461AE: Visual Studio 2008: Windows Communication Foundation (20 Hours)	Exam 70-503
8	Classroom Training · 01: Learning Plan for Designing and Developing Enterprise Applications Using the Microsoft .NET Framework 3.5 (Exam 70-565) (1 Forms)	Exam 70-565	MCPD: Enterprise Application Developer 3.5 on Visual Studio 2008
Note: 2.0 Track	Since the previous exam has no book at this time, you can also take the .NET 2.0 Track Instead take Exam ,Exam 70-529 and Exam 70-549 instead for 2.0 Certification.		MCPD: Enterprise Application Developer on Visual Studio 2005
	SharePoint Certifications
9	Microsoft Press Books · The Microsoft SharePoint Step by Step Kit: Microsoft Windows SharePoint Services 3.0 Step by Step and Microsoft Office SharePoint Designer 2007 Microsoft E-Learning · 5403AE: MCTS (Exam 70-631): Microsoft Windows SharePoint Services 3.0, Configuring (12 Hours)	Exam 70-631	MCTS: Microsoft Windows SharePoint Services 3.0 – Configuration
10	Microsoft Press Books Inside Microsoft Office SharePoint Server 2007 Microsoft E-Learning · 5404AE: MCTS (Exam 70-630): Microsoft Office SharePoint Server 2007, Configuring (12 Hours) · 3376AE: Implementing Enterprise Search Using Sharepoint Technologies (8 Hours)	Exam 70-630	MCTS: Microsoft Office SharePoint Server 2007 – Configuration
11	Microsoft E-Learning · 5392AE: Developing and Extending Microsoft Windows SharePoint Services 3.0 with Visual Studio 2005 (12 Hours) · 5385AE: Developing Solutions with Microsoft Windows SharePoint Services 3.0 and Visual Studio 2005 (12 Hours)	Exam 70-541	MCTS: Microsoft Windows SharePoint Services 3.0 – Application Development
12	Microsoft E-Learning · 6071AE: Developing Solutions with Microsoft Office SharePoint Server 2007 and Visual Studio 2005 (12 Hours)	Exam 70-542	MCTS: Microsoft Office SharePoint Server 2007 – Application Development
	Team Foundation Server Certification
13	Classroom Training · 6215A: Implementing and Administering Microsoft Visual Studio 2008 Team Foundation Server (2 Days)	Exam 70-510	MCTS: Microsoft Team Foundation Server: Configuration and Development
	SQL 2008 Certifications
14	Microsoft E-Learning · 6369AE: Implementing and Maintaining Microsoft SQL Server 2008 (16 Hours) · 2778CE: MCTS (Exam 70-433): TS: Microsoft SQL Server 2008, Database Development (18 Hours) Microsoft Press Books · MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance	Exam 70-432	MCTS: SQL Server 2008, Implementation and Maintenance
15	Classroom Training · 01: Learning Plan for Designing, Optimizing and Maintaining a Database Server Infrastructure using SQL Server 2008 (Exam 70-450) (1 Forms)	Exam 70-450	MCITP: Database Administrator 2008
16	Microsoft E-Learning · 2778CE: MCTS (Exam 70-433): TS: Microsoft SQL Server 2008, Database Development (18 Hours) Microsoft Press Books · MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 - Database Development	Exam 70-433	MCTS: SQL Server 2008, Database Development
17	Classroom Training · 01: Learning Plan for Designing Database Solutions and Data Access using SQL Server 2008 (Exam 70-451) (1 Forms)	Exam 70-451	MCITP: Database Developer 2008
18	Microsoft Press Books · MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 - Business Intelligence Development and Maintenance	Exam 70-448	MCTS: SQL Server 2008, Business Intelligence Development and Maintenance
19	Microsoft Press Books · Microsoft SQL Server 2008 Reporting Services Step by Step · Microsoft SQL Server 2008 MDX Step by Step	Exam 70-452	MCITP: Business Intelligence Developer 2008

012ecdaf-9683-47b4-9492-b20cd05b3415|0|.0

Tags: microsoft certifications, education

Sending Generic.List collection back to WCF ObservableCollection

by Fred Mastro 16. December 2009 10:12

Found a good article and helped with a problem I was having, trying to send a list of collection back to a WCF service that was set to accept Observable Collections.

Source: http://smehrozalam.wordpress.com/2009/01/18/ienumerabletoobservablecollection/

In WPF/Silverlight, binding UI objects such as DataGrid or ListBox to collections is typically done using an ObservableCollectioninstead of the generic List object. This way, our UI is automatically synchronized since the observable collection provides event notification to WPF data binding engine whenever items are added, removed, or when the whole list is refreshed. The LINQ extension methods that return a collection actually return IEnumerable<T>. The .NET framework for Silverlight provides built-in extension methods to convert IEnumerable<T> to List<T> and Array<T> but there’s no method available to convert the collection to ObservableCollection<T>(WPF developers can simply use this constructor overload) . So here’s one you may find useful:

 Public Static Class CollectionExtensions
{
    public static ObservableCollection<T> ToObservableCollection<T>(this IEnumerable<T> enumerableList)
    {
        if (enumerableList != null)
        {
            //create an emtpy observable collection object
            var observableCollection = new ObservableCollection<T>();
 
            //loop through all the records and add to observable collection object
            foreach (var item in enumerableList)
                observableCollection.Add(item);
 
            //return the populated observable collection
            return observableCollection;
        }
        return null;
    }
}
 

Extension methods are very powerful and I am planning to post an example demonstrating their potential.

I’ve converted the above example to VB.Net version for you to copy.

Public Shared Function ToObservableCollection(Of T)(ByVal enumerableList As IEnumerable(Of T)) As ObservableCollection(Of T)
     If enumerableList IsNot Nothing Then
         'create an emtpy observable collection object
         Dim observableCollection As New ObservableCollection(Of T)()
 
         'loop through all the records and add to observable collection object
         For Each item As T In enumerableList
             observableCollection.Add(item)
         Next
 
         'return the populated observable collection
         Return observableCollection
     End If
     Return Nothing
 End Function

Now you can call your List and send it back as a ObservableCollection

0e7ac644-8708-410d-892f-666c2a3c8fa7|0|.0

Tags: programming, vb.net, code snippets, wcf, silverlight

.Net Resetting Scroll Position When MaintainScrollPositionOnPostBack = True

by Fred Mastro 10. December 2009 14:52

Had a friend have an issue where he had select buttons on a gridview and on selected changed event he would update control at the top of his page. However, he had MaintainScrollPositionOnPostBack set to True, so of course the browser would reload and scroll down to where he had clicked the Select button.

Found this article how to override the MaintainScrollPosition so it would go to the top of the page. Works like a charm.

http://www.4guysfromrolla.com/articles/111407-1.aspx

On postback, the ASP.NET page adds a call to the client-side function WebForm_RestoreScrollPosition(), which returns the browser's scroll position to the X and Y coordinates specified by the __SCROLLPOSITIONX and __SCROLLPOSITIONY form fields (which were assigned the browser's scroll position before the postback ensued). Consequently, the browser's scroll position is maintained across postbacks. The diagram below illustrates this interaction graphically.

In order to reset the scroll position, we need to add the above JavaScript to the rendered page's output and then call it before the call to WebForm_RestoreScrollPosition(). The following code adds a function (ResetScrollPosition) to the outputted markup and then injects a line of script that invokes this function. The server-side code uses the RegisterClientScriptBlock method to register the ResetScrollPosition function, which adds the function to the top of the form. As noted earlier, RegisterStartupScript adds a call to ResetScrollPosition at the bottom of the page.

Private Sub ResetScrollPosition()
    If Not ClientScript.IsClientScriptBlockRegistered(Me.GetType(), "CreateResetScrollPosition") Then
       'Create the ResetScrollPosition() function
       ClientScript.RegisterClientScriptBlock(Me.GetType(), "CreateResetScrollPosition", _
                        "function ResetScrollPosition() {" & vbCrLf & _
                        " var scrollX = document.getElementById('__SCROLLPOSITIONX');" & vbCrLf & _
                        " var scrollY = document.getElementById('__SCROLLPOSITIONY');" & vbCrLf & _
                        " if (scrollX && scrollY) {" & vbCrLf & _
                        "    scrollX.value = 0;" & vbCrLf & _
                        "    scrollY.value = 0;" & vbCrLf & _
                        " }" & vbCrLf & _
                        "}", True)
       'Add the call to the ResetScrollPosition() function
       ClientScript.RegisterStartupScript(Me.GetType(), "CallResetScrollPosition", "ResetScrollPosition();", True)
    End If
End Sub

To reset scroll position on postback, simply call the server-side ResetScrollPosition() method from the appropriate event handler (be it the Click event handler of a Button, the PageIndexChanged event of the GridView, or some other event).

Rest of Article

a972f453-8110-4fae-856a-8dee6e60b37b|0|.0

Tags: asp.net, maintainscrollpositiononpostback, javascript, top of page

ASP.NET | Programming | Code Snippets

Mapping a DataTable to an Object Class. Like a homemade Linq to SQL. Send over WCF to SilverLight

by Fred Mastro 8. December 2009 17:37

Application Foundation

An application I work has architecture in a way where we have a Class object that represents each table. So for example we might have a “Customer” table in the database. So our class would be something like..

Customer.vb class file…

Public Class Customer
 
     Private _FirstName As String = String.Empty
     Public Property FirstName() As String
         Get
             Return _FirstName
         End Get
         Set(ByVal value As String)
             _FirstName = value
         End Set
     End Property
 
     Private _LastName As String = String.Empty
     Public Property LastName() As String
         Get
             Return _LastName
         End Get
         Set(ByVal value As String)
             _LastName = value
         End Set
     End Property
 
 End Class

In this class is a function to say list all customers, we call this “GetList” method. You might use another way to bring back a list of data. Ideally now we’d want to bring back Enumerable Lists, but the app was already structured for DataSets and DataTables. So I was trying to reuse what we had.

Customer.vb class file

Public Function GetList() As Data.DataTable
     Dim oDS As Data.DataSet
     Try
         oDS = DataAccess.SqlHelper.ExecuteDataset(_ConnectionString, Data.CommandType.StoredProcedure, "CustomerGetList")
         Return oDS.Tables(0)
     Catch ex As Exception
         Throw ex
     Finally
         oDS = Nothing
     End Try
 End Function

So on our pages we might do something like this…

Default.aspx.vb

Protected Sub Button1_ClickSave()
     Dim oCustomer As New Customer
     oCustomer.FirstName = "Fred"
     oCustomer.LastName = "Mastro"
     oCustomer.SaveToDB()
 
     GridView1.DataSource = oCustomer.GetList()
     GridView1.DataBind()
 
     oCustomer = Nothing
 
 End Sub

And this returns a nice DataTable and populates the grid. Great!

Problem Areas over WCF to SliverLight

I was working on a SilverLight application that would talk to an existing business application, to pull back and list records. I had to use a Service, so I went with WCF since RIA.Net is not in production yet. The problem was that DataTables can not be serialized and set over WCF to SilverLight. So I tried messing with Linq to SQL to pull data back and populate classes I already had, but LinqTables are not serializable either, and instead of modifying all the Linq classes generated in my class I wanted to find an easier solution.

DataTable to List(Of Customer) Solution

I can across these two posts: Datatable to List of Objects Mapper and Creating datarow to object mapper and was amazed. Using reflection Chris Rock (lol) was able to read the properties of the object and map each column of the datatable to the desired property of the object. This is what I’m looking to do. This would manually mimic Linq type functionality. The Bulk of the code is this

My Helper.vb class file

  
Public Class Helper
 
    Public Function MapDatarowToObject(Of T)(ByVal dr As DataRow) As T
        Try
 
            If dr Is Nothing Then
                Return Nothing
            End If
 
            Dim instance As T = Activator.CreateInstance(Of T)()
 
            Dim properties() As Reflection.PropertyInfo = instance.GetType().GetProperties()
 
            If (properties.Length > 0) Then
                For Each propertyObject As Reflection.PropertyInfo In properties
 
                    Dim valueSet As Boolean = False
 
                    For Each attributeObject As Object In propertyObject.GetCustomAttributes(False)
 
                        If attributeObject.GetType() Is GetType(MapperColumn) Then
                            Dim columnAttributeObject As MapperColumn = CType(attributeObject, MapperColumn)
 
                            If (columnAttributeObject.ColumnName <> String.Empty) Then
 
                                If dr.Table.Columns.Contains(columnAttributeObject.ColumnName) AndAlso Not dr(columnAttributeObject.ColumnName) Is DBNull.Value Then
                                    propertyObject.SetValue(instance, dr(columnAttributeObject.ColumnName), Nothing)
                                    valueSet = True
 
                                End If
 
                            End If
                        End If
                    Next
 
                    If Not valueSet Then
                        If dr.Table.Columns.Contains(propertyObject.Name) AndAlso Not dr(propertyObject.Name) Is DBNull.Value Then
                            propertyObject.SetValue(instance, dr(propertyObject.Name), Nothing)
                        End If
                    End If
 
                Next
            End If
 
            Return instance
        Catch ex As Exception
            Throw ex
        End Try
    End Function
 
    Public Function MapDataTableToList(Of T)(ByVal dt As DataTable) As Collections.Generic.IList(Of T)
        If dt Is Nothing Then
            Return Nothing
        End If
 
        Dim list As IList(Of T) = New List(Of T)
 
        For Each dr As DataRow In dt.Rows
            list.Add(MapDatarowToObject(Of T)(dr))
        Next
 
        Return list
    End Function
 
End Class
 
<AttributeUsage(AttributeTargets.Property)> _
Public Class MapperColumn
    Inherits Attribute
 
    Private mColumnName As String
 
    Public Sub New(ByVal columnName As String)
        mColumnName = columnName
    End Sub
 
    Public Property ColumnName() As String
        Get
            Return mColumnName
        End Get
        Set(ByVal value As String)
            mColumnName = value
        End Set
    End Property
 
End Class
 

Using Mapper in WCF

Now in my WCF Service methods I can just instantiate Customers like I always do in the normal application and apply the new Mapper method to get a List of the class objects.

WCFServiceMethods.vb file (which is code-behind to WCFServiceMethods.svc)

 Imports System.ServiceModel
Imports System.ServiceModel.Activation
Imports System.Runtime.Serialization 'For DataContract
Imports System.Collections.Generic
 
<ServiceContract(Namespace:="")> _
<ServiceBehavior(IncludeExceptionDetailInFaults:=True)> _
<AspNetCompatibilityRequirements(RequirementsMode:=AspNetCompatibilityRequirementsMode.Allowed)> _
Public Class WCFServiceMethods
    <OperationContract()> _
    Public Function GetCustomers() As Collections.Generic.List(Of Customer)
        Dim oCustomer As New Customer
 
        Dim Customers As Collections.Generic.List(Of Customer)
        Customers = Helper.MapDataTableToList(Of Customer)(oCustomer.GetList())
 
        oCustomer = Nothing
        Return Customers
 
    End Function
End Class
 

You’ll see in Line 15, I can take the DataTable and now create a List(Of Customer) object, which is serializable and send it over the wire.

Applying it in SilverLight or Other Application that uses your WCF Service

Assuming you referenced your WCF Service.. Now on my SilverLight app on a button click I can get the List of Customers and show it natively in a datagrid.

MainPage.xaml code-behind

Private Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.Windows.RoutedEventArgs) Handles btnSearch.Click
     Dim oWCFProxy As New WCFService.WCFServiceClient
 
     AddHandler oWCFProxy.GetCustomers, AddressOf oWCFProxy_GetCustomersCompleted
     oWCFProxy.GetCustomersAsync()
 
     oWCFProxy = Nothing
 
 End Sub
 
 Private Sub oWCFProxy_GetCustomersCompleted(ByVal sender As Object, ByVal e As WCFService.GetCustomersCompletedEventArgs)
     Dim Customers As Collections.ObjectModel.Collection(Of oWCFProxy.Customer)
     Customers = e.Result
 
     DataGrid1.ItemsSource = Customers
 End Sub

Problem Area With Mapper Casting Types and Solution

So with all that above you should have enough to re-create all this. Read through Chris’ posts because it does a good job of explaining the mapper. I ran into a problem with the mapper though on line 39. Problem is when it tries to map data from the database, it all comes back as a string, and you don’t know until run-time what System.Type you need, so you can’t CType or DirectCast by using System.Type.GetType(), so I had to create a crappy function to Throw ex check every possible combination. This the best way? I sure hope it isn’t. Hope to find a better solution for it but was pressed for time.

So what was my crappy solution? I don’t even want to post it haha. I swapped out line 39 and 28 with the a call to this method of 1531 lines of code.

Private Sub TryCastTypeToPropertyType(ByRef propertyObject As Reflection.PropertyInfo, ByRef instance As Object, ByRef dr As DataRow, ByRef ColumnName As String)

        Try
            'Try to Default Types
            propertyObject.SetValue(instance, dr(ColumnName), Nothing)
        Catch exDefault1 As InvalidCastException
            Try
                'Try to String
                propertyObject.SetValue(instance, CType(dr(ColumnName), String), Nothing)
            Catch exString1 As InvalidCastException
                'Try to Integer
                Try
                    propertyObject.SetValue(instance, CType(dr(ColumnName), Integer), Nothing)
                Catch exInt32a As ArgumentException
                    'Try to DateTime
                    Try
                        propertyObject.SetValue(instance, CType(dr(ColumnName), DateTime), Nothing)
                    Catch exDate1 As ArgumentException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    Catch exDate2 As InvalidCastException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    End Try
                Catch exInt32b As InvalidCastException
                    'Try to DateTime
                    Try
                        propertyObject.SetValue(instance, CType(dr(ColumnName), DateTime), Nothing)
                    Catch exDate1 As ArgumentException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    Catch exDate2 As InvalidCastException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    End Try
                End Try
            Catch exString2 As ArgumentException
                'Try to Integer
                Try
                    propertyObject.SetValue(instance, CType(dr(ColumnName), Integer), Nothing)
                Catch exInt32a As ArgumentException
                    'Try to DateTime
                    Try
                        propertyObject.SetValue(instance, CType(dr(ColumnName), DateTime), Nothing)
                    Catch exDate1 As ArgumentException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    Catch exDate2 As InvalidCastException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    End Try
                Catch exInt32b As InvalidCastException
                    'Try to DateTime
                    Try
                        propertyObject.SetValue(instance, CType(dr(ColumnName), DateTime), Nothing)
                    Catch exDate1 As ArgumentException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    Catch exDate2 As InvalidCastException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    End Try
                End Try
            End Try
        Catch exDefault2 As ArgumentException
            Try
                'Try to String
                propertyObject.SetValue(instance, CType(dr(ColumnName), String), Nothing)
            Catch exString1 As InvalidCastException
                'Try to Integer
                Try
                    propertyObject.SetValue(instance, CType(dr(ColumnName), Integer), Nothing)
                Catch exInt32a As ArgumentException
                    'Try to DateTime
                    Try
                        propertyObject.SetValue(instance, CType(dr(ColumnName), DateTime), Nothing)
                    Catch exDate1 As ArgumentException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    Catch exDate2 As InvalidCastException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    End Try
                Catch exInt32b As InvalidCastException
                    'Try to DateTime
                    Try
                        propertyObject.SetValue(instance, CType(dr(ColumnName), DateTime), Nothing)
                    Catch exDate1 As ArgumentException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    Catch exDate2 As InvalidCastException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    End Try
                End Try
            Catch exString2 As ArgumentException
                'Try to Integer
                Try
                    propertyObject.SetValue(instance, CType(dr(ColumnName), Integer), Nothing)
                Catch exInt32a As ArgumentException
                    'Try to DateTime
                    Try
                        propertyObject.SetValue(instance, CType(dr(ColumnName), DateTime), Nothing)
                    Catch exDate1 As ArgumentException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    Catch exDate2 As InvalidCastException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    End Try
                Catch exInt32b As InvalidCastException
                    'Try to DateTime
                    Try
                        propertyObject.SetValue(instance, CType(dr(ColumnName), DateTime), Nothing)
                    Catch exDate1 As ArgumentException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    Catch exDate2 As InvalidCastException
                        'Try to Decimal
                        Try
                            propertyObject.SetValue(instance, CType(dr(ColumnName), Decimal), Nothing)
                        Catch exDecimal1 As ArgumentException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        Catch exDecimal2 As InvalidCastException
                            'Try to Double
                            Try
                                propertyObject.SetValue(instance, CType(dr(ColumnName), Double), Nothing)
                            Catch exDouble1 As ArgumentException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            Catch exDouble2 As InvalidCastException
                                'Try to Boolean
                                Try
                                    propertyObject.SetValue(instance, CType(dr(ColumnName), Boolean), Nothing)
                                Catch exBoolean1 As ArgumentException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                Catch exBoolean2 As InvalidCastException
                                    'Try To Date
                                    Try
                                        propertyObject.SetValue(instance, CType(dr(ColumnName), Date), Nothing)
                                    Catch ex As Exception
                                        Throw ex
                                    End Try
                                End Try
                            End Try
                        End Try
                    End Try
                End Try
            End Try
        End Try
    End Sub

Maybe I’ll get lucky and someone will post up a “Oh you can just do this, which is new in .Net 3.5 or 4.0.. “ and I can get rid of this thing. But hey it works!

Resource: How to Consume WCF and ASP.Net Web Services in Silverlight

5b104bb4-e443-49dd-b34d-3729c2b670df|1|5.0

Tags: programming, vb.net, code snippets, reflector

Named Finalist in Prestigious Software & Information Industry Association Awards

by Fred Mastro 8. December 2009 15:11

In application that I develop for has been nominated for Finalist in Prestigious Software & Information Industry Association Awards and selected as a finalist in the 25th annual Software & Information Industry Association CODiE Awards.

4073115d-29d8-4688-839b-ece153bb184d|0|.0

Tags: codie awards, software, about me

Programming | Personal | About Me | Software

Convert Pipe Delimited File to CSV File and Choose and Reorder Columns

by Fred Mastro 4. December 2009 00:43

A friend need a small program to take a Pipe file and convert it to a CSV file. Easy enough, replace the “|”,s with “,”’s. Until you add more requirements, allow the user to choose which columns they want to convert over and allow them to re-order the columns and save the file as something else. Ok now you’re talking about streamreaders, streamwriter, some type or reorder control and choosing columns. Turning a 45min project into a 3 hour project going at full pace, as I’m not much of a Windows Form developer, I generally stick in the asp.net world.

Anyway.. here’s the project in VB.Net and source code.

The executable is in it’s default location TextPipeConverter\TextPipeConverter\bin\Debug\TextPipeConverter.exe

TextPipeConverter.zip

Notes: There’s no error checking, very minor, no try catches, quick and dirty.

75161ad1-b516-4506-990f-f6612071eb96|1|5.0

Tags: vb.net, programming

VB.NET | Programming | Window Forms

Casting Types in VB.Net and More

by Fred Mastro 2. December 2009 10:32

Source: Cheat Sheet - Casting in VB.NET and C#

Great little find, and since I’m a VB.Net whore, I’ll just post up the VB.Net version :)

Casting in VB.NET

By default in VB, casting is automatically done for you when you assign objects to variables. The objects are then automatically casted to the variables' type.

This behavior can be influenced by an option line on top of your code file:
```
Option Strict On
Option Strict Off
```
When on, casting is strict and not automatic.
Explicit casting can be done with the cast operator CType() or DirectCast():
```
textbox = CType(obj, TextBox)
textbox = DirectCast(obj, TextBox)
```
The difference between the two keywords is that CType succeeds as long as there is a valid conversion defined between the expression and the type, whereas DirectCast requires the run-time type of an object variable to be the same as the specified type. If the specified type and the run-time type of the expression are the same, however, the run-time performance of DirectCast is better than that of CType. DirectCast throws an InvalidCastException error if the argument types do not match.
Testing if an object is of a particular type, can be done with the TypeOf...Is operator:
```
If TypeOf obj Is TextBox Then...
```
Obtaining a System.Type object for a given type can be done with the GetType operator:
```
Dim t As System.Type
t = GetType(String)
MessageBox.Show(t.FullName)
```
Obtaining a System.Type object for a given object can be done with the GetType method:
```
Dim t as System.Type
t = obj.GetType()
MessageBox.Show(t.FullName)
```

Now to build on and add one more of my own…

Get the type based on an arbitrary string.

System.Type.GetType("System.String")

Problem with this though is you can not use it to cast using CType or DirectCast. Looking at the CType Function..

typename - Any expression that is legal within an As clause in a Dim statement, that is, the name of any data type, object, structure, class, or interface.

You can only use types that are compiled and can’t use types that show up at runtime. So trying to use CType(obj, System.Type.GetType(“System.String”)) will only get you an error. Array bounds cannot appear in type specifiers.

How to get around this? I have no freaking idea, yet. I’m think I might could create a custom type of my own and do something so that it converts to the proper method but for now I’ll just catch a few ArgumentExceptions and try different cast types then.

ee0946e5-2b70-44ad-baed-84ff48e0ba4c|0|.0

Tags: vb.net, code snippets, programming, tip of the day, .net

Code Snippets | VB.NET | Programming | .Net Framework

C# - Singleton Pattern vs. Static Classes

by Fred Mastro 15. October 2009 14:37

Link sent to me from Justin.. as we’ve been discussing using Singleton’s in Win Services for the previous post I talked about. I’ll convert to VB later.

Original Article: http://dotnet.dzone.com/news/c-singleton-pattern-vs-static-

By Sam Allen

Problem: Store some common data in a singleton or static class about your program in an object array, which you store in a class. It saves state between usages and stores some caches, and must be initialized only once and shared in many code locations. Making a new object each time would be expensive.

Solution

This article covers the differences between the singleton design pattern and the static keyword on C# classes. Static classes and singletons both provide sharing of redundant objects in memory, but they are very different in usage and implementation.

Introducing the Singleton Pattern

Our ideal solution is called the singleton design pattern. Here is an implementation of a singleton that I will use. As you know, a singleton is a single-instance object. It is highly efficient and very graceful. Singletons have a static property that you must access to get the object reference.

view source

print ?

01./// <summary>

02./// Sample singleton object.

03./// </summary>

04.public sealed class SiteStructure

05.{

06. /// <summary>

07. /// Possible an expensive resource we need to only store in one place.

08. /// </summary>

09. object[] _data = new object[10];

10. /// <summary>

11. /// Allocate ourselves. We have a private constructor, so no one else can.

12. /// </summary>

13. static readonly SiteStructure _instance = new SiteStructure();

14. /// <summary>

15. /// Access SiteStructure.Instance to get the singleton object.

16. /// Then call methods on that instance.

17. /// </summary>

18. public static SiteStructure Instance

19. {

20. get { return _instance; }

21. }

22. /// <summary>

23. /// This is a private constructor, meaning no outsides have access.

24. /// </summary>

25. private SiteStructure()

26. {

27. // Initialize members, etc. here.

28. }

29.}

Static Class Example

In the following example, look carefully at how the static keyword is used on the class and constructor. Static classes may be simpler, but the singleton example has many important advantages, which I will elaborate on after this code block.

view source

print ?

01./// <summary>

02./// Static class example. Pay heed to the static keywords.

03./// </summary>

04.static public class SiteStatic

05.{

06. /// <summary>

07. /// The data must be a static member in this example.

08. /// </summary>

09. static object[] _data = new object[10];

10. /// <summary>

11. /// C# doesn't define when this constructor is run, but it will

12. /// be run right before it is used most likely.

13. /// </summary>

14. static SiteStatic()

15. {

16. // Initialize all of our static members.

17. }

18.}

You can use static classes to store single-instance, global data. The class will be initialized at any time, but it is my experience that it is initialized lazily, meaning at the last possible moment. However, you lose control over the exact behavior of the class by using a static class.

Singleton Advantages

Singletons preserve the conventional class approach, and don't require that you use the static keyword everywhere. They may be more demanding to implement at first, but will greatly simplify the architecture of your program. Unlike static classes, we can use singletons as parameters or objects.

view source

print ?

1.// We want to call a function with this structure as an object.

2.// Get a reference from the Instance property on the singleton.

3.{

4. SiteStructure site = SiteStructure.Instance;

5. OtherFunction(site); // Use singleton as parameter.

6.}

Interface Inheritance

In C#, an interface is a contract, and objects that have an interface must meet all of the requirements of that interface. Usually, the requirements of the interface are a subset of the object in question. Here is how we can use a singleton with an interface, which in the example is called ISiteInterface.

view source

print ?

01./// <summary>

02./// Stores signatures of various important methods related to the site.

03./// </summary>

04.public interface ISiteInterface

05.{

06.};

07./// <summary>

08./// Skeleton of the singleton that inherits the interface.

09./// </summary>

10.class SiteStructure : ISiteInterface

11.{

12. // Implements all ISiteInterface methods.

13. // [omitted]

14.}

15./// <summary>

16./// Here is an example class where we use a singleton with the interface.

17./// </summary>

18.class TestClass

19.{

20. /// <summary>

21. /// Sample.

22. /// </summary>

23. public TestClass()

24. {

25. // Send singleton object to any function that can take its interface.

26. SiteStructure site = SiteStructure.Instance;

27. CustomMethod((ISiteInterface)site);

28. }

29. /// <summary>

30. /// Receives a singleton that adheres to the ISiteInterface interface.

31. /// </summary>

32. private void CustomMethod(ISiteInterface interfaceObject)

33. {

34. // Use the singleton by its interface.

35. }

36.}

Now we can reuse our singleton for any of the implementations of interface-conforming objects. There may be 1, 2, or 10. We don't need to rewrite anything over and over again. We store state more conventionally, use objects by their interfaces, and can use traditional object-oriented programming best practices.

Conclusion

Here we can reuse code and control object state much easier. This allows you greatly improved code-sharing, and a far cleaner body of code. With less code, your programs will usually have fewer bugs and will be easier to maintain. One good book about this topic is called C# Design Patterns and is written by Judith Bishop.

d58b95a1-3bc4-4ded-912b-4eb6c29f834d|0|.0

Tags: c#, .net, programming

C# | .Net Framework | Programming

.Net – Improve garbage collection and performance

by Fred Mastro 15. October 2009 10:10

My friend Pasha, found a great article by QuestPond over at DotNetFunda that covers the theory and best practices of proper .Net garbage collection.

-----------------

In order to validate the same we will first start with bit of theory and then we will actually see how GC algorithm performance is impacted using destructor. So we will first understand the concept of generations and then we will see the finalize dispose pattern.

Is this Article worth reading ahead?

With this article you will understand how performance of GC algorithm can be improved using finalize dispose pattern. Below figure shows the comparison of what we will be achieving after this article.

Introduction and Goal

Ask any developer which is the best place in a .NET class to clean unmanaged resources?, 70% of them will say the destructor. Although it looks the most promising place for cleanup it has a huge impact on performance and memory consumption. Writing clean up code in the destructor leads to double GC visits and thus affecting the performance multifold times.
In order to validate the same we will first start with bit of theory and then we will actually see how GC algorithm performance is impacted using destructor. So we will first understand the concept of generations and then we will see the finalize dispose pattern.
I am sure this article will change your thought process regarding destructor, dispose and finalize.
Please feel free to download my free 500 question and answer eBook which covers .NET , ASP.NET , SQL Server , WCF , WPF , WWF@ http://www.questpond.com .

Assumptions

This article uses CLR profiler to profile how GC works. In case you are new to CLR profiler please do read net-best-practice-no-1-detecting-high-memory-consuming-functions-in-net-code before you go ahead with this one.

Thanks Mr. Jeffrey Richter and Peter Sollich

Let’s start this article by first thanking Mr. Jeffery Richter for explaining in depth how garbage collection algorithm works. He has written two legendary articles about the way garbage collector work. I actually wanted to point to the MSDN magazine article written by Jeffery Richter but for some reason it’s not showing up in MSDN. So I am pointing to a different unofficial location, you can download both the articles from http://www.cs.inf.ethz.ch/ssw/files/GC_in_NET.pdf in a PDF format.
Also thanks to Mr. Peter Sollich who is the CLR Performance Architect to write such a detail help on CLR profiler. When you install the CLR profiler please do not forget to read the detail help document written by Peter Sollich. In this article we will use the CLR profiler to check how the garbage collector performance is affected using finalize.
Thanks a lot to you guys. There was no way I would have completed this article without reading articles written by you. Any time you guys pass by article please do comment on the same would love to hear from you guys.

Garbage collector – The unsung Hero

As said in the introduction writing clean up code in constructor leads to double GC visits. Many developers would like to just shrug off and say ‘Should we really worry about GC and what it does behind scenes?”. Yes, actually we should not worry about GC if you write your code properly. GC has the best algorithm to ensure that your application is not impacted. But many times the way you have written your code and assigned/cleaned memory resources in your code affects GC algorithm a lot. Sometimes this impact leads to bad performance of GC and hence bad performance for your application.
So let’s first understand what different tasks are performed by the garbage collector to allocate and clean up memory in an application.
Let’s say we have 3 classes where in class ‘A’ uses class ‘B’ and class ‘B’ uses class ‘C’.

When the first time your application starts predefined memory is allocated to the application. When the application creates these 3 objects they are assigned in the memory stack with a memory address. You can see in the below figure how the memory looks before the object creation and how it looks after object creation. In case there was an object D created it will be allocated from the address where Object C ends.

Internally GC maintains an object graph to know which objects are reachable. All objects belong to the main application root object. The root object also maintains which object is allocated on which memory address. In case an object is using other objects then that object also holds a memory address of the used object. For example in our case object A uses Object B. So object A stores the memory address of Object B.

Now let’s say Object ‘A’ is removed from memory. So the Object ‘A’ memory is assigned to Object ‘B’ and Object ‘B’ memory is assigned to object ‘C’. So the memory allocation internally looks something as shown below.

As the address pointers are updated GC also needs to ensure that his internal graph is updated with new memory addresses. So the object graph becomes something as shown below. Now that’s a bit of work for GC it needs to ensure that the object is removed from graph and the new addresses for the existing objects is updated throughout the object tree.

An application other than his own custom objects also has .NET objects which also form the part of the graph. The addresses to those objects also need to be updated. The number of objects of .NET runtime is very high. For instance below is the number of objects created for a simple console based hello world application. The numbers of objects are approximately in 1000’s. Updating pointers for each of these objects is a huge task.

Generation algorithm – Today, yesterday and day before yesterday

GC uses the concept of generations to improve performance. Concept of generation is based on the way human psychology handles tasks. Below are some points related to how tasks are handled by humans and how garbage collector algorithm works on the same lines:-
• If you decide some task today there is a high possibility of completion of those tasks.
• If some task is pending from yesterday then probably that task has gained a low priority and it can be delayed further.
• If some task is pending from day before yesterday then there is a huge probability that the task can be pending forever.
GC thinks in the same lines and has the below assumptions:-
• If the object is new then the life time of the object can be short.
• If an object is old then it can have a long life time.
So said and done GC supports three generations (Generation 0, Generation 1 and Generation 2).

Generation 0 has all the newly created objects. When the application creates objects they first come and fall in the Generation 0 bucket. A time comes when Generation 0 fills up so GC needs to run to free memory resources. So GC starts building the graph and eliminating any objects which are not used in application any more. In case GC is not able to eliminate an object from generation 0 it promotes it to generation 1. If in the coming iterations it’s not able to remove objects from generation 1 it’s promoted to generation 2. The maximum generation supported by .NET runtime is 2.
Below is a sample display of how generation objects are seen when you run CLR profiler. In case you are new to CLR profiler you can catch up the basics from net-best-practice-no-1-detecting-high-memory-consuming-functions-in-net-code

Ok, so how does generation help in optimization

As the objects are now contained in generations, GC can make a choice which generation objects he wants to clean. If you remember in the previous section we talked about the assumptions made by GC regarding object ages. GC assumes that all new objects have shorter life time. So in other words GC will mainly go through generation 0 objects more rather than going through all objects in all generations.
If clean up from generation 0 does not provide enough memory it will then move towards cleaning from generation 1 and so on. This algorithm improves GC performance to a huge extent.

Conclusion about generations

• Huge number of object in Gen 1 and 2 means memory utilization is not optimized.
• Larger the Gen 1 and Gen 2 regions GC algorithm will perform more worst.

Using finalize/destructor leads to more objects in Gen 1 and Gen 2

The C# compiler translates (renames) the destructor into Finalize. If you see the IL code using IDASM you can see that the destructor is renamed to finalize. So let’s try to understand why implementing destructor leads to more objects in gen 1 and gen 2 regions. Here’s how the process actually works:-
• When new objects are created they are moved to gen 0.
• When gen 0 fills out GC runs and tries to clear memory.
• If the objects do not have a destructor then it just cleans them up if they are not used.
• If the object has a finalize method it moves those objects to the finalization queue.
• If the objects are reachable it’s moved to the ‘Freachable’ queue. If the objects are unreachable the memory is reclaimed.
• GC work is finished for this iteration.
• Next time when GC again starts its goes to Freachable queue to check if the objects are not reachable. If the objects are not reachable from Freachable memory is claimed back.

In other words objects which have destructor can stay more time in memory.
Let’s try to see the same practically. Below is a simple class which has destructor.

class clsMyClass 
{ 
public clsMyClass()
{ 
}
~clsMyClass()
{
}
}

We will create 100 * 10000 objects and monitor the same using CLR profiler.

for (int i = 0; i < 100 * 10000; i++)
{
clsMyClass obj = new clsMyClass();
}

If you see the CLR profiler memory by address report you will see lot of objects in gen 1.

Now let’s remove the destructor and do the same exercise.

class clsMyClass 
{ 
public clsMyClass()
{ 
}
}

You can see the gen 0 has increased considerably while gen 1 and 2 are less in number.

If we see a one to one comparison it’s something as shown in the below figure.

Get rid of the destructor by using Dispose

We can get rid of the destructor by implementing our clean up code in the dispose method For that we need to implement the ‘IDisposable’ method , write our clean up code in this and call suppress finalize method as shown in the below code snippet. ‘SuppressFinalize’ dictates the GC to not call the finalize method. So the double GC call does not happen.

class clsMyClass : IDisposable
{ 
public clsMyClass()
{ 
}
~clsMyClass()
{
}

public void Dispose()
{
GC.SuppressFinalize(this);
} 
}

The client now needs to ensure that it calls the dispose method as shown below.

for (int i = 0; i < 100 ; i++)
{
clsMyClass obj = new clsMyClass();
obj.Dispose(); 
}

Below is the comparison of how Gen 0 and 1 distribution looks with constructor and with dispose. You can see there is marked improvement in gen 0 allocation which signifies good memory allocation.

What if developers forget to call Dispose?

It’s not a perfect world. We cannot ensure that the dispose method is always called from the client. So that’s where we can use Finalize / Dispose pattern as explained in the coming section.
There is a detailed implementation of this pattern at http://msdn.microsoft.com/en-us/library/b1yfkh5e(VS.71).aspx.
Below is how the implementation of finalize / dispose pattern looks like.

class clsMyClass : IDisposable
{ 
public clsMyClass()
{

}

~clsMyClass()
{
// In case the client forgets to call
// Dispose , destructor will be invoked for
Dispose(false);
}
protected virtual void Dispose(bool disposing)
{
if (disposing)
{
// Free managed objects.
}
// Free unmanaged objects

}

public void Dispose()
{
Dispose(true);
// Ensure that the destructor is not called
GC.SuppressFinalize(this);
} 
}

Explanation of the code:-
• We have defined a method called as Dispose which takes a Boolean flag. This flag says is this method called from Dispose or from the destructor. If this is called from the ‘Dispose’ method then we can free both managed and unmanaged resources.
• If this method is called from the destructor then we will just free the unmanaged resources.
• In the dispose method we have suppressed the finalize and called the dispose with true.
• In the destructor we have called the dispose function with false value. In other words we assume that the GC will take care of managed resources and let’s take the destructor call to clean unmanaged resources.
In other words if the client does not call the dispose function the destructor will take care of cleaning the unmanaged resources.

Conclusion

• Do not have empty constructors in your classes.
• In case you need to clean up use finalize dispose pattern with ‘SupressFinalize’ method called.
• If there is a dispose method exposed by a class , ensure to call the same from your client code.
• Application should have more objects allocated in Gen 0 than Gen 1 and Gen 2. More objects in Gen 1 and 2 is sign of bad GC algorithm execution.

Source code

You can find the sample source code for the dispose pattern at from here

519c4e8f-3aac-4c50-9dd3-395b74cb10e1|2|5.0

Tags: .net, programming

Programming | .Net Framework

<< Previous posts

	Some websites I've worked on. This is a small collection of sites I've developed or added to awhile back.

	Revenge Movie Trailer. Trailer I made with Adobe Premiere and After Effects. Jason Christman is the main star and I'm the director behind the camera.

	Essential Software For your Mac. - I'm a Microsoft geek, but I've switched over to Mac. There was a lot of stuff I needed to get installed that I missed on my Windows machine. Also I had no idea how to do it :p Here's some help.

	Speed Football. I wanted to make a special effect like the Smallville or Superman running fast. All the other ones I've seen, the person in the frame was the only moving object while everything else was blurred. I wanted to create the effect but interact with another normal moving object.

	Code Snippets and Quickies. Sometims I find something or develop something that I think is useful and it can be copied and pasted anywhere for someone to use. Here's a collection of things I've posted on.

VB.NET to C# Differences

Microsoft Certification Step-By-Step Road Map for .NET Development, SQL 2008 Server, Team Foundation and Sharepoint

Sending Generic.List collection back to WCF ObservableCollection

.Net Resetting Scroll Position When MaintainScrollPositionOnPostBack = True

Mapping a DataTable to an Object Class. Like a homemade Linq to SQL. Send over WCF to SilverLight

Named Finalist in Prestigious Software & Information Industry Association Awards

Convert Pipe Delimited File to CSV File and Choose and Reorder Columns

Casting Types in VB.Net and More

Casting in VB.NET

C# - Singleton Pattern vs. Static Classes

Solution

Introducing the Singleton Pattern

Static Class Example

Singleton Advantages

Interface Inheritance

Conclusion

.Net – Improve garbage collection and performance

Is this Article worth reading ahead?

Introduction and Goal

Assumptions

Thanks Mr. Jeffrey Richter and Peter Sollich

Garbage collector – The unsung Hero

Generation algorithm – Today, yesterday and day before yesterday

Ok, so how does generation help in optimization

Conclusion about generations

Using finalize/destructor leads to more objects in Gen 1 and Gen 2

Get rid of the destructor by using Dispose

What if developers forget to call Dispose?

Conclusion

Source code

About the author

Web Tools - QuickLinks

Month List

Page List

Highlights

Other FredMastro Sites

Twitter

Books I've Read or Reading

Casting in VB.NET

Solution

Introducing the Singleton Pattern

Static Class Example

Singleton Advantages

Interface Inheritance

Conclusion

About the author

Web Tools - QuickLinks

Tag cloud

Month List

Page List

Highlights

Other FredMastro Sites

Twitter

Blogroll

Books I've Read or Reading