Do you necessarily have to do it in C#? I'm asking because that functionality is already built-in to SQL Sever, if you are using version 2014. Just right-click on the database in SQL Server Management Studio and select Tasks -> Deploy Database to
Windows Azure. This migrates the tables and data, as well as other database objects such as views or stored procedures if you have them.
Edited: If you really need to get the table names, you can send a sql query such as "select * from information_schema.tables" or "select * from sys.tables". Although you can do this in EF 6 with some effort, it's better to just send it
through a SqlCommand, since once you get the list of tables you are going to need the SqlCommand anyway in order to send the dynamic queries that select the data from the various tables. Entity Framework would not be of much use here, unless you add entities
for all of the tables, in which case you wouldn't need the list of tables in the first place.
