Right some interesting yet puzzeling info. While trying your
suggestion I found that if I moved the expression code out of a helper
class into the class executing the loop. Let me explain with the
example below eg 1. When run like this the caching does not appear to
work and the Expression is built each time, however if I move the code
in MyHelperClass.Execute into MyMasterClass at the position marked by
##### caching appears to work. Any ideas? I can't see what is
different.
In fact it only appears to work if the looping and expression build/
execution are in the same method/place like eg 2.
Hope that makes sense and helps.
James
eg 1
class MyMasterClass{
private Linq SchemaModel;
public MyMasterClass(Linq model){
SchemaModel = model;
}
public LoadData(){
MyHelperClass helper = new MyHelperClass(SchemaModel)
List<string> myStrings = new List<string>();
myStrings.Add("AZP1B");
myStrings.Add("AZP1C");
myStrings.Add("AZP1D");
myStrings.Add("AZP2B");
myStrings.Add("AZP2C");
myStrings.Add("AZP2D");
myStrings.Add("AZP3B");
myStrings.Add("AZP3C");
myStrings.Add("AZP3D");
foreach(string s in mystrings){
List<WarehouseStation> mystations = helper.Execute(s);
//######
foreach(Station station in mystations){
Console.Out.WriteLine(station.Id);
}
}
}
}
public class MyHelperClass{
private Linq HelperSchemaModel;
public MyHelperClass(Linq model){
HelperSchemaModel = model;
}
public List<WarehouseStation> Execute(string s){
var stations = from station in SchemaModel.Station where
station.AisleID == s select station;
List<WarehouseStation> allWarehouseStations = new
List<WarehouseStation>();
foreach (var s in stations)
{
WarehouseStation warehouseStation = new
WarehouseStation(s.StationID, s.XCooRd.Value);
allWarehouseStations.Add(warehouseStation);
}
return allWarehouseStations;
}
}
eg 2
foreach (string s in ss)
{
var tmp = from tmptbl in SchemaModel.Station where
tmptbl.AisleID == s select tmptbl;
foreach (var a in tmp)
{
Console.Out.WriteLine(a.AisleID + " - " +
a.StationID + " - " + a.XCooRd);
}
}
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en
-~----------~----~----~----~------~----~------~--~---
