Updating SQL database values based on REGEX matching

SixSixTrample · November 2012

I'm attempting to filter results based on a matching regex, then update those results.

Something like


var list = from p in Products
select p;

var test = list.AsEnumerable();
Regex r = new Regex(@"^[0-9]nd");

foreach(var l in test)
{
	if(r.IsMatch(l.FIELD_NAME))
	{
		l.FIELD_NAME = Regex.Replace(l.FIELD_NAME,r.ToString(),"Alt");
		Console.WriteLine(l.FIELD_NAME);
                //this works correctly, it outputs the field name replacing correctly
	}
}

test.Dump(); //this doesn't work, the values aren't changed here

It also won't work if I iterate on list and use SubmitChanges();

I know that you can't do a regex match with a SQL query, but is there anyway to do this?

SixSixTrample · November 2012

It turns out you should refresh the table in LINQPad after you re-create it with a primary key.

This actually works exactly as it should:

foreach(SPEC l in list)
{
	if(r.IsMatch(l.FIELD_NAME))
	{
		l.FIELD_NAME = Regex.Replace(l.FIELD_NAME,r.ToString(),"Alt");
		Console.WriteLine(l.FIELD_NAME);
	}

	//l.FIELD_NAME = l.FIELD_NAME + "*";
	
}

SubmitChanges();

Updating SQL database values based on REGEX matching

Comments