EF and MySQL table last update

Question

I´m using Entity Framework to pull data from a MySQL database. I know I can get the last time a given table has been updated. How can I do this using EF?

http://stackoverflow.com/questions/307438/how-can-i-tell-when-a-mysql-table-was-last-updated — ferroariel, Aug 22 '14 at 19:19

score 1 · Accepted Answer · answered Aug 25 '14 at 07:43

You can use Database.SqlQuery Method (String, Object[]) to run the query that returns the desired data.

The TElement parameter type must be

either a single type (like string) if the query returns a single value (1 row, 1 column)
a class that has column which the same names of the columns returned by the query (if the query returns several columns) You'd have to create this class yourself, if this is the case.

EF and MySQL table last update

1 Answers1