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);
}
