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

Difference between Optimistic and Pessimistic locking

In Pessimistic locking when user wants to update data it locks the record and till then no one can update data. Other user’s can only view the data when there is pessimistic locking
In Optimistic locking multiple users can open the same record for updating, thus increase maximum concurrency. Record is only locked when updating the record

Difference between IN and BETWEEN, that are used inside a WHERE clause

   The BETWEEN clause is used to fetch a range of values, whereas the IN clause fetches data from a list of specified values.

Define Data Provider

A set of libraries  that is used to communicate with data source.
Eg: SQL data provider for SQL,  Oracle data provider for Oracle, OLE DB data provider for access, excel or   mysql.

New Features in ADO.NET Entity Framework 4.0

Today , we see the "New Features and Enhancements in ADO.NET Entity Framework 4.0"            ADO.NET Entity Framework 4.0 ships with Visual Studio 2010 and includes the following new features and enhancements:

1. persistence ignorance
2. lazy loading
3. self-tracking entities
4. POCO change tracking
5. model-first development
6. built-in functions and model-defined functions

SQL Server Naming conventions and Standards

Today , we will discuss about SQL Server Name Conventions and Standards

1. Table >> tbl >>tblEmployees
2. Primary Key Constraint >> PK >>PK_EmployeeId
3. Foreign Key Constraint>> FK >> FK_Employeeid
4. Unique Key Constraint>> UQ >>UQ_employee_EmailId
5. Default Constraint >> DF >> DF_Employee_IsActive
6. Check Constraint >> CHk >> CHK_Employee_DOB
7. User defined Store Procedure >> usp Eg:usp_Insert_Employee
8. User Defined Functions >> fn >> fn_CalculateAge
9. Views >> vw >> vw_OrderDetails
10. Triggers >> trg >> trg_Del_Employee
11. Indexes >> IX >>IX_EmployeeEmailId