Update Statement in (SQL and LINQ) and Syntax

The update statement is used to update or change records that match a specified criteria. This is accomplished by carefully constructing a where clause.

Syntax SQL :

UPDATE tablename
SET columnname = '000newvalue'

WHERE columnname= Teatvalue"  AND | OR  columnname=testvalue

Syntax LINQ : -