31 January 2014

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

30 January 2014

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
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

29 January 2014

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