Way to automate setting of MergeOptions
- by Nix
I am looking for an automated way to iterate over all ObjectQueries and set the merge option to no tracking (read only context). Once i find out how to do it i will be able to generate a default read only context using a T4 template. Is this possible?
For example lets say i have these tables in my object context
SampleContext
TableA
TableB
TableC
I would have to go through and do the below.
SampleContext sc = new SampleContext();
sc.TableA.MergeOption = MergeOption.NoTracking;
sc.TableB.MergeOption = MergeOption.NoTracking;
sc.TableC.MergeOption = MergeOption.NoTracking;
I am trying to find a way to generalize this using object context.
I want to get it down to something like
foreach(var objectQuery : sc){
objectQuery.MergeOption = MergeOption.NoTracking;
}
Preferably I would like to do it using the baseclass(ObjectContext):
ObjectContext baseClass = sc as ObjectContext
var objectQueries = sc.MetadataWorkspace.GetItem("Magic Object Query Option);
But i am not sure i can even get access to the queries. Any help would be appreciated.