Dhananjay Kumar

Read-Only Data in LINQ

By default CRUD operation can be performed on the retrieved data from LINQ query. We can modify the data fetched through LINQ query.

IF we do not want to modify the data then we can increase the performance by making the data as READ ONLY.

If we set ObjectTrackingEnabled as false for DataContext then framework will not track the changes done on the DataContext.

Program.cs



using System;
using System.Linq;
using System.Data.Linq;
namespace ConsoleApplication5
  {
    class Program
        {
            static void Main(string[] args)
                {
                    DataClasses1DataContext context = new DataClasses1DataContext();
                    context.ObjectTrackingEnabled = false;
                    var result = from r in context.Persons orderby r.FirstName select r;                   
                    foreach (var r in result)
                    {
                        Console.WriteLine(r.FirstName + " " + r.LastName);
                    }                   
 
                    Console.ReadKey(true);                   
 
                }
        }
}