Difference between the Take and Skip clauses

               The Take clause returns a specified number of elements. For example, you can use the Take clause to return two values from an array of numbers. The Skip clause skips the specified number of elements in the query and returns the rest. For example, you can use the Skip clause to skip the first four strings in an array of strings and return the remaining array of string.

Define use of SqlCommandBuilder

           SQL CommandBuilder object is used to build & execute SQL (DML) queries like select insert update& delete.

Implement inheritance using VB.NET & C#

• C# Derived Class : Baseclass
• VB.NEt : Derived Class Inherits Baseclass

Union Used to remove duplicate rows

How many times should a Union be used to Remove duplicate rows
   One Time

Difference between WindowsDefaultLocation and WindowsDefaultBounds

• WindowsDefaultLocation tells the form to start up at a location selected by OS, but with internally specified size. 
• WindowsDefaultBounds delegates both size and starting position choices to the OS. 

Create a separator in the Menu Designer

A hyphen ‘-’ would do it. Also, an ampersand ‘&’ would underline the next letter. 

Allow and Disallow insert into identity field

Set IDENTITY_INSERT ON|OFF.

Example(s)
 Allow insert into identity field:

Set IDENTITY_INSERT tbk=l_Customer_Master ON

DisAllow insert into identity field:

Set IDENTITY_INSERT tbk=l_Customer_Master OFF

Define DataContext

• To communicate with a Database a connection must be made. In LINQ this connection is created by a DataContext.
• Create connection to database.
• It submits and retrieves object to database.
• Converts objects to SQL queries and vice versa.

Entity Framework Features

• EF 3.5 Basic O/RM support with Database First approach.
• EF 4.0 POCO Support, Lazy loading, testability improvements, customizable code generation and the Model First approach.
• EF 4.1 First to available of NuGet package, Simplified DBContext API over ObjectContext, Code First approach. EF 4.1.1 patch released with bug fixing of 4.1.
• EF 4.3 Code First Migrations feature that allows a database created by Code First to be incrementally changed as your Code First model evolves. EF 4.3.1 patch released with bug fixing of EF 4.3.
• EF 5.0 - Current release Announced EF as Open Source. Introduced Enum support, table-valued functions, spatial data types, multiple-diagrams per model, coloring of shapes on the design surface and batch import of stored procedures, EF Power Tools and various performance improvements.
• EF 6.0 - Future release EF 6.0 is currently in pre-release state. It will include Task-based async, Stored Procedures & Functions in Code First and Custom Code First conventions.

LINQ Vs DLINQ Vs XLINQ

S.No	LINQ	DLINQ	XLINQ
1	programming model that introduces queries as a first-class concept into any Microsoft .NET language	an extension to Linq that allows querying a database and do object-relational mapping.	an extension to Linq that allows querying XML documents, as well as creating or transforming XML.