private void LoadSynonyms(SqlCommand cm) { try { // get synonyms cm.CommandText = @" select object_schema_name(object_id) as schema_name, name as synonym_name, base_object_name from sys.synonyms"; using (var dr = cm.ExecuteReader()) { while (dr.Read()) { var synonym = new Synonym((string) dr["synonym_name"], (string) dr["schema_name"]); synonym.BaseObjectName = (string) dr["base_object_name"]; Synonyms.Add(synonym); } } } catch (SqlException) { // SQL server version doesn't support synonyms, nothing to do here } }
private static string MakeFileName(Synonym s) { return MakeFileName(s.Schema, s.Name); }