c# - Connection String Trouble MetaDataException -

-

i got 2 models in project. when added second models got error in account page: 

system.data.metadataexception: specified schema not valid. errors: (8.6): error 0040: nclob type not qualified namespace or alias. primitive types can used without qualification.  @ line 34 of `initializesimplemembershipattribute.cs` :       using (var context = new userscontext()) ligne 33 :                     { ligne 34 :                         if (!context.database.exists()) ligne 35 :                         { ligne 36 :                             // create simplemembership database without entity framework migration schema

and connection string : 

<connectionstrings>     <add name="defaultconnection" connectionstring="user id=devart;password=1234;data source=localhost:1521" providername="devart.data.oracle" />     <add name="entities" connectionstring="metadata=res://*/models.modelmae.csdl|res://*/models.modelmae.ssdl|res://*/models.modelmae.msl;provider=oracle.dataaccess.client;provider connection string=&quot;data source=localhost:1521;password=1234;user id=test&quot;" providername="system.data.entityclient" />   </connectionstrings>

usercontext connection string1 :

public class userscontext : dbcontext {     public userscontext()         : base("defaultconnection")     {     }      public dbset<userprofile> userprofiles { get; set; } }

usercontext connectionstring 2 :

public class entitiesmae : dbcontext {      public entitiesmae() : base("name=entitiesmae")     {     }      public dbset<offre> offre { get; set; }      public dbset<region> region { get; set; } }

the problem's in seconde connection string entities when remove every thing works. please how fix ?

this looks it's related problem:

http://forums.devart.com/viewtopic.php?t=21488

this article recommends 2 approaches. 1.disable conventions (i wouldn't recommend this) 2.use oracleentityproviderconfig configure workarounds.ignoreschemaname = true

they mention using specific dbcontext template, can find article (i hate posting links, there's way information there summarize):

http://blog.devart.com/entity-developer-ef-code-first-dbcontext-template.html

however, written ef 4.1, , don't version of ef you're using... i'm not sure if of still applies whatever version may using.

so gist can't replace provider no other changes. you're going have make other changes, , suggest generating code devart dbcontext template using similar code , see produces, put code in app.

also, code wrong. you're using connection strings don't exist (you the connection string called entities, code using connection string called entitiesmae), second context called usercontext, code called entitiesmae. suggest cleaning code has real code, because otherwise we're trying code isn't valid.


Comments

Post a Comment

Popular posts from this blog

database - VFP Grid + SQL server 2008 - grid not showing correctly -

-
i having problem, have grid called "gridbasica" , this: thisform.gridbase.recordsource = "sgviemp" sgviemp cursor made executing select sqlserver command sqlexec. when want modify registry, go form , the update there. so, when come form grid, grid isnt grid anymore, big white rectangle. reading around said: delete recordsource , asingt again. thisform.gridbase.recordsource = "" *--i sqlexe here thisform.gridbase.recordsource = "sgviemp" i , works, but, when click button modify again cursos updated modify form doesnt load fields did first time. could me out that? thanks in advance. --------------- edit ------------------ i have been doing recommended: lnselect = select(0) n = sqlexec(thisform.conexion,"select emp_ccodigo codigo, emp_cnombre 'nombre o razon social', emp_cnumrif 'r.i.f' sgviempr","sgviemp1") set echo on suspend select sgviemp zap in sgviemp *-- browse *--zaps correct
Read more

jquery - Set jPicker field to empty value -

-
im using jpicker color selector in form. have clear value set window/icon 'no color selected' state. i've tried following: $(':input[name="color"]').val(''); //access value directly. (does not affect jpicker) 2: $.jpicker.list[0].color.active.val('hex', '', this); //set color black , input value 000000, instead of empty string 3: $.jpicker.list[0].color.active.val(null, '', this); //does nothing none of 3 methods seems behave properly. in advance. this works me :) $.jpicker.list[0].color.active.val('v', null); here example: http://jsfiddle.net/3up7n/
Read more

c# - Convert XDocument to byte array (and byte array to XDocument) -

-
i've taken on system stores large xml documents in sql server in binary format. currently data saved converting string, converting string byte array. large xml documents i'm getting out memory exceptions when attempting convert string, want bypass process , go straight xdocument byte array. the entity framework class holding xml has been extended binary data accessible string this: partial class xmldata { public string xmlstring { { return encoding.utf8.getstring(xmlbinary); } set { xmlbinary = encoding.utf8.getbytes(value); } } } i want further extend class this: partial class xmldata { public string xmlstring{ { return encoding.utf8.getstring(xmlbinary); } set { xmlbinary = encoding.utf8.getbytes(value); } } public xdocument xdoc { { // convert xmlbinary xdocument } set { // convert xdocument xmlbinary } } } i think i've figured out conversion, when use partial cla
Read more