[Protein]
FROM [Categories] AS [t0]
INNER JOIN [Items] AS [t1] ON [t0].[CategoryID] = [t1].[CategoryID]
WHERE [t0].[Category] = @p0
If we expand the query that is shown for the qry variable, we can see an option to
, view the results of the query. We can see the description against the Results View
option saying Expanding the Results view will enumerate the IEnumerable. It
means that the value assigned to qry will only contain the query text. It will not have
the result of the query execution as long as it is enumerated.
This is how the result is shown when the Results View is expanded.
Stored Procedures
Similar to database and database tables, LINQ to SQL also supports stored
procedures. We can map the entity and DataContext classes to the database and
tables which give strongly typed access to the database table objects. In the same
way, LINQ to SQL also supports the feature of having methods which can be
mapped to the database stored procedure. This will give a strongly typed access
method and the IntelliSense feature to the stored procedures.
Pages:
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187