Using SQL Database data in both Web Page and Mobile Services


hi all,

i trying move service other server azure. service has 3 main parts:

- sql database (where information stored)

- android app (generates information , stores in sql database)

- web page (shows data stored in database)

i have allready succesffully made changes in android app use azure mobile services, , tables data alredy shown in sql database.

now trying implement web page. this, followed tutorials (http://www.windowsazure.com/en-us/documentation/articles/web-sites-dotnet-deploy-aspnet-mvc-app-membership-oauth-sql-database/ and http://www.windowsazure.com/en-us/documentation/articles/web-sites-dotnet-get-started/) not access tables used mobile service. examples use tables using schema "dbo", , tables under schema (with name of mobile service).

i have tried following (without success):

  • create new login , user azure sql database default_schema 1 of mobile service
  • change default schema in web project (using solution: http://social.msdn.microsoft.com/forums/en-us/e276fb02-ef9b-44eb-b481-699c1c25602d/change-schemaname-for-ef-41-dbcontext?forum=adodotnetentityframework)
  • define schema name model class , overriding "onmodelcreating" method of dbcontext:
//in model class:  [table("contacts", schema="schemaname")] public class contact {     //... }  //in context class (dbcontext)  protected override void onmodelcreating(dbmodelbuilder modelbuilder) {     base.onmodelcreating(modelbuilder);     modelbuilder.entity<contactsmanager.models.contact>().totable("contacts", schemaname: "schemaname"); }

can me? idea appreciated.

thanks,

victor

ps: don't know if important, created tables using "manage" azure website, under mobile service, , after got working, tried implement web site


hello,

it seems issue more related windows azure website development, please post question in the windows azure development forum:
http://social.msdn.microsoft.com/forums/en-us/home?forum=windowsazuredevelopment

it more appropriate , experts there assist you.

regards,
fanny liu

fanny liu
technet community support



Microsoft Azure  >  Azure SQL Database



Comments

Post a Comment

Popular posts from this blog

SQL server replication error Cannot find the dbo or user defined function........

hi there, i ran problem while deploying sql 2008 transactional replication between 2 servers lets assume server , b. actually created  both distributor , publisher on server , after created subscriber pointed server b, launch replication monitor , found big red cross. when click on tab "distributor subscriber history" error says "cannot find either column "dbo" or user defined-function or aggregate "dbo.ufnleadingzeros", or name ambiguous". can body regarding issue. regards, ishuv hi, you need compare data , others reseved, index size, unused should not compared. differs. here server - data - 87896 kb server b - data - 78152 kb server data size includes publication tables, can't compare directly. need check article article know exact data size. SQL Server  >  ...
Read more

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

Admin Permissions

hi need create new 'role' following permissions, 1. access sql server logs. 2. access maintenance plans ( can avoid access) 3. access activity monitor 4. normal access product databases , not system db´s need guidance on how it, can point me in right direction please? thanks 1.grant  execute on xp_readerrorlog [domainname\ad user or group]; 2. http://technet.microsoft.com/en-us/library/ms191002.aspx 3.view server state permission 4. make user member of dbo_owner database role. best regards,uri dimant sql server mvp, http://sqlblog.com/blogs/uri_dimant/ ms sql optimization: ms sql development , optimization ms sql consulting: large scale of database , data cleansing remote dba services: improves ms sql database performance sql server integration services: business intelligence SQL Server  >  ...
Read more