ADO.NET Interview Questions and Answers (445) - Page 8

Latest and authentic Interview questions. You can also post an interview question and win monthly prizes as well as gain community credit points.

445 records found.

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Get 650+ Questpond's Interview videos on discount

When working with LINQ to SQL, what is the main object that moves data to and from the database?

NOTE: This is objective type question, Please click question title for correct answer.

In the Entity Framework, which is the primary object that you use to query and modify data?

NOTE: This is objective type question, Please click question title for correct answer.

You want to use LINQ to SQL to run queries on a table that contains a column that stores large photos. Most of the time, you won't need to view the photo, but occasionally you will need to see it. In the LINQ to SQL designer, which property can you set on the photo column to get the efficient loading of the data for most scenarios but still be able to retrieve the photo when needed?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following keywords is used to implement eager loading of data when executing a query?

NOTE: This is objective type question, Please click question title for correct answer.

Which class should you use to manage multiple tables and relationships between them?

NOTE: This is objective type question, Please click question title for correct answer.

You retrieved a row of data into an entity object by using a LINQ to SQL DataContext object. You haven't made any changes to the object, but you know that someone else has modified the data row in the database table, so you rerun your query, using the same DataContext object, to retrieve the updated data. What can be said about the result of the second query?

NOTE: This is objective type question, Please click question title for correct answer.

You want to configure WCF data service to allow only a single row lookup from the Customers entities and not allow queries that return all entities from Customers. How can you configure the WCF data service?

NOTE: This is objective type question, Please click question title for correct answer.

You are writing a WCF data service that will be included in a large project that has many other WCF data services. Your WCF data service will provide access to a SQL server using the EF. The EDMX file already exists in the project and is used by other services. One of the tables exposed by your service is the Contacts table, which contains the list of employees and the list of external contacts, which are denoted by the IsEmployee column that can be set to 1 or 0. You want to configure your WCF data service to return the external contacts whenever someone queries the Contacts entity set through WCF Data Services. What is the best way to solve this problem?

NOTE: This is objective type question, Please click question title for correct answer.

Which payload formats can be specified if you are making an AJAX call to a WCF data service?

NOTE: This is objective type question, Please click question title for correct answer.

You are going to execute a Select command to SQL Server that returns several rows of customer data. You don't need a data table to hold the data because you will simply loop over the returned results to build a string of information that will be displayed to the user. You create and open a connection and then create the command and set its properties. Which method on the command will you execute to retrieve the results?

NOTE: This is objective type question, Please click question title for correct answer.

To which of the following types can you add an extension method?

NOTE: This is objective type question, Please click question title for correct answer.

You want to page through an element sequence, displaying ten elements at a time, until you reach the end of the sequence.Which query extension method can you use to accomplish this task ?

NOTE: This is objective type question, Please click question title for correct answer.

You have executed the Where query extension method on your collection, and it returned IEnumerable of Car, but you want to assign this to a variable whose type is List Of Car. How can you convert the IEnumerable of Car to List Of Car?

NOTE: This is objective type question, Please click question title for correct answer.

Given the following LINQ query: from c in cars join r in repairs on c.VIN equals r.VIN ... What kind of join does this perform?

NOTE: This is objective type question, Please click question title for correct answer.

In a LINQ query that starts with: from o in orderItems The orderItems collection is a collection of OrderItem with properties called UnitPrice, Discount, and Quantity. You want the query to filter out OrderItem objects whose totalPrice (UnitPrice * Quantity * Discount) result is less than 100. You want to sort by totalPrice, and you want to include the total price in your select clause. Which keyword can you use to create a totalPrice result within the LINQ query so you don't have to repeat the formula three times?

NOTE: This is objective type question, Please click question title for correct answer.

Which query extension methods can you use to implement paging over a LINQ to SQL query?

NOTE: This is objective type question, Please click question title for correct answer.

When using a LINQ query to join two tables, you must specify how the two tables are related by using which keyword?

NOTE: This is objective type question, Please click question title for correct answer.

How can you get the ColumnName, DataType ColumnSize, IsKeyColumn, IsAutoIncrement of the table from the dataset?

NOTE: This is objective type question, Please click question title for correct answer.

You are writing an Entity SQL query that requires you to construct a row from various data.Which function will you use to construct the row?

NOTE: This is objective type question, Please click question title for correct answer.

If you want to assign a Car object to a column called CarObject, which attribute must be on the Car class to enable saving the data table to a file?

NOTE: This is objective type question, Please click question title for correct answer.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
...
23

More ADO.NET Exclusive Interview Questions & Answers here

Found this useful, bookmark this page to the blog or social networking websites.

GooglePlus

StumbleUpon

Delicious

Reddit

Email

Bookmark It

Interview Questions and Answers Categories

.NET Certifications

ASP.NET Web API

Data Structures & Algorithms

Design Pattern & Practices

DotNetFunda.Com

Entity Framework

Error and Solution

Function Points (FPA)

Interview Questions

Mobile Development

MSBI (SSIS, SSRS, SSAS)

News and Community

Product Reviews

Project Management

Regular Expressions

Web Services, Remoting

Winners

Winners & Prizes

Ads

Social

Like us on Facebook

Top Interviews Authors

Sun, 07-Mar-2021 Authors

All Time Authors

vishalneeraj-24503

Rajkatie

Bharathi Cherukuri

Latest members | More ...

(Statistics delayed by 5 minutes)

Advertisements