Using REGEX With String Interpolation

Question

I am currently facing a challenge passing a regex query to the FromSqlRaw method in EF Core >=3.1.

The FromSqlRaw treats the query as string interpolation. I want it to ignore this and accept the query as it is.

Sample regex to test with

^.*([a-z]\\s*){3,4}([0-9]\\s*){3}([a-z]?){1}[^$].*$

Example 2

this.context.Mudal.FromSqlRaw(@"SELECT * FROM Mudal WHERE replace(BillRefNumber, ' ', '') regexp '^.*([a-z]\\s*){3,4}([0-9]\\s*){3}([a-z]?){1}[^$].*$';").ToList()

gmiley · Accepted Answer · 2020-08-11 11:46:06Z

1

You could try using parameterization to pass the regular expression. Try the following:

string regexpression = @"^.*([a-z]\\s*){3,4}([0-9]\\s*){3}([a-z]?){1}[^$].*$";
var mylist = this.context.Mudal
   .FromSqlRaw(@"SELECT * FROM Mudal WHERE replace(BillRefNumber, ' ', '') regexp {0};", 
      regexpression)
   .ToList();

edited Aug 11, 2020 at 11:46

answered Aug 11, 2020 at 11:10

gmiley

6,6041 gold badge15 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

gmiley Over a year ago

Could you add an example to your original post showing what you are currently trying?

gmiley Over a year ago

@JohnNyingi Modified the answer after update to question.

John Nyingi Over a year ago

have you tested this?

John Nyingi · Accepted Answer · 2020-08-11 12:49:57Z

0

I found an ideal answer all I have to do is change from this {1} to this {{1}}. This acts as an escape from string interpolation.

answered Aug 11, 2020 at 12:49

John Nyingi

1,1301 gold badge22 silver badges42 bronze badges

Collectives™ on Stack Overflow

Using REGEX With String Interpolation

Sample regex to test with

Example 2

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Sample regex to test with

Example 2

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related