c# - Azure Publish Database First Connection String Not Working -

-

i have gone through steps publish web app using database first on azure portal.

however, when publish error message:

code generated using t4 templates database first , model first development may not work correctly if used in code first mode. continue using database first or model first ensure entity framework connection string specified in config file of executing application. use these classes, generated database first or model first, code first add additional configuration using attributes or dbmodelbuilder api , remove code throws exception.

my connection string in web.config after has been modified publish:

<add name="mysiteentities" connectionstring="metadata=res://*/mysite.csdl|res://*/mysite.ssdl|res://*/mysite.msl;provider=system.data.sqlclient;provider connection string=&quot;data source=tcp:**********.database.windows.net,****;initial catalog=mysite;user id=username@**********;password=*******;multipleactiveresultsets=true&quot;" providername="system.data.entityclient" />

my context (generated edmx):

public partial class mysiteentities : dbcontext {     public mysiteentities()         : base("name=mysiteentities")     {     } ...

i confused becuase seems entity framework trying use code first rather database first.

update: tried using same connection string locally , web app seems run fine. web app connect remote database fine. when publish azure fails.

read answer similar question @ entity framework work locally not on azure.

if made same "mistake" did, what's happening ... azure-deployed app isn't finding connection string "mysiteentities" inside web.config. instead, @ time created azure web site (or cloud service or whatever), created associated azure sql database , gave connection string exact same name, "mysiteentities". latter connection string "plain" connection string without model/database-first metadata references, , being treated code-first connection ef, complains conflict. see code first vs. database first explanation of distinction.


Comments

Post a Comment

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

-
i use delphi xe2 , indy10 udp protocol. can't receive server echo on client side if use receivebuffer method. got "socket error # 10040" although send small echo message server client. console application illustrate problem below. in advance. program project1; {$apptype console} {$r *.res} uses system.sysutils, idglobal, idbasecomponent, idcomponent, idsockethandle, idudpclient, idudpserver, idudpbase, idstack; type tudp_serv = class(tidudpserver) procedure udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); end; var udpserver: tudp_serv; udpcl: tidudpclient; bsnd, brcv: tbytes; s: string; k: integer; //============================================================================== procedure tudp_serv.udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); begin writeln(' server read: ' + tohex(adata, length(adata))); abinding sendto(peerip, peerport, adat...
Read more

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

-
i new windows programming. here goes code objiwbemlocator = new qaxobject("wbemscripting.swbemlocator"); objwmiservice = objiwbemlocator->querysubobject("connectserver(qstring&,qstring&)",qstring("."),qstring("root\\cimv2")); qaxobject* returnlist = objwmiservice->querysubobject("execquery(qstring&)", qstring("select * %1").arg(domain)); qaxobject* result = returnlist->querysubobject("itemindex(int)", 0); i getting error on runtime qt activex wmi qaxbase::dynamiccallhelper: itemindex(int): no such property in but itemindex method exists msdn says the itemindex method not work collections not contain swbemobjects, such swbemmethodset, swbemnamedvalueset, swbemprivilegeset, swbempropertyset, , swbemqualifierset. what selecting ? have tried iterating on collection ? plus need minimum windows vista itemindex method. hope helps
Read more

Enable autocomplete or intellisense in Atom editor for PHP -

-
i'm first time user of atom editor php code. atom can autocomplete built-in functions of php. possible make editor autocomplete custom function written in separate file? function.php <?php function printsomething() { echo "hello world"; } index.php <?php require_once "function.php"; printsomething(); // autocompleted atom editor while typing thanks in advance. there text file in %userprofile%.atom called snippets.cson. in there can add snippet. more this: http://flight-manual.atom.io/using-atom/sections/snippets/ but need think can use later on other files well. otherwise need copy , paste.
Read more