asp.net - Azure Website doesn't recognize my Database's Table after changing the Schema -
i have microsoft azure website running , working azure sql database sole purpose of storing , retrieving user accounts. needed mobile client there fore according numerous tutorials online such this, had change 'schema' of database's table 'dbo' mobile service's name 'usermobileservice'.
this done using sql query:
create schema usermobileservice; alter schema usermobileservicetransfer dbo.usertable;
this did trick , able connect database using mobile applications can't access database using azure website! gives me error:
server error in '/' application. invalid object name 'usertable'. description: unhandled exception occurred during execution of current web request. please review stack trace more information error , originated in code. exception details: system.data.sqlclient.sqlexception: invalid object name 'usertable'.
i believe asp.net web application cannot find database table anymore since changed schema? right way of sharing data between website , mobile service?
for of having same issue, replace sql queries call table (where schema changed) this:
your_mobile_service_name.your_table_name
in case:
usermobileservice.usertable
example:
select * usermobileservice.usertable
thank @brendan green directions!
Comments
Post a Comment