Database

DECLARE @SQL nvarchar(max) = N'';

SELECT
    @SQL = @SQL + N', ' + QUOTENAME(name) + N' = @value'
FROM
    sys.columns
WHERE
    object_id = OBJECT_ID('Record')
And
    name Like '%_edit'
;

SET @SQL = Substring(@SQL, 3, LEN(@SQL) - 2);
SET @SQL = N'UPDATE Record SET ' + @SQL;

PRINT @SQL;

EXEC sp_executesql @statement = @SQL, 
    @params = N'@value varchar(10)', -- TODO: Use the correct data type and size here
    @value = 'XXX';

public partial class MyEntities : DbContext
{
    public MyEntities() : base("name=MyEntities")
    {
    }
    
    public MyEntities(string nameOrConnectionString) : base(nameOrConnectionString)
    {
    }
    
    public MyEntities(DbConnection existingConnection, bool contextOwnsConnection) : base(existingConnection, contextOwnsConnection)
    {
    }