In the previous section, we saw how to execute Entity SQL using ObjectQuery
. In this section, we will see how we can use Entity SQL using EntityCommand
. The EntityCommand
object is derived from the DbCommand
object, which would mean that using the EntityCommand
object with EntityConnection
will be very similar to using DbCommand
with DbConnection
.
One important thing to understand is that if we use EntityCommand
, the command will be executed directly at the EntityClient
layer and not the object layer. This means that the results of Entity SQL with EntityCommand
will not be returned in terms of entity objects, but will just give us read-only access to data using the EntityDataReader
object. The EntityDataReader
object will give us a stream of raw data, and it is up to us to convert this data into meaningful domain entities.