create and copy sql tables programmatically
In "regular" SQL, we can create tables by sending queries like:
CREATE TABLE table_name
( column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
.... )
... and can copy tables as such:
CREATE TABLE new_table AS (SELECT * FROM old_table);
Now skip over to the Windows Azure Mobile Services world, and its "special" SQL. I am having good success creating tables using the Azure portal (non-programmatically) and then accessing these tables as such:
var mobClient = new MobileServiceClient("[url]", "[app key]");
var mobTable = mobClient.GetTable<MyTableClass>();
Browsing the intellisense for the client showed no options for create or copy table.
1 comment
-
Josh Twist
commented
You can access the 'regular' SQL database behind your Mobile Service directly and do whatever you like in T-SQL; it's your SQL database :)