Introduction:
In this article,i am going to explain about how to use PLINQ to parallelize declarative data access in asp.net linq application.

Main:
What is plinq?
plinq is nothing but spliting the normal linq process into several partitions,and then using tasks to retrieve the data that
matches the criteria specified by the query for each partition in parallel. The results retrieved for each partition are
combined into a single enumerable result set when the tasks have completed. PLINQ is ideal for scenarios that involve data
sets with large numbers of elements, or if the criteria specified for matching data involve complex, expensive operations.

For achieve this,we has a enumerable method named AsParellel(),pling is especially helps us to improve linq application
performance,

See the below simple ex,create one console application,and try the below codes,you can felt the performance is quite better while using AsParallel() method,

Without AsParallel(),

using System; using System.Collections.Generic; using System.Linq; using System.Text;   namespace plingdemo { class Program { static void Main(string[] args) { DataClasses1DataContext sqlcontext = new DataClasses1DataContext();   //normal linq try { var Emps = from p in sqlcontext.Emps join x in sqlcontext.depts on p.Deptid equals x.dept_id select p;   Console.WriteLine(Emps); Console.ReadLine(); } catch (Exception ex) { Console.WriteLine(ex.Message); }           } } }

With Parallel,

using System; using System.Collections.Generic; using System.Linq; using System.Text;   namespace plingdemo { class Program { static void Main(string[] args) { DataClasses1DataContext sqlcontext = new DataClasses1DataContext();   //normal linq try { var Emps = from p in sqlcontext.Emps.AsParallel() join x in sqlcontext.depts.AsParallel() on p.Deptid equals x.dept_id select p;   Console.WriteLine(Emps); Console.ReadLine(); } catch (Exception ex) { Console.WriteLine(ex.Message); }           } } }

We will do the enhancemens in pling in next article,

Conclusion:
Hope this helps,
Happy Coding.