How to get procedure name from sql script using regular expressions ?

Plain text:

public class ProcedureNameProvider : SqlObjectNameProvider { protected override string RegExPattern => @"((?!PROCEDURE).)*[\s]+PROCEDURE(\s*)(?[^\s]+)[\s]+"; public override string GetNameFromSqlScript(string sqlObjectDefinition) { Match match = new Regex(RegExPattern, RegexOptions.IgnoreCase).Match(sqlObjectDefinition); return match.Success ? NormalizeBrackets(match.Groups["proc_name"].Value) : String.Empty; } }

How to find sql procedure definition in script file using Regular expressions ?

How to show installed .NET version from cmd line in Windows ?

How to create xUnit test project in .NET Core ?

1/ Add new ClassLibrary project in .Net Core in your solution

2/ Add references to nuget libs
Fg this version

Microsoft.NET.Test.Sdk
xunit
xunit.runner.visualstudio

3/ Create simple test

4/ Run test