/// <summary>
/// Realiza a leitura do comando no recurso informado.
/// </summary>
/// <remarks>
/// O arquivo SQL deve estar na pasta Sql do projeto SqlAsFile.
/// </remarks>
/// <param name="file">O arquivo SQL.</param>
/// <returns>O comando.</returns>
public static string Read(FileSqlInfo file)
{
var assembly = file.Assembly;
var key = file.RelativeFilePath.Replace("/", ".");
if (!_cache.ContainsKey(key))
{
string resourceName;
try
{
resourceName = assembly.GetManifestResourceNames().SingleOrDefault(x => x.EndsWith(key));
}
catch (InvalidOperationException ex)
{
throw new InvalidOperationException($"There is more than a file '{file.RelativeFilePath}' on assembly '{assembly.GetName().Name}'. Use the folder path when instancianting a SQL file to specify the right file.", ex);
}
if (resourceName == null)
{
throw new InvalidOperationException($"Could not find a file on location '{file.RelativeFilePath}'.");
}
using (var stream = assembly.GetManifestResourceStream(resourceName))
using (var reader = new StreamReader(stream))
{
_cache.TryAdd(key, reader.ReadToEnd());
}
}
return(_cache[key]);
}
public static Tuple <string, string> Parse(FileSqlInfo file)
{
var content = SqlResourceReader.Read(file);
return(new Tuple <string, string>(
ParseCte(content),
ParseComand(content)));
}
