S

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