entity framework - How to avoid unwanted connections to the Azure master database using mobile services? -


the following code:

    private void isolateissue()     {         using (var context = new somename.models.mobileservicecontext())         {             system.diagnostics.debug.writeline(context.database.connection.connectionstring);             var numberofitems = context.todoitems.count();         }     }

results in error (when calling var numberofitems):

an exception of type 'system.data.sqlclient.sqlexception' occurred in entityframework.dll not handled in user code additional information: cannot open database "master" requested login. login failed. login failed user 'someloginname'.

this connectionstring:

"data source=servername.database.windows.net;initial catalog=somedatabasename;user id=someloginname;password=somepassword};asynchronous processing=true;trustservercertificate=false;"

it obvious can not connect master database. given username , password, cannot connect master database linqpad (when try similar error). however, should not connect @ master database. when try login on somedatabasename linqpad, succeed in getting number of todoitems (17). proves there no need access master database @ given purpose.

first, have make sure can number of items in mobile service. how do that? initial catalog shows should connect somedatabasename , there no need connect master database number of items. how avoid tries so?

in case helps, here stacktrace:

stacktrace " @ system.data.sqlclient.sqlinternalconnection.onerror(sqlexception exception, boolean breakconnection, action1 wrapcloseinaction)\r\n @ system.data.sqlclient.tdsparser.throwexceptionandwarning(tdsparserstateobject stateobj, boolean callerhasconnectionlock, boolean asyncclose)\r\n @ system.data.sqlclient.tdsparser.tryrun(runbehavior runbehavior, sqlcommand cmdhandler, sqldatareader datastream, bulkcopysimpleresultset bulkcopyhandler, tdsparserstateobject stateobj, boolean& dataready)\r\n @ system.data.sqlclient.tdsparser.run(runbehavior runbehavior, sqlcommand cmdhandler, sqldatareader datastream, bulkcopysimpleresultset bulkcopyhandler, tdsparserstateobject stateobj)\r\n @ system.data.sqlclient.sqlinternalconnectiontds.completelogin(boolean enlistok)\r\n @ system.data.sqlclient.sqlinternalconnectiontds.attemptonelogin(serverinfo serverinfo, string newpassword, securestring newsecurepassword, boolean ignoresniopentimeout, timeouttimer timeout, boolean withfailover)\r\n @ system.data.sqlclient.sqlinternalconnectiontds.loginnofailover(serverinfo serverinfo, string newpassword, securestring newsecurepassword, boolean redirecteduserinstance, sqlconnectionstring connectionoptions, sqlcredential credential, timeouttimer timeout)\r\n @ system.data.sqlclient.sqlinternalconnectiontds.openloginenlist(timeouttimer timeout, sqlconnectionstring connectionoptions, sqlcredential credential, string newpassword, securestring newsecurepassword, boolean redirecteduserinstance)\r\n @ system.data.sqlclient.sqlinternalconnectiontds..ctor(dbconnectionpoolidentity identity, sqlconnectionstring connectionoptions, sqlcredential credential, object providerinfo, string newpassword, securestring newsecurepassword, boolean redirecteduserinstance, sqlconnectionstring userconnectionoptions, sessiondata reconnectsessiondata)\r\n @ system.data.sqlclient.sqlconnectionfactory.createconnection(dbconnectionoptions options, dbconnectionpoolkey poolkey, object poolgroupproviderinfo, dbconnectionpool pool, dbconnection owningconnection, dbconnectionoptions useroptions)\r\n @ system.data.providerbase.dbconnectionfactory.createpooledconnection(dbconnectionpool pool, dbconnection owningobject, dbconnectionoptions options, dbconnectionpoolkey poolkey, dbconnectionoptions useroptions)\r\n @ system.data.providerbase.dbconnectionpool.createobject(dbconnection owningobject, dbconnectionoptions useroptions, dbconnectioninternal oldconnection)\r\n @ system.data.providerbase.dbconnectionpool.usercreaterequest(dbconnection owningobject, dbconnectionoptions useroptions, dbconnectioninternal oldconnection)\r\n @ system.data.providerbase.dbconnectionpool.trygetconnection(dbconnection owningobject, uint32 waitformultipleobjectstimeout, boolean allowcreate, boolean onlyonecheckconnection, dbconnectionoptions useroptions, dbconnectioninternal& connection)\r\n @ system.data.providerbase.dbconnectionpool.trygetconnection(dbconnection owningobject, taskcompletionsource1 retry, dbconnectionoptions useroptions, dbconnectioninternal& connection)\r\n @ system.data.providerbase.dbconnectionfactory.trygetconnection(dbconnection owningconnection, taskcompletionsource1 retry, dbconnectionoptions useroptions, dbconnectioninternal oldconnection, dbconnectioninternal& connection)\r\n @ system.data.providerbase.dbconnectioninternal.tryopenconnectioninternal(dbconnection outerconnection, dbconnectionfactory connectionfactory, taskcompletionsource1 retry, dbconnectionoptions useroptions)\r\n @ system.data.providerbase.dbconnectionclosed.tryopenconnection(dbconnection outerconnection, dbconnectionfactory connectionfactory, taskcompletionsource1 retry, dbconnectionoptions useroptions)\r\n @ system.data.sqlclient.sqlconnection.tryopeninner(taskcompletionsource1 retry)\r\n @ system.data.sqlclient.sqlconnection.tryopen(taskcompletionsource1 retry)\r\n @ system.data.sqlclient.sqlconnection.open()\r\n @ system.data.entity.infrastructure.interception.dbconnectiondispatcher.<open>b__36(dbconnection t, dbconnectioninterceptioncontext c)\r\n @ system.data.entity.infrastructure.interception.internaldispatcher1.dispatch[ttarget,tinterceptioncontext](ttarget target, action2 operation, tinterceptioncontext interceptioncontext, action3 executing, action3 executed)\r\n @ system.data.entity.infrastructure.interception.dbconnectiondispatcher.open(dbconnection connection, dbinterceptioncontext interceptioncontext)\r\n @ system.data.entity.sqlserver.sqlproviderservices.<>c__displayclass34.<usingconnection>b__32()\r\n @ system.data.entity.sqlserver.defaultsqlexecutionstrategy.<>c__displayclass1.<execute>b__0()\r\n @ system.data.entity.sqlserver.defaultsqlexecutionstrategy.execute[tresult](func1 operation)\r\n @ system.data.entity.sqlserver.defaultsqlexecutionstrategy.execute(action operation)\r\n @ system.data.entity.sqlserver.sqlproviderservices.usingconnection(dbconnection sqlconnection, action1 act)\r\n @ system.data.entity.sqlserver.sqlproviderservices.usingmasterconnection(dbconnection sqlconnection, action1 act)\r\n @ system.data.entity.sqlserver.sqlproviderservices.dropdatabase(sqlconnection sqlconnection, nullable1 commandtimeout, string databasename)\r\n @ system.data.entity.sqlserver.sqlproviderservices.dbdeletedatabase(dbconnection connection, nullable1 commandtimeout, storeitemcollection storeitemcollection)\r\n @ system.data.entity.core.common.dbproviderservices.deletedatabase(dbconnection connection, nullable1 commandtimeout, storeitemcollection storeitemcollection)\r\n @ system.data.entity.core.objects.objectcontext.deletedatabase()\r\n @ system.data.entity.internal.databaseoperations.delete(objectcontext objectcontext)\r\n @ system.data.entity.database.delete()\r\n @ system.data.entity.dropcreatedatabaseifmodelchanges1.initializedatabase(tcontext context)\r\n @ system.data.entity.internal.internalcontext.<>c__displayclassf1.<createinitializationaction>b__e()\r\n @ system.data.entity.internal.internalcontext.performinitializationaction(action action)\r\n @ system.data.entity.internal.internalcontext.performdatabaseinitialization()\r\n @ system.data.entity.internal.lazyinternalcontext.<initializedatabase>b__4(internalcontext c)\r\n @ system.data.entity.internal.retryaction1.performaction(tinput input)\r\n @ system.data.entity.internal.lazyinternalcontext.initializedatabaseaction(action1 action)\r\n @ system.data.entity.internal.lazyinternalcontext.initializedatabase()\r\n @ system.data.entity.internal.internalcontext.getentitysetandbasetypefortype(type entitytype)\r\n @ system.data.entity.internal.linq.internalset1.initialize()\r\n @ system.data.entity.internal.linq.internalset1.get_internalcontext()\r\n @ system.data.entity.infrastructure.dbquery1.system.linq.iqueryable.get_provider()\r\n @ system.linq.queryable.count[tsource](iqueryable`1 source)\r\n

i see in stack: system.data.entity.dropcreatedatabaseifmodelchanges. believe ef needs access master database in order drop , recreate database.

this blog post mentions cleardatabaseschemaifmodelchanges initializer, may want: http://blogs.msdn.com/b/azuremobile/archive/2014/06/07/fresh-updates-to-azure-mobile-services-net.aspx


Comments

Post a Comment

Popular posts from this blog

shopping cart - Page redirect not working PHP -

im trying redirect user when click "empty cart". redirect working "add cart" not "empty cart". ideas great. in main .php file set current url seen $current_url = base64_encode("http://$_server[http_host]$_server[request_uri]"); then below cartaction.php file handles actions such "add cart" , "empty cart" <?php session_start(); include_once 'config.php'; //add item in shopping cart if(isset($_post["add"])) { $product_id = $_post["product_id"]; //product id $return_url = base64_decode($_post["return_url"]); //return url $qty = $_post["qty"]; $product = $mysqli->query("select product_name, unit_price, unit_quantity products product_id = '$product_id'"); $obj = $product->fetch_object(); if(!isset($_session['products'])) { $_session['products'] = array(); } if(array_key_exists($product_id...
Read more

php - How to modify a menu to show sub-menus -

i have custom php menu made person, displays categories menu. however, need display subcategories well. tried adding hierarchical parameter didn't work. hoping assistance! here code: <ul> <?php /* categories wp e-commerce products */ $wpec_product_categories = get_terms( 'wpsc_product_category', 'hide_empty=0&parent=0&exclude=298'); $myarray = array(); foreach($wpec_product_categories $wpec_categories){ $myarray[$wpec_categories->term_id]['name'] = $wpec_categories->name; $myarray[$wpec_categories->term_id]['slug'] = $wpec_categories->slug; $myarray[$wpec_categories->term_id]['term_id'] = $wpec_categories->term_id; } foreach($myarray $wpec_categories1){ $wpec_term_name = $wpec_categories1['name']; $wpec_term_slug = $wpec_categories1['slug']; $wpec_term_id = $wpec_categories1['term_id']; echo '<li> <a href="'.get_page_link(19)....
Read more

python - Installing PyDev in eclipse is failed -

unable read repository @ http://pydev.sf.net/updates/content.xml. sun.security.validator.validatorexception: pkix path building failed: sun.security.provider.certpath.suncertpathbuilderexception: unable find valid certification path requested target i installing pydev in eclipse using python, doesn't install successfully. gives above error. happened? how solve error? i had error when trying install on laptop behind corporate firewall. couldn't tell setup of firewall, not sure of root cause. i got passed error installing pydev eclipse when out behind firewall. another way got around have eclipse on non-firewalled machine, install pydev eclipse, , copy whole eclipse directory non-firewalled machine firewalled machine. there better way, , way fix properly, didn't have time work out firewall doing. this on windows 7 machine (yeah know) not work *nix versions installed through package manager yum or apt.
Read more