DRAG DROP
Exhibit:
ee.SELECT EmployeeID, Name, Region, Country FROM dbo.Employees .
There is a MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
A SQL statement is used to retrieve dataset instance (see exhibit).
You need to use this dataset to access rows where the Name field is not null.
Which code should you use?
You need to use this dataset to access rows where the Name field is not null.
DRAG DROP
Exhibit:
ee.SELECT EmployeeID, Name, Region, Country FROM dbo.Employees .
There is a MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server 2008 database PassGuideDB.
A SQL statement is used to retrieve dataset instance (see exhibit).
You need to use this dataset to access rows where the Name field is not null.
Which code should you use?
The specified answer is correct. I tested it using a Visual Studio project.
row.Field(“Name”) will return null, if name is null
The final box is wrong. It should be:
select row
not
return row.
The C# uses:
from-where-select clause
not
from-where-return clause
Source:
https://msdn.microsoft.com/en-us/library/bb383978.aspx