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);
}
}
}
Output
There are two scenarios while ObjectTrackingEnabled as false can throw exception
1. If we execute the query and after that making the ObjectTrackingEnabled as false.
Then we will get below exception
2. If we try to perform submitchanges() operation because DataContext is on readonly.
Discover more from Dhananjay Kumar
Subscribe to get the latest posts sent to your email.
Dhananjay Kumar 
One thought on “Read-Only Data in LINQ”