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.

Dynamic vs Anonymous types

S.No	Dynamic	Anonymous types
1	Dynamic types work at run time by late binding of object properties.	Anonymous types cause the compile time errors.
2	Dynamic Keyword	Var Keyword

Write the basic steps to execute a LINQ query.

The following are the three basic steps to execute a LINQ query:
Obtain the data source (The data source can be either an SQL database or an XML file)
Create a query
Execute the query

Define PLINQ

PLINQ stands for Parallel Language Integrated Query. It is the parallel implementation of LINQ, in which a query can be executed by using multiple processors. PLINQ ensures the scalability of software on parallel processors in the execution environment. It is used where data grows rapidly, such as in telecom industry or where data is heterogeneous.

Features in ADO.Net 2.0

Today, we will see the "ADO.Net 2.0 Features"

  ADO.Net 2.0 Features are

1. Bulk Copy Operation
2. Batch Update
3. Data Paging
4. Connection Details
5. DataSet.RemotingFormat Property
6. DataTable's Load and Save Methods
7. New Data Controls
8. DbProvidersFactories Class
9. Customized Data Provider
10. DataReader's New Execute Methods