postgresql - Can't generate database from .edmx (Npgsql 2.2.5/EF6) -

-

i can connect postgresql database fine (i generated .edmx way in first place), can't generate database .edmx.

the error indicates no provider invariant name 'npgsql' has been found, , entityframework section of web.config should checked it, far can tell it's here.

this asp mvc5 application, here's web.config:

<configuration>   <configsections>     <section name="entityframework" type="system.data.entity.internal.configfile.entityframeworksection, entityframework, version=6.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089" requirepermission="false" />   </configsections>   <connectionstrings>     <add name="pgarcher" connectionstring="host=localhost;database=archerie;user=postgres;password=***" providername="npgsql" />     <add name="archerieentities" connectionstring="metadata=res://*/archerieedm.csdl|res://*/archerieedm.ssdl|res://*/archerieedm.msl;provider=npgsql;provider connection string=&quot;port=5432;timeout=15;pooling=true;minpoolsize=1;maxpoolsize=20;commandtimeout=20;compatible=2.2.5.0;host=localhost;database=archerie;user id=postgres;password=***&quot;" providername="system.data.entityclient" />   </connectionstrings>   <appsettings>     <add key="webpages:version" value="3.0.0.0" />     <add key="webpages:enabled" value="false" />     <add key="clientvalidationenabled" value="true" />     <add key="unobtrusivejavascriptenabled" value="true" />   </appsettings>   <system.web>     <authentication mode="none" />     <compilation debug="true" targetframework="4.5.1" />     <httpruntime targetframework="4.5.1" />   </system.web>   <system.webserver>     <modules>       <remove name="formsauthentication" />     </modules>   </system.webserver>   <runtime>     <assemblybinding xmlns="urn:schemas-microsoft-com:asm.v1">       <dependentassembly>         <assemblyidentity name="microsoft.owin" publickeytoken="31bf3856ad364e35" />         <bindingredirect oldversion="0.0.0.0-3.0.1.0" newversion="3.0.1.0" />       </dependentassembly>       <dependentassembly>         <assemblyidentity name="microsoft.owin.security.oauth" publickeytoken="31bf3856ad364e35" />         <bindingredirect oldversion="0.0.0.0-3.0.1.0" newversion="3.0.1.0" />       </dependentassembly>       <dependentassembly>         <assemblyidentity name="microsoft.owin.security.cookies" publickeytoken="31bf3856ad364e35" />         <bindingredirect oldversion="0.0.0.0-3.0.1.0" newversion="3.0.1.0" />       </dependentassembly>       <dependentassembly>         <assemblyidentity name="microsoft.owin.security" publickeytoken="31bf3856ad364e35" />         <bindingredirect oldversion="0.0.0.0-3.0.1.0" newversion="3.0.1.0" />       </dependentassembly>       <dependentassembly>         <assemblyidentity name="newtonsoft.json" culture="neutral" publickeytoken="30ad4fe6b2a6aeed" />         <bindingredirect oldversion="0.0.0.0-6.0.0.0" newversion="6.0.0.0" />       </dependentassembly>       <dependentassembly>         <assemblyidentity name="system.web.optimization" publickeytoken="31bf3856ad364e35" />         <bindingredirect oldversion="1.0.0.0-1.1.0.0" newversion="1.1.0.0" />       </dependentassembly>       <dependentassembly>         <assemblyidentity name="webgrease" publickeytoken="31bf3856ad364e35" />         <bindingredirect oldversion="0.0.0.0-1.6.5135.21930" newversion="1.6.5135.21930" />       </dependentassembly>       <dependentassembly>         <assemblyidentity name="antlr3.runtime" publickeytoken="eb42632606e9261f" culture="neutral" />         <bindingredirect oldversion="0.0.0.0-3.5.0.2" newversion="3.5.0.2" />       </dependentassembly>       <dependentassembly>         <assemblyidentity name="system.web.helpers" publickeytoken="31bf3856ad364e35" />         <bindingredirect oldversion="1.0.0.0-3.0.0.0" newversion="3.0.0.0" />       </dependentassembly>       <dependentassembly>         <assemblyidentity name="system.web.webpages" publickeytoken="31bf3856ad364e35" />         <bindingredirect oldversion="1.0.0.0-3.0.0.0" newversion="3.0.0.0" />       </dependentassembly>       <dependentassembly>         <assemblyidentity name="system.web.mvc" publickeytoken="31bf3856ad364e35" />         <bindingredirect oldversion="1.0.0.0-5.2.3.0" newversion="5.2.3.0" />       </dependentassembly>     </assemblybinding>   </runtime>   <system.data>     <dbproviderfactories>       <add name="npgsql - .net data provider postgresql" invariant="npgsql" description=".net data provider postgresql" type="npgsql.npgsqlfactory, npgsql, version=2.2.5.0, culture=neutral, publickeytoken=5d8b90d52f46fda7" />       <add name="dotconnect postgresql" invariant="devart.data.postgresql" description="devart dotconnect postgresql" type="devart.data.postgresql.pgsqlproviderfactory, devart.data.postgresql, version= 7.3.422.0, culture=neutral, publickeytoken=09af7300eec23701" />     </dbproviderfactories>   </system.data>   <entityframework>     <providers>       <provider invariantname="npgsql" type="npgsql.npgsqlservices, npgsql.entityframework, version=2.2.5.0, culture=neutral, publickeytoken=5d8b90d52f46fda7" />     </providers>   </entityframework> </configuration>

  • make sure installed npgsql , npgsql.entityframework in project (seems obvious, i've seen cases when people report errors yours , installed these packages in "repository" project).
  • npgsql , mono.security must registered in gac (check version using).

and @ least, add assembly binding npgsql well:

<dependentassembly>     <assemblyidentity name="npgsql" publickeytoken="5d8b90d52f46fda7" culture="neutral" />     <bindingredirect oldversion="0.0.0.0-2.2.5.0" newversion="2.2.5.0" />   </dependentassembly>

Comments

Post a Comment

Popular posts from this blog

PHP DOM loadHTML() method unusual warning -

-
i had following code works fine on localhost: $document = new domdocument(); $document->loadhtml($p_result); $form = $document->getelementsbytagname('form')->item(0); // code continues using $form variable after same code updated on outside server, loadhtml() failed , issued warning. warning: domdocument::loadhtml() expects parameter 1 valid path, string given in path/name/to/script.php returned null instead of object code pretty gets fatal error. note contents of $p_result absolutely same on outside server , on localhost. but why displays kind of warning , why not work? doesn't loadhtml() expects argument 1 string in first place? why method expects parameter 1 valid path ? just make clear i'm not calling loadhtmlfile() , i'm calling loadhtml() . thanks. you're affected one of php bugs . issue present in php 5.6.8 , 5.6.9. have affected php version on server, , bug-free version on localhost. the bug forbids null
Read more

python - How to create jsonb index using GIN on SQLAlchemy? -

-
here's current code creating index jsonb. index("mytable_data_idx_id_key", mytable.data['id'].astext, postgresql_using='gin') but got error. sqlalchemy.exc.programmingerror: (psycopg2.programmingerror) data type text has no default operator class access method "gin" hint: must specify operator class index or define default operator class data type. [sql: "create index event_data_idx_id_key on event using gin ((data ->> 'id'))"] is there way create index on sqlalchemy? the postgresql specific sqlalchemy docs @ http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#operator-classes mention postgresql_ops dictionary provide "operator class" used postgresql, , provide example illustrating use: index('my_index', my_table.c.id, my_table.c.data, postgresql_ops={ 'data': 'text_pattern_ops',
Read more

c# - TransactionScope not rolling back although no complete() is called -

-
i'm using transactionscope rollback transaction fail bool errorreported = false; action<importerrorlog> newerrorcallback = e => { errorreported = true; errorcallback(e); }; using (var transaction = new transactionscope()) { foreach (importtaskdefinition task in taskdefinition) { loader.load(streamfile, newerrorcallback, task.destinationtable, processingtaskid); } if (!errorreported) transaction.complete(); } i'm sure there no transactionscope started ahead or after code. i'm using entity framework insert in db. regardless state of errorreported transaction never rolled in case of error. what missing ? transactionscope sets transaction.current . that's does. wants transacted must @ property. i believe ef each time connection opened reason. probably, connection open when scope installed. open connection inside of scope or enlist manually. ef has nasty "design decision": default opens
Read more