Jan 30, 2017 · The ability in SQL Server to designate a Primary Key as nonclustered is an unfortunate historical circumstance, due to a conflation of the meaning "preferred natural or candidate key" (from the Logical Model) with the meaning "lookup key in storage" from the Physical Model.

If the person does not have a title, this will throw an exception because it is trying to call ToUpper on a property with a null value. In C# 5 and below, this can be guarded with: var title = person.Title == null ? null : person.Title.ToUpper(); Now the title …