sealed classes, 36
select clause
as extension method, 73
From...Where...Select pattern, 60–61
order of keywords, 61
query expressions, 48
query syntax, 74–75
select keyword, 141
Select method, 4, 73
Select operator, 78–79
SELECT statement, 16, 47, 156
SELECT...FOR XML AUTO statement, 90
SelectMany operator, 79–80, 90, 104
SequenceEqual operator, 114
set operators, 90–94
SetAttribute method (XmlElement), 176
SetAttributeValue method (XElement), 181
SetElementValue method (XElement), 181
SetField method, 162
setter property, 134, 138
SetValue method (XElement), 181
SharePoint, 17
Simple Object Access Protocol (SOAP), 167
Single operator, 111, 141, 149
SingleOrDefault operator, 111
Skip operator, 109
SkipWhile operator, 109
SOAP (Simple Object Access Protocol), 167
SQL (Structured Query Language).
See also LINQ to SQL
declarative programming, 12–13
LINQ query syntax vs., 97
SQLCLR, 143
SQLMetal tool
change notification, 138
creating entities from databases, 158
entity updates, 153
stored procedures, 157
SSDL (Storage Schema Definition Language), 205
static classes, 37, 39
storage considerations, 127
Storage Schema Definition Language (SSDL), 205
stored procedures
data querying, 143–145
data update, 156–157
uses for, 16
StoredProcedure attribute, 143
string type, 30
Structured Query Language. See SQL (Structured Query Language)
structures, 93
SubmitChanges method
concurrent operations, 155
database update, 8
entity update, 152, 154
transactions, 156
Sum operator, 95–97
syntax sugaring, 12
System.Collections namespace, 25
System.Collections.Generic namespace, 27
System.Linq namespace, 15, 73, 76
System.Xml classes, 9
System.Xml.Linq assembly, 170
System.Xml.Schema namespace, 193
System.Xml.XPath namespace, 194–195