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

Popular posts from this blog

css - SVG using textPath a symbol not rendering in Firefox -

Java 8 + Maven Javadoc plugin: Error fetching URL -

order - Notification for user in user account opencart -