Latest Contributions by ericliprandi

Hi, I am trying to filter an IEnumLayer to only contain visible layers. I want to pass this to IFeatureCache2.AddLayers(...). I could not find any public implementations of IEnumLayer. Since we are in C# I wrote a couple of extension methods that convert IEnumLayer to IEnumerable<ILayer> and vice-versa. But passing my custom implementation of IEnumLayer did not seem to make AddLayers(...) happy. Here is my extensions class:     public static class EnumLayerExtensions     {         public static IEnumerable<ILayer> AsEnumerable(this IEnumLayer layers)         {             layers.Reset();             var layer = layers.Next();             while (layer != null)             {                 yield return layer;                 layer = layers.Next();             }         }         public static IEnumLayer ToEnumLayer(this IEnumerable<ILayer> layers)         {             return new EnumLayerWrapper(layers);         }         private class EnumLayerWrapper : IEnumLayer         {             private readonly ILayer[] _layers;             private int _index;             public EnumLayerWrapper(IEnumerable<ILayer> layers)             {                 _layers = layers.ToArray();                 _index = 0;             }             public ILayer Next()             {                 return _index < _layers.Length ? _layers[_index++] : null;             }             public void Reset()             {                 _index = 0;             }         }     } using this I can then write the following code: var visibleLayers = Map.Layers.AsEnumerable().Where(l=>l.Visible); var cache = new FeatureCacheClass() as IFeatureCache2; cache.Initialize(point,radius); cache.AddLayers(visibleLayers.ToEnumLayer(), null); In the above code, line 04 will just run for ever as-is. If I use the layers straight from the Map, it comes back fairly fast. I have written a handful of unit tests to validate my implementation of ToEnumLayer() and they all seem to pass. Based on all this, I have a couple of questions: Is there an out of the box implementation of IEnumLayer that I can use to filter visible layers only to pass to IFeatureCache2.AddLayers()? What's wrong with my implementation of IEnumLayer? Thanks in advance for any help, Eric. ... View more

Hi, We are an ISV and recently built an application that, among other things, allows you to search your features, using the simple MapServer/Query option (documented here). All we do is pass in the text parameter and let Esri do the work. It works great on SQL Server as it performs a case insensitive search of the display field (we haven't verified, but we assume this follows the SQL Server configuration of collation). However, I am at a loss to try to get it to query an Oracle backend and ignore the case of the search text. Yes, we might have to convert to using the WHERE clause instead, but as an ISV, this seems to be wrong choice as we might have to build different WHERE clauses depending on the RDBMS backend (or is UPPER('field name') LIKE UPPER('%term%') truly universal - at least SQL Server and Oracle?) So, is there a simple way to have this MapServer/Query with text be case insensitive in Oracle? I have tried setting environment variables NLS_COMP and NLS_SORT to LINGUISTIC on the ArcGIS Server (Windows) but even after a full restart, it doesn't seem to have taken them. I also tried setting NLS_COMP and NLS_SORT values in the registry key HKLM\SOFTWARE\ORACLE\KEY_OraClient11g_home1, but no luck there either. Our environments would be: ArcGIS 10.2 - Windows Oracle 11g - Windows or SQL Server 2012 and up Thanks in advance for any help. ... View more