c# - Unable to find the requested .Net Framework Data Provider. (SqlClient) -

-

i trying set simple asp.net mvc 4 webapp using db first migrations sql server (2005). have created tables in database , used entity framework create objects in code. can access data using these objects.

the problems come when try initialize websecurity using websecurity.initializedatabaseconnection("flmrentities", "userprofile", "userid", "username", true); in global.asax.cs file. have tried using initializesimplemembershipattribute filter came template , got same issue. error message:

unable find requested .net framework data provider. may not installed.

here relevant connection string:

<add name="flmrentities"      connectionstring="metadata=res://*/models.flmr.csdl|res://*/models.flmr.ssdl|res://*/models.flmr.msl;                     provider=system.data.sqlclient;                     provider connection string=&quot;data source=notes.marietta.edu;                         initial catalog=muskwater;                         user id=muskwater;password=********;                         multipleactiveresultsets=true;                         app=entityframework&quot;"       providername="system.data.entityclient" />

also, have created membership tables in database match template creates. if change final parameter in initialize call false (so not try create tables automatically) returns cannot find userprofile table. have tried variations on names, such [dbo].[userprofile].

all need have simple account model allow users log in , allow users see more content.

i had similar problem, i've done: modified default connection. had connection string edmx model, looked this:

<add name="chemicalreporterentities" connectionstring="metadata=res://*/chemicaldb.csdl|res://*/chemicaldb.ssdl|res://*/chemicaldb.msl;provider=system.data.sqlclient;provider connection string=&quot;data source=.\sqlexpress;initial catalog=chemicalreporter;integrated security=true;multipleactiveresultsets=true;app=entityframework&quot;" providername="system.data.entityclient" />

but cannot used simplememebrship provider. in visual studio opened server explorer > data connections, selected connection, right click, properties , copied connection string there , pasted defaultconnection:

<add name="defaultconnection" connectionstring="data source=.\sqlexpress;initial catalog=chemicalreporter;integrated security=true;multipleactiveresultsets=true;application name=entityframework" providername="system.data.sqlclient" />

after changed websecurity.initializedatabaseconnection use defaultconnection.

websecurity.initializedatabaseconnection("defaultconnection", "userprofile", "userid", "username", true);

Comments

Post a Comment

Popular posts from this blog

ruby - Trying to change last to "x"s to 23 -

-
i have been playing around irb , have string looks this: irb(main):072:0> puts ["[\"4354 5432 5432 xxxxx\", \"6547 6547 8543 xxxxx\", \"2344 6543 6674 xxxxx\", \"2346 6236 7543 xxxxx\", \"1273 5585 5587 xxxxx\"]"] => nil irb(main):073:0> what want gsub last 2 "x" s of each 17 digit combination, 23 . what i've tried far (i've been using rubular): a.gsub(/\d[x]/,"23") <= grabs "x" s i'm close a.gsub(/\w[x{2}]/,"23") <= grabs "x" s grabs two digits each combination. is there easier way i'm not understanding? a.gsub(/\d{4} \d{4} \d{4} xxx\kxx/, '23') \d{4} = 4 digits what \k drop matched far. can use don't replace entire number, still able validate have in desired format.
Read more

jquery - Clone last and append item to closest class -

-
this bare-bones code on page: <div class="list-container"> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> </div> <p><button class="add-list-item">add</button></p> <div class="list-container"> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> </div> <p><button class="add-list-item">add</button></p> <di
Read more

c - Unrecognised emulation mode: elf_i386 on MinGW32 -

-
i'm trying make kernel, , cannot link c output assembly. ld . i'm getting error: unrecognized emulation mode: elf_i386 i'm using windows 10 professional mingw32 , msys. code using: link.ld /* * link.ld */ output_format(elf32-i386) entry(start) sections { . = 0x100000; .text : { *(.text) } .data : { *(.data) } .bss : { *(.bss) } } kernel.c /* * kernel.c */ void kmain(void) { const char *str = "my first kernel"; char *vidptr = (char*)0xb8000; //video mem begins here. unsigned int = 0; unsigned int j = 0; /* loops clears screen * there 25 lines each of 80 columns; each element takes 2 bytes */ while(j < 80 * 25 * 2) { /* blank character */ vidptr[j] = ' '; /* attribute-byte - light grey on black screen */ vidptr[j+1] = 0x07; j = j + 2; } j = 0; /* loop writes string video memory */ while(str[j] != '\0') { /
Read more