.Net Interview Questions, Resources, Tips & Tricks.

Most efficient way to query nodes in XML is to use XQuery methods like .value, .nodes, .query and .exists methods

For Examples, check below articles.
http://www.dotnetthread.com/articles/8-Querying-from-XML-datatype-table-column-in-SQL-Server.aspx

DECLARE @EmpID VARCHAR(8000)
SET @EmpID = '''Emp1'',''Emp2'''

Select * from emp
where empid in(@empid) - This doesnt work...

For solution check the below URL.
http://www.dotnetthread.com/tips/25-Using-variable-in-SQL-IN-statement.aspx

Parallel Computing in .NET 4.0 – Task Parallel Library & PLINQ
on Dec 05, 2010 by Anil Kumar Reddy Perugu
.NET 4 introduces various parallel-programming primitives that abstract away some of the messy details that developers have to deal with when implementing parallel programs from scratch.

Parallel Computing in .NET 4.0 - Concurrent Collections
on Jan 14, 2011 by Anil Kumar Reddy Perugu
When working on Multi Threaded programs the most important point is to make sure that object that is accessed by multiple threads and operations performed on the object are thread safe. If not we need to protect the object with proper locks to avoid incorrect results and exceptions.

Parallel Computing in .NET 4.0 - Parallel LINQ
on Jan 14, 2011 by Anil Kumar Reddy Perugu
.NET Framework 4.0 introduces Parallel Task Library and Parallel LINQ to Objects. This article is the continuation of Parallel Computing in .NET 4.0 – Task Parallel Library & PLINQ.

Agile: Software Development
on Dec 05, 2010 by Anil Kumar Reddy Perugu
This artcle discuss about agile software development and its advantages.

Have a look at WebMatrix a new IDE for Web Development. (Simplifies Web development)
http://www.microsoft.com/web/webmatrix

Introduction and First application.
http://weblogs.asp.net/scottgu/archive/2010/07/06/introducing-webmatrix.aspx

Simple IDE for website development uses inbuilt lightweight file based database and the new cshtml is amazing (similar to Coldfusion).
- SQL Server Compact Edition
- Cshtml (ASP.NET Razor)
- IIS Express with all required developer features.
- Web Server
- Open source application gallery (Web Apps)

1. SR Software Development Engineer

SQL 2005/2008
.NET Framework 3.5/4.0
ASP.NET/ASP/C#
WCF/WPF/WF/Silverlight
SharePoint 2007/2010


Apply Now: http://www.jobthread.com/jt/jobs/widget_click.php?id=85794d&job_id=541131

2. Software Development Engineer (SDE)

and formulate recommendations clearly. Technical horsepower and critical thinking are required.
6+ years of software development experience with C#, Silverlight, .Net programming, WCF Web services , SQL and VSTF 2008\2010.

Apply Now: http://www.jobthread.com/jt/jobs/widget_click.php?id=85794d&job_id=541135

Method hiding is to hide/mask method in base class by creating a similar function in derived class and by using new keyword in the derived class.
Unlike Method overriding, When we refer base class object created by casting derived class object a method in base class will be called.
Also we can change the return type while masking the base class method.
Using new keyword is not compulsory, however a warning will be displayed if we wont specify new keyword while masking.


Example:

Base Class:
--------------
public class BaseClass
{
public virtual void Method1()
{
Print("Base Class Method");
}
}

Derived class
---------------
public class DerivedClass: BaseClass
{
public override void Method1()
{
Print("Derived Class Method");
}
}

Usage
-------------------
public class Sample
{
public void TestMethod()
{
DerivedClass objDC = new DerivedClass();
objDC.Method1();
BaseClass objBC = (BaseClass)objDC;
objDC.Method1();
}
}
Result
-----------------------------------
Derived Class Method
Base Class Method