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