c# - Azure Mobile Service - Entity Framework Code First drop and create database not working -


problem: changing model in code first mobile services project , publishing azure causes following error:

system.data.sqlclient.sqlexception (0x80131904): cannot open database "master" requested login. login failed. login failed user 'xxxxxxxxxxxxxxxxxx'.

steps reproduce:

  • visual studio community 2015 new project -> web application -> mobile service
  • publish straight azure (create new mobile service - select cheapest tier db)
  • send in fiddler http://whatever.azure-mobile.net/tables/todoitem
  • receive 200 ok 2 items seeded db default project
  • make small change model (e.g. add following todoitem class) public string changed { get; set; }
  • publish changes azure
  • send in fiddler http://whatever.azure-mobile.net/tables/todoitem
  • this time 500 internal server error received , error quoted @ start appears twice in mobile service logs in azure

i have checked , database still exists without change model, assume azure wasn't able drop reason.

in default mobile service project, in webapiconfig class database initializer set of type inherits dropcreatedatabaseifmodelchanges. shouldn't azure drop database , recreate it? had problem in customised project of mine, tried test default mobile service , able reproduce it, shouldn't default site work outside of box, @ least?

is there need allow azure drop database? error message suggests can't log in, we've proven can fact seed method in mobileserviceinitializer class called when service first published (because able return 2 todoitems first request sent fiddler).

any ideas? appreciated, thanks.

found answer right after submitting this, typical!

the db user azure uses doesn't have permission drop database, need change type of initializer used dropcreatedatabaseifmodelchanges cleardatabaseschemaifmodelchanges. updates schema nicely on every deployment!


Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more