Which method of the EntityCommand type should you use?

You are developing an ASP.NET MVC application. The application has a page that searches for and
displays an image stored in a database. Members of the EntityClient namespace are used to access an
ADO.NET Entity Framework data model. Images and associated metadata are stored in a database table.
You need to run a query that returns only the image while minimizing the amount of data that is
transmitted.
Which method of the EntityCommand type should you use?

You are developing an ASP.NET MVC application. The application has a page that searches for and
displays an image stored in a database. Members of the EntityClient namespace are used to access an
ADO.NET Entity Framework data model. Images and associated metadata are stored in a database table.
You need to run a query that returns only the image while minimizing the amount of data that is
transmitted.
Which method of the EntityCommand type should you use?

A.
ExecuteScalar

B.
ExecuteDbDataReader

C.
ExecuteReader

D.
ExecuteNonQuery

Explanation:
ExecuteScalar
Executes the command, and returns the first column of the first row in the result set. Additional columns
or rows are ignored.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Marios

Marios

why not C?

Andrii

Andrii

Because it should return only one image. ExecuteReader implies multiple images.