What features should we add next?

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.

4 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    GaryGary shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Josh TwistJosh Twist commented  ·   ·  Flag as inappropriate

        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 :)

      Feedback and Knowledge Base