Update: look at that… based on your feedback we’ve baked this right into the product (starting with version 1.0.342 of our NuGet package). Check out this tutorial for instructions on how to use the new initializers, and please disregard the code below. What’s in the box works better!

A few folks have encountered an issue while developing a .NET-based mobile service using our VS template or portal quickstart. If you publish your mobile service to the cloud and then make some changes to the model and re-publish, the EF initializer will fail complaining that it doesn’t have sufficient permissions. The error might look like so in the Logs tab of the portal:

Exception=System.InvalidOperationException: This operation requires a connection to the 'master' database. Unable to create a connection to the 'master' database because the original database connection has been opened and credentials have been removed from the connection string. Supply an unopened connection. ---> System.Data.SqlClient.SqlException: Login failed for user 'zXCBHhDWhTLogin'.

This is the case because by default we use the DropCreateDatabaseIfModelChanges initializer, but the user under which your mobile service accesses your Azure SQL database doesn’t have the permission to drop the database.

To work around that we have developed an alternative initializer that does largely the same thing, but works using the permission set we already have. Please exercise caution: this initializer will delete your data. It is intended to be used during development while you are experimenting with your model and database schema.

Here is the example: instead of dropping the whole database, it just drops the tables used by your mobile service:

~~~ csharp public class DropCreateSchemaTablesIfModelChanges : CreateDatabaseIfNotExists where TContext : DbContext { private string schemaName;

Read More

The new support for writing mobile services in .NET has made it even easier for developers writing Windows Phone 8.1 apps to add a cloud hosted backend. Check out this short video to learn more.

Read More

UPDATE: The below content is now outdated… we have enabled a first-class connection string picker on the Configure tab of your mobile service. Specify the connection string there, and then you can easily use it exactly the same way as if it were defined in Web.config. 

Since we introduced the .NET backend in Mobile Services, with rich support for connecting to existing databases, we have received a lot of questions around using custom connection strings. By default, Mobile Services creates an Azure SQL Database for you and the connection string used to refer to that is named MS_TableConnectionString. Our quickstart and Visual Studio project template uses that connection string by default. 

So what do you do if you want to use your own connection string? It depends on what kind of database yo have.

• If your database is a Azure SQL database, just use the nifty Change Database button on the Configure tab of your mobile service. This will directly update the MS_TableConnectionString.
  
• If you are bringing your own database (for example SQL Server on IaaS), you cannot currently modify the MS_TableConnectionString connection string. We are working on enabling that and adding first-class support for connection string management right in the portal, but for now we have a simple workaround. Read on.

The first thing you need to do is find the App Settings section on the Configure tab of your mobile service. Create a new setting called for example onPremisesDatabase and set the value as your custom connection string.

Inside your app, find the DbContext that your .NET mobile service is using. Modify it as shown below. You might need to add an assembly reference to System.Configuration to your project.

public class customDatabase1Context : DbContext
{
    public customDatabase1Context()
        : base(ConfigurationManager.AppSettings["onPremisesDatabase"])
    {
    }
}

Then simply publish your changes and your service will now use your custom connection string. You are welcome to go and update the app setting in the portal if you need to and you don’t need to re-publish your app for the change to take effect.

Hope this helps!

Read More

If you want to learn about the new option of writing a .NET backend for your Azure Mobile Service, check out this video I made with Nick and Chris. We cover using new or existing data models and also demonstrate how to remotely debug the live service.

Read More

//build/ 2014 wrapped up Friday, and it has been a great opportunity for our team to highlight an exciting set of new enterprise feature we’ve been working on for the last few months. We started with our segment in Scott’s keynote, which showcased a killer use case for the modern enterprise: how to build a service using .NET, add authentication with Active Directory, save documents to SharePoint, and build cross-platform clients with Xamarin. You can skip forward to 45:23 in the video if you are just interested in the mobile segment

The keynote segment touched on a few features that we then explored in-depth in our presentation:

Here are the slides for our talk. I’m working on getting the samples posted as well, keep an eye on this space. 

We had some other great Mobile Services talks at //build/ that you may want to check out as well:

• 2-616 Mobile Push Notifications to Any Client with Azure Notification Hubs
• 3-603 Building Web APIs for Mobile Apps Using ASP.NET Web API 2.1
• 3-622 Building Cross-Platform Line of Business Apps with Mobile Services
• 3-598 Building Native Client and Mobile Apps using Azure Active Directory for Sign In

Read More

Thanks for joining me today. The demo is available on GitHub here. The slides are embedded below, feel free to ping me with any questions.

Read More