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

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.

Post |

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Get 650+ Questpond's Interview videos on discount

What is the use of Command objects?

•ExecuteNonQuery
Executes the command defined in the CommandText property against the connection defined in the Connection property for a query that does not return any row (an UPDATE, DELETE, or INSERT). Returns an Integer indicating the number of rows affected by the query.

•ExecuteReader
Executes the command defined in the CommandText property against the connection defined in the Connection property. Returns a "reader" object that is connected to the resulting row set within the database, allowing the rows to be retrieved.

•ExecuteScalar
Executes the command defined in the CommandText property against the connection defined in the Connection property. Returns only a single value (effectively the first column of the first row of the resulting row set, any other returned columns and rows are discarded). It is fast and efficient when only a "singleton" value is required.

What is the use of a data adapter?

These objects connect one or more Command objects to a DataSet object. They provide logic that would get data from the data store and populates the tables in the DataSet, or pushes the changes in the DataSet back into the data store.

•An OleDbDataAdapter object is used with an OLE-DB provider
•A SqlDataAdapter object uses Tabular Data Services with MS SQL Server.

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

What is the use of Command objects?

What is the use of a data adapter?

You are creating a new application that will use a database that already exists. Which model will you use to create your Entity Data Model?

You have a Customer entity, but it comprises properties that are spread across two tables in the database. What should you do?

You have entity classes from your conceptual model, but you can't add a custom method to one of the classes. Which would be the best approach to adding this method?

In your application, you have existing classes that represent the conceptual model. How can the Entity Framework be configured to use these classes?

You have created a conceptual model manually by using the Entity Framework designer. Can you use the Entity Framework designer to generate a new database from the completed conceptual model?

When working with the Entity Framework, what can you use to retrieve the SQL of a query?

You create a PerformanceCounter object to view the SQL statements sent to the database server. True or false?

What should you use to capture an exception that might occur when you are sending changes to the database server?

Which are the following valid encryption algorithms that can be used when encrypting the connection strings ?

Which of the following is a valid symmetric encryption algorithm?

You want to store the contents of a data set to an XML file so you can work on the data while disconnected from the database server. How should you store this data?

You want to synchronize data between local SQL Server Compact tables and SQL Server 2008. You want the synchronization to send changes to SQL Server 2008, and you want to receive changes from SQL Server 2008. Which setting must you assign to the SyncDirection property of your sync agent's tables?

You create a WCF Data Services application in VS 2010 that uses the ADO.NET Entity Framework. You must ensure that the model and mapping files are not deployed as application resources. What should you do?

You want to create a connection to an old SQL server. Upon investigation, you discover that its version is 6.5. Which .NET provider will you use to connect to this server?

Before you can execute a command on a connection object, which method must you execute to prepare the connection?

You want to set up a secure connection between your application and SQL Server. SQL Server has a trusted certificate that is set up properly.What must you do?

You want to secure the connection strings contained within your Web.config file to ensure that no one can open the file easily and see the connection information.

Interview Questions and Answers Categories