1.Difference between .Net 2.0,3.0,3.5 ?

This question may be ask any interview. so the answer us that:

NET Framework 2.0
• A new hosting API for native applications wishing to host an instance of the .NET runtime
• Full 64-bit support for both the x64 and the IA64 hardware platforms.
• Language support for Generics built directly into the .NET CLR.
• Many additional and improved ASP.NET web controls.
• New data controls with declarative data binding.
• New personalization features for ASP.NET, such as support for themes, skins and webparts.
.NET Framework 3.0

• Windows Presentation Foundation (WPF), formerly code-named Avalon; a new user interface subsystem and API based on XML and vector graphics, which will make use of 3D computer graphics hardware and Direct3D technologies.
• Windows Communication Foundation (WCF), formerly code-named Indigo; a service-oriented messaging system which allows programs to interoperate locally or remotely similar to web services.
• Windows Workflow Foundation (WWF) allows for building of task automation and integrated transactions using workflows.
• Windows CardSpace (WCS), formerly code-named InfoCard; a software component which securely stores a person's digital identities and provides a unified interface for choosing the identity for a particular transaction, such as logging in to a website.


2.0 => framework that shipped with VS 2005 VB 8.0 / C# 2.0
3.0 => same framework as 2.0 + WCF + WPF + WF
3.5 => all the above + LINQ technologies and will ship with the next VS including VB 9.0 and C# + Ajax included.


1.1=> we had the basic framework, web services, CLR, ADO etc
2.0=> paid more attention on increasing the productivity of the developer. They had modules like MARS, Generics, Partial classes, DPAPI etc.
3.0=> WCF, WPF and WWF
3.5=> LINQ, AJAX which is now an integral part of 3.5 setup and new protocol support for WS-* specifications.

List all the Stored Procedures/Triggers/Views Associated with a specific Table?

DECLARE @TABLENAME VARCHAR(50)
SET @TABLENAME='' --Pass the Table Name here
SELECT @TableName as "Table Name",A.Name AS "SP Name",B.Text as "SP Text" from SYSOBJECTS A
INNER JOIN SYSCOMMENTS B
ON A.ID=B.ID
WHERE B.TEXT LIKE '%'+@TableName+'%'
and A.TYPE='P'

Same way we can use the above query to find out View, Trigger. If you wanted to list views and Triggers change the value of "Type" as below,
TYPE='V' --For View
TYPE='TR' -- Trigger

string.IsNullOrWhiteSpace()

string.IsNullOrWhiteSpace()
.NET 4 adds new method called string.IsNullOrWhiteSpace() which checks for spaces, empty or null. This is a nice time-saver for developers.. This static method returns true if a string is full of whitespace characters. Let us consider the below example .

static void Main()
{
string strTest = "Simple Talk";
string strNull = null;
string strEmpty = string.Empty;
string strWhiteSpace = "\t\r\n\n ";
Console.WriteLine("Is null or whitespace Exmaple!!");
Console.WriteLine("TestSting: " + string.IsNullOrWhiteSpace(strTest));//false
Console.WriteLine("NullString: " + string.IsNullOrWhiteSpace(strNull)); //true
Console.WriteLine("EmptyString: " + string.IsNullOrWhiteSpace(strEmpty)); //true
Console.WriteLine("WhiteSpaceString: " + string.IsNullOrWhiteSpace(strWhiteSpace)); //true
Console.ReadLine();
}

Partial Class sealed class

Partial Class

In this article I will explain what is a partial class? What are the benefits of using partial classes and how to implement partial classes in your C# applications.

Partial class is a new feature added to C# 2.0 and Visual Studio 2005. It is supported in .NET Framework 2.0. If you are working with .NET 1.0 or 1.1, partial classes may not work.

It is possible to split the definition of a class or a struct, or an interface over two or more source files. Each source file contains a section of the class definition, and all parts are combined when the application is compiled.

When working on large projects, spreading a class over separate files allows multiple programmers to work on it simultaneously.

When working with automatically generated source, code can be added to the class without having to recreate the source file. Visual Studio uses this approach when creating Windows Forms, Web Service wrapper code, and so on. You can create code that uses these classes without having to edit the file created by Visual Studio.

Benefit of partial classes:

1) More than one developer can simultaneously write the code for the class.

2) You can easily write your code (for extended functionality) for a VS.NET generated class. This will allow you to write the code of your own need without messing with the system generated code.

There are a few things that you should be careful about when writing code for partial classes:
All the partial definitions must proceeded with the key word "Partial".
All the partial types meant to be the part of same type must be defined within a same assembly and module.
Method signatures (return type, name of the method, and parameters) must be unique for the aggregated typed (which was defined partially).
The partial types must have the same accessibility.
If any part is sealed, the entire class is sealed.
If any part is abstract, the entire class is abstract.
Inheritance at any partial type applies to the entire class.

sealed class:-
We just saw how to create and use a sealed class. The main purpose of a sealed class to take away the inheritance feature from the user so they cannot derive a class from a sealed class. One of the best usage of sealed classes is when you have a class with static members. For example, the Pens and Brushes classes of the System.Drawing namespace.

The Pens class represent the pens for standard colors. This class has only static members. For example, Pens.Blue represents a pen with blue color. Similarly, the Brushes class represents standard brushes. The Brushes.Blue represents a brush with blue color.

So when you're designing your application, you may keep in mind that you have sealed classes to seal user's boundaries.

* Support for Multi-targeting
* Integrated Ajax Support
* Support for Split View
* Integrated Silverlight Support
* LINQ
* Support for inbuilt Silverlight SDK
* Support for inbuilt C++ SDK
* Support for Multilingual User Interface
* Support for Nested Master Pages
* Support for JavaScript Debugging
* Support for JavaScript Intellisense