SQL User Defined Functions

a. Scalar UDF: It returns a scalar value with datatype such as int, nvarchar, char, datetime and money
b. Table Valued UDF i. Inline Table value returning UDF -It defined with a single SELECT statement making up the body of the function. Inline table value-returning UDFs cannot contain additional T-SQL logic outside of the SQL SELECT statement that defines the table it will return. ii. Multistatement Table value returning UDF - This UDF is used if any additional logic needs to be included in the UDF in addition to select Statment. It allows to define multiple statement inside the UDF

Side by Side Execution

Side by side execution is the ability to Run multiple version of application and multiple version of CLR runtime in a same system at same time.

What is Assembly

Assembly is the Building Block of DotNet framework(it is a component). It forms the fundamental unit of deployment. It may be or may not be executables. It contains the definition of types , versioning information, meta-data , manifest

Types
Private - It should be in the local folder of calling application/ Dll Shared - It will be placed in the GACSatellite - It contains only resources, language specfic resources

Sample for Generic Collections

Suppose if we want to store collection of integer, then we could write code something like,
ArrayList MyList = new ArrayList();
MyList.Add(1);
MyList.Add(2);

It will work good. Suppose if we add like,
MyList.Add("3");
It will compile without error. If we loop through each item and converting it to integer we will got exception thrown.

To avoid this we will go for Generic Type
ArrayList Equivalent Generic Type is List

List MyList = new List();
MyList.Add(1);
MyList.Add(2);
MyList.Add("3"); ---> this will give you complier Error

What is Application Pool

When you run IIS 6.0 in worker process isolation mode, you can separate different Web applications and Web sites into groups known as application pools. An application pool is a group of one or more URLs that are served by a worker process or set of worker processes. Any Web directory or virtual directory can be assigned to an application pool.
Every application within an application pool shares the same worker process. Because each worker process operates as a separate instance of the worker process executable, W3wp.exe, the worker process that services one application pool is separated from the worker process that services another. Each separate worker process provides a process boundary so that when an application is assigned to one application pool, problems in other application pools do not affect the application. This ensures that if a worker process fails, it does not affect the applications running in other application pools.
Use multiple application pools when you want to help ensure that applications and Web sites are confidential and secure. For example, an enterprise organization might place its human resources Web site and its finance Web site on the same server, but in different application pools. Likewise, an ISP that hosts Web sites and applications for competing companies might run each companys Web services on the same server, but in different application pools. Using different application pools to isolate applications helps prevent one customer from accessing, changing, or using confidential information from another customers site.
In HTTP.sys, an application pool is represented by a request queue, from which the user-mode worker processes that service an application pool collect the requests. Each pool can manage requests for one or more unique Web applications, which you assign to the application pool based on their URLs. Application pools, then, are essentially worker process configurations that service groups of namespaces.
Multiple application pools can operate at the same time. An application, as defined by its URL, can only be served by one application pool at any time. While one application pool is servicing a request, you cannot route the request to another application pool. However, you can assign applications to another application pool while the server is running.

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/cde42787-982a-478c-b319-e703b270d8ee.mspx?mfr=true

Scope of Memeber

a. Public Memeber - Available to all class

b. Private Memeber - Available within the class

c. Protected Memeber - Available with in the class and derived class

d. Friend Memeber - Available for all class with in the same assembly

e. Protected Friend Memeber - Available for all class with in the same assembly and derived class