AnsweredAssumed Answered

How to automate a default style when loading an SQL database?

Question asked by Grieck on Dec 31, 2013
Latest reply on Jan 6, 2014 by Hornbydd
Hello,
When I create a new personal geodatabase and load the data into ArcMap the symbols for my spatial objects are always pulled from my custom style without problem. However, when I do the same thing with an SQL database the symbols are never correct. I understand this is because the SQL layers have a fully qualified names and don't match that of the custom style. But what is the best way to approach a fix for this issue?

I would like to be able to add any SQL database to an ArcMap session and have my symbols assigned correctly to the the individual layers. Is there a way to update my custom style's layer names to match the fully qualified name of the SQL database? Is there a way to loop through the layers in the map and make sure the assigned symbol is correct and if not assign it the correct symbol from a custom style file? Any example code would be very much appreciated.

ArcGIS 10.2, C#, Windows 7, VS 2010/12
Thank You

Outcomes