public string LocateScript(string sqlQueryName, string sqlProvider)
{
Condition.Requires(sqlQueryName, "sqlQueryName").IsNotNullOrWhiteSpace();
Condition.Requires(sqlProvider, "sqlProvider").IsNotNullOrWhiteSpace();
var key = GetKeyFromProvider(sqlProvider);
var primaryResource = string.Concat("BetterMembership.Scripts.", key, ".", sqlQueryName, ".sql");
var defaultResource = string.Concat("BetterMembership.Scripts.Default.", sqlQueryName, ".sql");
string script;
if (this.TryGetResource(primaryResource, out script))
{
return script;
}
if (this.TryGetResource(defaultResource, out script))
{
return script;
}
throw new FileNotFoundException(
string.Format("{0} sql script not found for provider {1}", sqlQueryName, sqlProvider));
}