How can you avoid SQL Server Cursors or What is the alternate for SQL Server Cursors ?

You can avoid SQL Server Cursors using the following methods ,
1. Temprorary Table.
2. Comma Delimited values.

www.codecollege.NET

What is a SQL Server Replication and what are the Types ?

Replication is the process of copying or moving data between databases in the same server or external servers.
Types:
1. Sanpshot Replication
2. Transaction Replication
3. Merge Replication

www.codecollege.NET

What is a Multicast Delegate ?

It is a Delegate which points to and fires more than one method.

www.codecollege.NET

What is a Delegate?

It is a type safe function pointer. It can hold 1 or more methods in it. It is the base for The .NET Event Model.

www.codecollege.NET

What are the important extensions of LINQ ?

The following are the important extensions to LINQ:
1. LINQ to Object
2. LINQ to SQL
3. LINQ to XML
4. LINQ to DataSet

www.codecollege.NET

What is LINQ ?

LINQ (Language Integrated Query) is a set of language extensions using which you can perform query,set and tranform operations. It extends C# or VB.NET with syntax for queries and provides class libraries to use these features.

www.codecollege.NET

How will you stop a ASP.NET SQL Cache Dependency ?

SqlDependency.Stop(myconnectionstring); .

www.codecollege.NET