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

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

You are implementing an application that uses POCO objects with Entity Framework. You need to ensure that proxies are created when you create entity objects. What should you do?

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

You are implementing a repository method with LINQ to SQL. The method will return a Customer instance with a given identifier. The Customer class includes an Orders property that gives related Order instances. You need to ensure that orders given by the Orders property are retrieved when the Customer instance is retrieved. What should you do?

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

You use the Entity Data Model Wizard to generate an Entity Data Model from an application database. A Customer entity includes an Orders property that gives related Order instances. You need to ensure that orders given by the Orders property are retrieved when the Customer entity is retrieved. What should you do?

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

You are implementing a repository method with LINQ to SQL. The method will return a Customer instance with a given identifier. The Customer class includes an Orders property that gives related Order instances. You need to ensure that current orders given by the Orders property are retrieved when the Customer instance is retrieved. Current orders are defined as those that have a Status property value of Current. What should you do?

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

You are implementing an application that uses LINQ to SQL. You load an Order entity by querying the Orders property of a strongly typed DataContext. After you modify the Order entity, you need to retrieve an instance with properties reset to the values in the database. What should you do?

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

You are implementing an application that uses Entity Framework. You load an Order entity by querying the Orders property of a strongly typed ObjectContext. After you modify the Order entity, you need to retrieve an instance with properties reset to the values in the database. What should you do?

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

You are implementing an application that uses Entity Framework. You load an Order entity by querying the Orders property of a strongly typed ObjectContext. After you modify the Order entity, you need to compare a current property value with the cached original property value. What should you do?

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

You use a SqlCommand command to execute the following stored procedure: CREATE PROCEDURE dbo.GetCustomerCount AS SELECT COUNT(*) FROM Customers You need to retrieve the result of this SELECT statement. What should you do?

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

You create a DbCommand to execute a query. You need to retrieve a DbDataReader that you can use to access the result set. Which DbCommand method should you use?

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

You use a DbDataReader to access a single result set. As you iterate through the result set, you need to check whether you have read all the rows in the result set. What should you do?

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

You create a DbCommand to execute a query that returns multiple result sets. You need to iterate through each row of each result set. What should you do?

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

You create a DbCommand to execute a query. You need to populate a DataSet with the result set returned by this DbCommand. What should you do?

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

You use a DbDataAdapter to populate a DataTable. You need to ensure that when the DbDataAdapter loads the DataTable, it sets the DataColumn.MaxLength and DataColumn.ReadOnly properties to correspond to data source-defined constraints. What should you do?

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

Your Microsoft SQL Server database includes the stored procedures GetAllOrders, GetAllCompletedOrders, and GetAllOpenOrders. These stored procedures return result sets that adhere to the same schema. You need to choose a type to execute these stored procedures and fill a strongly typed DataSet. The type also must group the calls to these queries. Which type should you use?

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

Your application includes an existing typed TableAdapter that executes a single query. You need to design a new query to add to this TableAdapter. What should you do?

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

You need to rewrite the following code to use a SqlParameter: SqlConnection conn = new SqlConnection("Persist Security Info=False;"+ "Integrated Security=SSPI;database=northwind;server=dataServer"); string commandText = string.Format("SELECT * FROM Customers WHERE LastName='{0}'", txtBoxLastName.Text); SqlCommand cmd = new SqlCommand(commandText, conn); Which code segment should you use?

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

You use a DbDataReader named reader to access the result set returned from the following query: SELECT ProductID, ProductName, Discontinued FROM Products You need to retrieve the value of the bit type column Discontinued. Which code segment should you use?

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

You are implementing a WCF Data Service to expose data from a database named Northwind. You create a class named NorthwindDataService that extends DataService. You need to configure rights on entity sets and service operations. How should you modify NorthwindDataService?

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

You are implementing a WCF Data Service to expose data from a database named Northwind. You create a class named NorthwindDataService that extends DataService. You add the following method: public static void InitializeService(IDataServiceConfiguration config) { } You need to ensure that client applications can read Customers entities and cannot access Products and Orders entities. Which code segment should you add to the InitializeService method?

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

You are implementing a WCF Data Service to expose data from a database named Northwind. You create a class named NorthwindDataService that extends DataService. You need to add a service operation to retrieve Order entities for orders shipped to customers in a city given by a parameter.

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

1
...
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
...
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