I have the following SQL sample statement in a string variable
INSERT INTO T_Application
(
ApplicationGroupId,
Name,
Component,
SubComponent,
Description
)
VALUES
(
@ApplicationGroupId,
@Name,
@Component,
@SubComponent,
@Description
)
SET @Id = SCOPE_IDENTITY()
What I want is to have all Parameter names (Id, ApplicationGroupId, Name, Component, SubComponent, Description) in a List<string>
.
How can I write the RegEx to extract all Parameters Names? The RegEx should also work if the Parameters are in one line, spaces between ,
etc.
Regex.Matches(sql, @"\@\w+").Cast<Match>().Select(m => m.Value).ToList ();
Resulting List:
@ApplicationGroupId
@Name
@Component
@SubComponent
@Description
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With