Converting Sql query (update table set ....) to linq ( var m = ...)

See more:

SQL

LINQ

Hi!

I am trying to write a linq query in my Database.cs file. I find it difficult. Is there any tool to convert sql to linq? I tried linqer but it is no good. Or could you help me in writing the following query in linq.

update table set field1='R', field2='" + DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss") + "', field3 = '" + util.CleanStringInput(value1) + "' where field1 = 'P' and field3 = '" + value2 + "' and field4 = (select max(field5) from table2 where field6='" + value2 + "')

Thank you