The Weird and The Wonderful

Eddy Vluggen wrote:

Access?

• A view cannot insert, update, or delete any records. It can only select records.
• A view can select from a table-valued function, but a TVF cannot insert, update, or delete records. Neither can it call a stored procedure, or use temporary tables.
• You can't create a trigger that would fire when records are selected from a table or view. And you can't create triggers on TVFs at all.

Richard Deeming wrote:

A view cannot insert, update, or delete any records. It can only select records.

MSDN wrote:

You can modify the data of an underlying base table through a view, as long as the following conditions are true:
Any modifications, including UPDATE, INSERT, and DELETE statements, must reference columns from only one base table.
The columns being modified in the view must directly reference the underlying data in the table columns. The columns cannot be derived in any other way, such as through the following:
An aggregate function: AVG, COUNT, SUM, MIN, MAX, GROUPING, STDEV, STDEVP, VAR, and VARP.
A computation. The column cannot be computed from an expression that uses other columns. Columns that are formed by using the set operators UNION, UNION ALL, CROSSJOIN, EXCEPT, and INTERSECT amount to a computation and are also not updatable.
The columns being modified are not affected by GROUP BY, HAVING, or DISTINCT clauses.
TOP is not used anywhere in the select_statement of the view together with the WITH CHECK OPTION clause.

Piebald wrote:

in this case I'm "just reading" from the view, but apparently something (a function or who knows what) is making changes.

function checkIfValid() {
  var isValid = false;
  if (doSomeOtherCheck()) {
    isValid = true;
  }

  ...

  if (isValid == true) {
    return true;
  } else {
    return false;
  }
}

return !!isValid;

ISomething something = listOfSomethings.Where(...).OrderBy(...).FirstOrDefault();
if (something != null)
{
    return something;
}
else
{
    return default(ISomething);
}

F-ES Sitecore wrote:

The FirstOrDefault is going to return default(ISomething)

interface ISomething { }
struct Something : ISomething { }

var listOfSomethings = new List<Something>();
ISomething result = listOfSomethings.FirstOrDefault();
Console.WriteLine(result == null); // False