public static string GetTextResource(string resourceName) { string result = string.Empty; if (string.IsNullOrEmpty(resourceName)) { return(result); } resourceName = $"{resourceName}.sql"; var fullMatchingResourceNames = ResourceNames.Where(name => name.EndsWith(resourceName)); if (fullMatchingResourceNames.Count() == 0) { throw new ArgumentException(); } if (fullMatchingResourceNames.Count() > 1) { throw new AmbiguousMatchException(); } using (Stream stream = DataAssembly.GetManifestResourceStream(fullMatchingResourceNames.First())) { using (StreamReader reader = new StreamReader(stream)) { result = reader.ReadToEnd(); } } return(result); }
static SqlTextResourceHelper() { DataAssembly = typeof(SqlTextResourceHelper).Assembly; ResourceNames = DataAssembly.GetManifestResourceNames(); }