Job offersCompaniesTestsBlogI'm an employerSign upLog in
Home>IT Tests>Questions>Write a LINQ query to select all rows from the first table in the dataset where the ContactName field is not null.

Question from the Entity Framework test

Write a LINQ query to select all rows from the first table in the dataset where the ContactName field is not null.

Hard

You are using Visual Studio 2010 and the .NET Framework 4 to create an application. The application connects to a SQL Server database. You use the following SQL statement to retrieve an instance of a DataSet called ds: SELECT CustomerID, CompanyName, ContactName, Address, City FROM dbo.Customers.

You need to query the DataSet to retrieve only the rows that have the ContactName field not null. What code segment should you use?

Author: Guillaume BroutStatus: PublishedQuestion passed 187 times
Edit
0
Community EvaluationsNo one has reviewed this question yet, be the first!
Similar Questions
More questions about Dot-net
1
Retrieve a list of products from a catalog in a .NET application
1
How to get the first element of an array in C#
1
How to use the 'using' statement in C#
0
How to get the first row of a SqlDataReader in C#
0
How to get the products of a category in Dot-net