OneNickWare

God Bless Microsoft....or more importantly Anders Hejlsberg (Lead Architect of C #) for System.Reflection in the Generics scheme of things....It has been one the the more useful components that has saved my life many a times....

If you're wondering what the heck I'm may be rambling about, take a look at the link in the post.

Generics basically allow you to define methods or classes that works with any data type. Flexibility worth having when developing robust model components that can be reused in other solutions you may build...oooh its soo good...

Think its time i take my leave...I'll leave you with this:

Don't only see the hole in the doughnut, but recognize there is doughnut around that hole!! (Relevant or not still a good quote)

Cheers....OneNick

An Introduction to C# Generics Summary: This article discusses the problem space generics address, how they are implemented, the benefits of the programming model, and unique innovations, such as constrains, generic methods and delegates, and generic inheritance. In addition it discusses how the .NET Framework utilizes generics (...

[MSSQL Join Problem]

So here I was, that fateful morning, got up very early [for once], sitting at my desk, faced with another SQL challenge that bothered me for 2 days when it dawned on me that the solution was right before mine eyes (always is :-) ). I was required to create a view [result set of a stored query — or map-and-reduce functions wikipedia.com] from 3 tables, 1 of which contained the foreign keys of the other two (hereafter referred to as middle table). But here's the catch, that same table had NULL values for either or both of the Foreign Keys. So Im thinking well I cant do Inner Joins since I'll only get one table to match at a time, maybe a case would work...but nah was too lazy to even think about that...then it hit me....Google It (always a life saver). I stumbled onto (link below) just to see my options. Figured i should learn them all and I found my friends Lefter and Right Outer Joins...Problem Solved

Id then left join Table 1 to the middle table the right join the other to that result set...thanks to Sub Querying...

Something like this:
SELECT Dum.*, dbo.[Level].*

FROM dbo.[Level]

RIGHT OUTER JOIN

(SELECT dbo.Activity_Log_Spelling.*dbo.Activity_Log_Spelling.FK_Level, dbo.Word.*
FROM
dbo.Activity_Log_Spelling

LEFT OUTER JOIN
db.Word ON dbo.Activity_Log_Spelling.FK_Word = dbo.Word.Unique_ID) AS Dum

ON
dbo.[Level].Unique_ID = Dum.FK_Level

And it worked like a charm...Moral is get up early and work it pays off!!! Learn your SQL!!!

SQL Server Join Example I am new to SQL Server and want to learn about the JOIN options. What are all of the JOIN options in SQL Server? What is the significance of each of the options? I am a little confused on the differences and syntax, can you provide some examples and ex

POST 2 : PHP vs .NET

5. PHP enables "Quick and Dirty Programming Styles" while .NET ensures neat and well structured programming.

Based ones constraints, or choice, either can be well suited to the task at hand.

6. Hosting is an issue for ASP.Net Type applications. Not much vendors sell their space cheap and the

complications ... my God... is a heart ache...PHP on the other hand is as simple and cheap as uploading files.

maybe ur db and bam thats it...if .NET gonna be such a pain then PHP mite just be a better route..

7. Better to compare J2EE with .NET ... that would be interesting...

According to Harry Fuecks, ask yourself these three questions:

1. "Is there anything here I’m not already doing or capable of doing?"
2. "Do I want to be forced into a sharp learning curve, a particular coding style and particular strategies

for Web development?"
3. "Do I feel like paying more for hosting?"

"Youre not missing out if you choose PHP or .NET, just get the job done!"

POST 1: .NET vs PHP

1. .NET is the application framework upon which .NET capable languages such as C #, F #, etc are executed. PHP is an interpreted language that operates a PHP interpreting platform

2. .NET capsules development within the all powerful OO Paradigm, while PHP still extends the flexibility of choosing whether to develop OO applications or simple procedural "hacked" (sitepoint:

http://www.sitepoint.com/php-top-10-net-myths-exposed) scripts.

3. Both .NET and PHP can enjoy the benefits of being compiled. PHP uner Zend uses PhP Accelerator (termed advanced caches) with .NET uses CLR.

4. .NET languages because of its propriety nature has a wider resource repository. Nevertheless, PHP because

of its increasing popularity, has generated a large community. Both are now accountable platforms in the coding world.

Debate - .NET V. PHP: Top 10 .NET Myths Exposed - SitePoint .NET or PHP - which is better? As he clears up the .NET myths and mysteries, Harry shows just how - and why - PHP will continue to flourish, regardless of .NET!