Adding a solution to TFS without adding the NuGet packages.

I was adding a project that I just completed to TFS source control and noticed that it wanted to add the packages to source control also, but I didn’t want that because you are not supposed to add the NuGet packages. They can be re-downloaded and installed during the build process for anyone that does not have them.

I found this nuget link extremely useful on how to configure the solution to 1) Enable the nuget download and 2) keep the packages from being added to source control.

The basic steps are:

Enable the NuGet package restore. This will add some NuGet stuff to the solution.
Add your project to TFS, then of course commit the change.

C# Parallel Tasks gives MAJOR Speed Increase

I just used parallel tasks to decrease the time a process took from over an hour to about 2 minutes. I was wary of creating so many database contexts, but it paid off in a major way!

See the snippet of code below to see how I used the Parallel.ForEach. .Net created almost 100 threads during the execution.

Parallel.ForEach(qry, issue =>
{
	using (var _db = new WCO())
	{
		dobType dob;
		List&lt;dobType> birthdays = new List&lt;dobType>();

		foreach (
			var subIssue in
				issue.DOBValue.Trim().Split(new string[] { " TO ", " to ", "-", " - " },
					StringSplitOptions.RemoveEmptyEntries))
		{
			string valueToTest = subIssue;

			// Try Month Year regex
			if (tryDateFirstPart(valueToTest, out dob))
			{
				logger.Info(string.Format("Parsed {0} to Month: {1}, Day {2} Year: {3}", issue,
					dob.month,
					dob.day, dob.year));
				saveParseDOB(dob, issue, _db);
			}
			else
			{
				logger.Error(string.Format("Could not parse {0}", issue.DOBValue));
			}
		}

	}
});

Parallel.ForEach(qry, issue =>

{

using (var _db = new WCO())

{

dobType dob;

List<dobType> birthdays = new List<dobType>();

foreach (

var subIssue in

issue.DOBValue.Trim().Split(new string[] { " TO ", " to ", "-", " - " },

StringSplitOptions.RemoveEmptyEntries))

{

string valueToTest = subIssue;

// Try Month Year regex

if (tryDateFirstPart(valueToTest, out dob))

{

logger.Info(string.Format("Parsed {0} to Month: {1}, Day {2} Year: {3}", issue,

dob.month,

dob.day, dob.year));

saveParseDOB(dob, issue, _db);

}

else

{

logger.Error(string.Format("Could not parse {0}", issue.DOBValue));

}

});

If you need someone with my ability to decrease processing times on a full time basis, please contact me through LinkedIn

Have a great day!

Learning about SOLID programming principles

I have been learning about SOLID programming principles and I wanted to share the resources that I have found.

First, I listed to the father of these principles describe them on the Hansleman show. This post obviously caused a few ruffled feathers and for fun, you must listen to show #150 to hear some of the aftermath from Uncle Bob.

Then I found a great youtube video of Steve Bohlen from Microsoft show examples in C# on how these principles can be implemented and what to look for.

ToQuarter C# DateTime Extension

I searched on the internet for a quick way to get the Quarter from a DateTime, but I didn’t really find anything useful, so I created this quick extension that seems to work great! I just wanted to share this to save someone time so they don’t waste the same amount of time that I did. I am thinking about putting together an open source library to handle many other things like this, what are your thoughts about this?

    public static class DateTimeExtensions
    {
        public static int ToQuarter(this DateTime dt)
        {
            int qtr = -1;
            if (dt.Month &gt;= 1 &amp;&amp; dt.Month &lt;= 3)
                qtr = 1;
            else if (dt.Month &gt;= 4 &amp;&amp; dt.Month &lt;= 6)
                qtr = 2;
            else if (dt.Month &gt;= 7 &amp;&amp; dt.Month &lt;= 9)
                qtr = 3;
            else if (dt.Month &gt;= 10 &amp;&amp; dt.Month &lt;= 12)
                qtr = 4;

            return qtr;
        }
    }

public static class DateTimeExtensions

{

public static int ToQuarter(this DateTime dt)

{

int qtr = -1;

if (dt.Month >= 1 && dt.Month <= 3)

qtr = 1;

else if (dt.Month >= 4 && dt.Month <= 6)

qtr = 2;

else if (dt.Month >= 7 && dt.Month <= 9)

qtr = 3;

else if (dt.Month >= 10 && dt.Month <= 12)

qtr = 4;

return qtr;

}

Converting Oracle Comments to SQL Server.

I downloaded some code a recently that creates an Oracle Database, but I don’t have Oracle, so I converted most of the code to SQL Server. One of the harder things to convert was the column and table comments. One of the features of Oracle that Microsoft SQL Server does not have directly is commenting. It appears that you can have comments on a table and comments on a column (field) in the table.

Well after doing some research into how to convert these to SQL Server, I came across an article at http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37796 that told how to do this. Well, I had a script with over 1,100 comments, so I used LinqPad to create a small program that would convert my script using Regular Expressions.

Here is the code for that, please let me know if this helps anyone. It sure made my work a lot easier.

This is for Table Comments:

void Main()
{
		List&lt;string&gt; lines = System.IO.File.ReadAllLines(@&quot;C:\Users\username\Downloads\TableComments.SQL&quot;).ToList();

		// Display the file contents by using a foreach loop.
		Regex ex = new Regex(@&quot;^comment on table (\w+) IS (\&#039;.+\&#039;);&quot;, RegexOptions.IgnoreCase);
		StringBuilder sb = new StringBuilder();

		string repl = @&quot;EXEC sp_addextendedproperty @name = N&#039;MS_Description&#039;, @value = $2, @level0type = N&#039;USER&#039;, @level0name = &#039;dbo&#039;,@level1type = N&#039;Table&#039;, @level1name = &#039;$1&#039;;&quot;;
		string newline = string.Empty;
		foreach (string line in lines)
		{
			if (ex.IsMatch(line))
			{
				newline = ex.Replace(line,repl);
				sb.AppendLine(newline);
				Console.WriteLine(newline);
			}
			else
			{
				// If there is not a match, output it anyway, might be comments in the code.
				sb.AppendLine(line);
				Console.WriteLine(line);
			}
		}

		// save the converted file.
		using (StreamWriter outfile = new StreamWriter(@&quot;C:\Users\username\Downloads\TableCommentsConverted.SQL&quot;))
		{
			outfile.Write(sb.ToString());
		}

}

void Main()

{

List<string> lines = System.IO.File.ReadAllLines(@"C:\Users\username\Downloads\TableComments.SQL").ToList();

// Display the file contents by using a foreach loop.

Regex ex = new Regex(@"^comment on table (\w+) IS (\'.+\');", RegexOptions.IgnoreCase);

StringBuilder sb = new StringBuilder();

string repl = @"EXEC sp_addextendedproperty @name = N'MS_Description', @value = $2, @level0type = N'USER', @level0name = 'dbo',@level1type = N'Table', @level1name = '$1';";

string newline = string.Empty;

foreach (string line in lines)

{

if (ex.IsMatch(line))

{

newline = ex.Replace(line,repl);

sb.AppendLine(newline);

Console.WriteLine(newline);

}

else

{

// If there is not a match, output it anyway, might be comments in the code.

sb.AppendLine(line);

Console.WriteLine(line);

}

// save the converted file.

using (StreamWriter outfile = new StreamWriter(@"C:\Users\username\Downloads\TableCommentsConverted.SQL"))

{

outfile.Write(sb.ToString());

}

And here is the code for Column comments.

void Main()
{
		string[] lines = System.IO.File.ReadAllLines(@&quot;C:\Users\username\Downloads\ColumnComments.SQL&quot;);

		Regex ex = new Regex(@&quot;^comment on column (\w+)\.(\w+) IS (\&#039;.+\&#039;);&quot;, RegexOptions.IgnoreCase);
		StringBuilder sb = new StringBuilder();
		string repl = @&quot;EXEC sp_addextendedproperty @name = N&#039;$1.$2&#039;, @value = $3, @level0type = N&#039;USER&#039;, @level0name = &#039;dbo&#039;,@level1type = N&#039;Table&#039;, @level1name = &#039;$1&#039;,  @level2type = N&#039;Column&#039;, @level2name = &#039;$2&#039;;&quot;;
		string newline = string.Empty;
		foreach (string line in lines)
		{

			if (ex.IsMatch(line))
			{
				newline = ex.Replace(line,repl);
				sb.AppendLine(newline);
				Console.WriteLine(newline);
			}
			else
			{
				// if there is not a match, output the line anyway, for spaces and comments in the file.
				sb.AppendLine(line);
				Console.WriteLine(line);
			}
		}

		// save the converted file.
		using (StreamWriter outfile = new StreamWriter(@&quot;C:\Users\username\Downloads\ColumnCommentsConverted.SQL&quot;))
		{
			outfile.Write(sb.ToString());
		}

}

// Define other methods and classes here

void Main()

{

string[] lines = System.IO.File.ReadAllLines(@"C:\Users\username\Downloads\ColumnComments.SQL");

Regex ex = new Regex(@"^comment on column (\w+)\.(\w+) IS (\'.+\');", RegexOptions.IgnoreCase);

StringBuilder sb = new StringBuilder();

string repl = @"EXEC sp_addextendedproperty @name = N'$1.$2', @value = $3, @level0type = N'USER', @level0name = 'dbo',@level1type = N'Table', @level1name = '$1', @level2type = N'Column', @level2name = '$2';";

string newline = string.Empty;

foreach (string line in lines)

{

if (ex.IsMatch(line))

{

newline = ex.Replace(line,repl);

sb.AppendLine(newline);

Console.WriteLine(newline);

}

else

{

// if there is not a match, output the line anyway, for spaces and comments in the file.

sb.AppendLine(line);

Console.WriteLine(line);

}

// save the converted file.

using (StreamWriter outfile = new StreamWriter(@"C:\Users\username\Downloads\ColumnCommentsConverted.SQL"))

{

outfile.Write(sb.ToString());

}

// Define other methods and classes here