Concerns about ASP.NET SPA(Single Page Application)

Here is my knowing about ASP.NET SPA:

1. have to use Upshot to talk to the server;


2. have to use DbDataController to provide Web APIs;


3. have to use Entity Framework Code first...

so, many concerns come out:

1. have to provide metadata for the upshot to work, this will obviously expose the structure of your database;


2. can i use Entity Framework Database First instead of Code First? You may ask why. Because Code First don't provide you the ability to customize your database(index customization, stored procedure...etc.);


3. A problem i met: when i add a "TestUpshot.edmx" file(generated from database 'northwind') to the MySpaApp.Models folder(trying to test whether i can use the edmx classes in the MyDbDataController class, and generate proper metadata in the client side), and run the application, there is an exception:"System.ArgumentException: Could not find the conceptual model type for MySpaApp.Models.Categories."...

Need help here, thanks in advance.

Dean

---