vijayanandgawle

What's New in C# 3.0 On the heels of the Visual Studio 2005 and C# 2.0 releases, Microsoft has given a sneak preview of what to expect in the version after the next: C# 3.0. Even though C# 3.0 is not even standardized yet, Microsoft provided a preview release at its Professional Developers Conference (PDC) in September so eager developers could try out some of the expected features. This article discusses the following major new enhancements expected in C# 3.0: * Implicitly typed local variables * Anonymous types * Extension methods * Object and collection initializers * Lambda expressions * Query expressions * Expression Trees Implicitly Typed Local Variables C# 3.0 introduces a new keyword called "var". Var allows you to declare a new variable, whose type is implicitly inferred from the expression used to initialize the variable. In other words, the following is valid syntax in C# 3.0: var i = 1; The preceding line initializes the variable i to value 1 and gives it the

Contents [ hide ] 1 Introduction 2 Inner JOIN 3 Outer JOIN 4 Additional Notes related to JOIN 5 Cross JOIN 6 Self-JOIN Introduction In this article, we’ll see the basic concepts of SQL JOINs. In the later part of the article, we’ll focus on the advanced subject of Self-JOIN and some interesting observations on how inner JOIN can be simulated using left JOIN. The author has tried his best to amalgamate various topics in a single concept. The JOIN keyword is used in a SQL statement to query data from two or more tables based on a relationship between certain columns in these tables. Inner JOIN A JOIN that displays only rows that have a match in both the JOINed tables is known as inner JOIN.  This is the default type of JOIN in the Query and View Designer. Outer JOIN A JOIN that includes rows even if they do not have related rows in the joined table is an Outer JOIN.  You can create three different outer JOINs to specify the unmatched rows to be inc

When you earn a Microsoft Certified Technology Specialist (MCTS) certification, you validate your in-depth technical knowledge and skill in using the features and functionality of key technology areas in Microsoft Visual Studio and the Microsoft .NET Framework to design software applications. You can earn a single certification to show your depth of knowledge in a specific Visual Studio technology, earn multiple certifications to demonstrate your breadth of understanding across different specialties, or build on your MCTS certification to earn a Professional Series credential. Learn about the MCPD credential Each MCTS certification requires two exams: a core exam and one additional, specialized exam. Use the following table to determine the certification that best fits your current role and career goals. Note You need to pass Exam 70-536 only once for MCTS or MCPD certification. Individual MCTS certifications will be retired when Microsoft discontinues mainstream support for the relate

To enjoy the free activation period in Windows Server 2008, users need to install Windows Server 2008 without activating it. To do so, run the Windows Server 2008 Setup program, but do no enter any product key when prompted to enter a product key for activation. Then, click “No” when asked to confirm your selection. The initial 60-day evaluation period which do not require activation be done starts after installation finished. How to manually extend the activation grade period on expiring When the 60-day activation grace period is about to expire and end, run the slmgr.vbs script to reset and extend the evaluation period for another new 60-day trial evaluation period, with everything including programs installed and data intact. Open an elevated privilege command prompt. Type the slmgr.vbs -rearm, and then press Enter to reset the activation grace period to 60 days. Restart the computer. To check the status or time that is left on current activation grace period or evaluation period, r