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
Should be A.
ExecuteNonQuery() does not return data at all: only the number of rows affected by an insert, update, or delete
1
0
A
ExecuteScalar
Executes the command, and returns the first column of the first row in the result set. Additional columns or rows are ignored.
2
0
It should be C, it says images and associated metadata
0
0
No, it is A
https://www.codeproject.com/Articles/10861/Storing-and-Retrieving-Images-from-SQL-Server-usin
0
0
A. ExecuteScalar
0
0