0

I have a data table with several xml fields. I'm using EF to get the data using where:

List<tblMSASAN> msa = ctx.tblMSASANs.Where(s => s.LCMGSupportLevel != "decommissioned").ToList();

Then using a foreach to iterate the list and pulling the xml field into an xmldocument and querying each node updating an attribute, then saving the context.

However, the dataset is too large and I get an out of memory exception. So I need to be able to query the xml first to return a smaller dataset.

List<tblWinServer> servers = ctx.tblWinServers.AsNoTracking().Where(s => s.LCMGSupportLevel != "decommissioned" && ( Convert.ToString(s.TapeDrives).Contains("Calyx") ||Convert.ToString(s.DiskShelves).Contains("Calyx"))).ToList();

But this doesn't work with a NotSupportedException.

Any ideas?

Ani
  • 2,636
  • 1
  • 21
  • 17
R Davies
  • 105
  • 1
  • 11
  • possible duplicate of [LINQ to Entities does not recognize the method 'System.String ToString()' method, - MVC4](http://stackoverflow.com/questions/18233495/linq-to-entities-does-not-recognize-the-method-system-string-tostring-method). – Gert Arnold May 01 '14 at 12:02

1 Answers1

-1

AsNoTracking() method returns IQueryable but if you want to use ToString() method in Where clause you have to convert IQueryable to IEnumerable:

List<tblWinServer> servers = ctx.tblWinServers.AsNoTracking().AsEnumerable().Where(s => s.LCMGSupportLevel != "decommissioned" && ( Convert.ToString(s.TapeDrives).Contains("Calyx") ||Convert.ToString(s.DiskShelves).Contains("Calyx"))).ToList();
user2250152
  • 14,658
  • 4
  • 33
  • 57