Advertisement
marcinch

Untitled

Apr 22nd, 2021
1,272
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.46 KB | None | 0 0
  1. public class ProcedureNameProvider : SqlObjectNameProvider
  2. {
  3.     protected override string RegExPattern => @"((?!PROCEDURE).)*[\s]+PROCEDURE(\s*)(?<proc_name>[^\s]+)[\s]+";
  4.  
  5.     public override string GetNameFromSqlScript(string sqlObjectDefinition)
  6.     {
  7.         Match match = new Regex(RegExPattern, RegexOptions.IgnoreCase).Match(sqlObjectDefinition);
  8.         return match.Success ? NormalizeBrackets(match.Groups["proc_name"].Value) : String.Empty;
  9.     }
  10. }
  11.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement