LINQ query with multiple comparators.

[ymee445]

OK so instead of trying to describe my problem with little success I'll show you what I'd like to translate into LINQ. Here goes:

for (int i = 0; i < ExtractionProtocol.Length; i++)
{

command.CommandText = "UPDATE dbo.[Parameters] SET Value ='" + ExtractionProtocol.Value + "'WHERE Enum = '" + Convert.ToInt16(ExtractionProtocol.EnumValue) + "'";
command.ExecuteNonQuery();
​

}

Is there an easy way to create a LINQ query for this? Even if the query is simple to write, what kind of performance/efficiency will I be getting? Thank you in advance!

--
Julian

 

[ymee445]

Ohh and for a data context any generic variable will work. Let's say its:

GenericDataContext dc = new GenericDataContext();

 

[ymee445]

/bump I'm still stuck on it