{"action":"created","issue":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/1506","repository_url":"https://api.github.com/repos/npgsql/npgsql","labels_url":"https://api.github.com/repos/npgsql/npgsql/issues/1506/labels{/name}","comments_url":"https://api.github.com/repos/npgsql/npgsql/issues/1506/comments","events_url":"https://api.github.com/repos/npgsql/npgsql/issues/1506/events","html_url":"https://github.com/npgsql/npgsql/issues/1506","id":216179901,"number":1506,"title":"NpgsqlPackage didnt load correctly","user":{"login":"dropyghost","id":10077853,"avatar_url":"https://avatars0.githubusercontent.com/u/10077853?v=3","gravatar_id":"","url":"https://api.github.com/users/dropyghost","html_url":"https://github.com/dropyghost","followers_url":"https://api.github.com/users/dropyghost/followers","following_url":"https://api.github.com/users/dropyghost/following{/other_user}","gists_url":"https://api.github.com/users/dropyghost/gists{/gist_id}","starred_url":"https://api.github.com/users/dropyghost/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dropyghost/subscriptions","organizations_url":"https://api.github.com/users/dropyghost/orgs","repos_url":"https://api.github.com/users/dropyghost/repos","events_url":"https://api.github.com/users/dropyghost/events{/privacy}","received_events_url":"https://api.github.com/users/dropyghost/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":19,"created_at":"2017-03-22T19:20:25Z","updated_at":"2017-04-10T12:21:55Z","closed_at":null,"body":"### Steps to reproduce\r\n\r\nI follow this step to install, not sure if miss something.\r\n\r\n1 - Install Npgsql \"Install-Package Npgsql\" This install 3.2.1\r\n2 - Install VSIX https://marketplace.visualstudio.com/items?itemName=RojanskyS.NpgsqlPostgreSQLIntegration\r\n3 - Install EntityFramework6.Npgsql from Nuget Latest Stable 3.1.1\r\n\r\nOpen Visual Studio without any solution \r\nTry to create a new connection on the Server Explorer\r\n\r\nThe weird part is I already did those same steps last week before format my PC for second time as Show [Here](https://github.com/npgsql/npgsql/issues/1498)\r\n\r\nAfter getiing the error installing the microsoft fix [Here at the end](https://github.com/npgsql/npgsql/issues/1445) *dont know how reference one specific comment*\r\n\r\n### The issue\r\n\r\n![image](https://cloud.githubusercontent.com/assets/10077853/24216089/51afa6fe-0f11-11e7-8919-997ef242f906.png)\r\n\r\nAnd cant use the Npgsql Provider\r\n\r\n![image](https://cloud.githubusercontent.com/assets/10077853/24216219/ca8f6d20-0f11-11e7-836e-612c58904da8.png)\r\n\r\nThe activity log:\r\n\r\n ```\r\n <entry>\r\n    <record>435</record>\r\n    <time>2017/03/22 18:58:07.974</time>\r\n    <type>Error</type>\r\n    <source>VisualStudio</source>\r\n    <description>LegacySitePackage failed for package [NpgsqlVSPackage]Source: &apos;Npgsql.VSIX&apos; \r\nDescription: Could not load file or assembly &apos;Microsoft.VisualStudio.Data.Framework,\r\n Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a&apos; or one of its\r\n dependencies. El sistema no puede encontrar el archivo especificado.\r\n&#x000D;&#x000A;System.IO.FileNotFoundException: Could not load file or assembly \r\n&apos;Microsoft.VisualStudio.Data.Framework, Version=15.0.0.0, Culture=neutral, \r\nPublicKeyToken=b03f5f7f11d50a3a&apos; or one of its dependencies. El sistema no \r\npuede encontrar el archivo especificado.&#x000D;&#x000A;File name: \r\n&apos;Microsoft.VisualStudio.Data.Framework, Version=15.0.0.0, Culture=neutral, \r\nPublicKeyToken=b03f5f7f11d50a3a&apos;&#x000D;&#x000A;   at \r\nNpgsql.VSIX.NpgsqlVSPackage.Initialize()&#x000D;&#x000A;   at \r\nMicrosoft.VisualStudio.Shell.Package.Microsoft.VisualStudio.Shell.Interop.IVsPackage.SetSite(IServiceProvider sp)\r\n&#x000D;&#x000A;&#x000D;&#x000A;AVS: El registro del enlace de ensamblado est&#x00E1; \r\ndesactivado.&#x000D;&#x000A;Para habilitar el registro de errores del enlace de ensamblado, \r\nestablezca el valor de Registro [HKLM\\Software\\Microsoft\\Fusion!EnableLog] (DWORD) como \r\n1.&#x000D;&#x000A;Nota: existe una disminuci&#x00F3;n del rendimiento asociada registro\r\n de errores del enlace de ensamblado.&#x000D;&#x000A;Para desactivar esta caracter&#x00ED;stica, \r\nelimine el valor de Registro [HKLM\\Software\\Microsoft\\Fusion!EnableLog].&#x000D;&#x000A;\r\n</description>\r\n    <guid>{EF991DC4-3119-4ED6-BDB3-C160CA562560}</guid>\r\n    <hr>80070002</hr>\r\n    <errorinfo></errorinfo>\r\n  </entry>\r\n  <entry>\r\n    <record>436</record>\r\n    <time>2017/03/22 18:58:07.980</time>\r\n    <type>Error</type>\r\n    <source>VisualStudio</source>\r\n    <description>SetSite failed for package [NpgsqlVSPackage](null)</description>\r\n    <guid>{EF991DC4-3119-4ED6-BDB3-C160CA562560}</guid>\r\n    <hr>80070002</hr>\r\n    <errorinfo></errorinfo>\r\n  </entry>\r\n  <entry>\r\n    <record>437</record>\r\n    <time>2017/03/22 18:58:07.981</time>\r\n    <type>Error</type>\r\n    <source>VisualStudio</source>\r\n    <description>End package load [NpgsqlVSPackage]</description>\r\n    <guid>{EF991DC4-3119-4ED6-BDB3-C160CA562560}</guid>\r\n    <hr>80070002</hr>\r\n    <errorinfo></errorinfo>\r\n  </entry>\r\n```\r\n\r\n\r\n\r\n### Further technical details\r\n\r\nEntityFramework6 Runtime v4.0.30319\r\nNpgsql Runtime v4.0.30319\r\nWindows 10\r\nVisual Studio 2015 Update 3\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/comments/292933451","html_url":"https://github.com/npgsql/npgsql/issues/1506#issuecomment-292933451","issue_url":"https://api.github.com/repos/npgsql/npgsql/issues/1506","id":292933451,"user":{"login":"kenjiuno","id":5955540,"avatar_url":"https://avatars2.githubusercontent.com/u/5955540?v=3","gravatar_id":"","url":"https://api.github.com/users/kenjiuno","html_url":"https://github.com/kenjiuno","followers_url":"https://api.github.com/users/kenjiuno/followers","following_url":"https://api.github.com/users/kenjiuno/following{/other_user}","gists_url":"https://api.github.com/users/kenjiuno/gists{/gist_id}","starred_url":"https://api.github.com/users/kenjiuno/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kenjiuno/subscriptions","organizations_url":"https://api.github.com/users/kenjiuno/orgs","repos_url":"https://api.github.com/users/kenjiuno/repos","events_url":"https://api.github.com/users/kenjiuno/events{/privacy}","received_events_url":"https://api.github.com/users/kenjiuno/received_events","type":"User","site_admin":false},"created_at":"2017-04-10T12:21:55Z","updated_at":"2017-04-10T12:21:55Z","body":"> I clear the ComponentModelCache Folder. Didnt solve the problem.\r\n\r\n@dropyghost I have noticed that we need to clear existing Npgsql installations for trouble shooting.\r\n\r\n1. Delete Npgsql from GAC. `gacutil /u Npgsql` using `Developer Command Prompt For VS2015` or such with Administrator privileges.\r\n   Or uninstall `Npgsql ***` from Control Panel if the assembly is locked down by `<WINDOWS_INSTALLER>`.\r\n1. Delete `Npgsql.dll` from `C:\\Program Files (x86)\\Microsoft Visual Studio 14.0\\Common7\\IDE\\PrivateAssemblies`\r\n1. Edit `%LOCALAPPDATA%\\Microsoft\\VisualStudio\\14.0\\devenv.exe.config`.\r\n   1. Remove `<dependentAssembly>` for Npgsql if exists: \r\n\r\n   ```xml\r\n\t\t\t<dependentAssembly>\r\n\t\t\t\t<assemblyIdentity name=\"Npgsql\" publicKeyToken=\"5d8b90d52f46fda7\" culture=\"neutral\"/>\r\n\t\t\t\t<bindingRedirect oldVersion=\"0.0.0.0-3.2.2.0\" newVersion=\"3.2.2.0\"/>\r\n\t\t\t\t<codeBase version=\"3.2.2.0\" href=\"C:\\Users\\Sola\\AppData\\Local\\Microsoft\\VisualStudio\\14.0\\Extensions\\wnxdk3gq.aet\\Npgsql.dll\"/>\r\n\t\t\t</dependentAssembly>\r\n   ```\r\n\r\n   2. Remove `<DbProviderFactories>` for Npgsql if exists:\r\n\r\n   ```xml\r\n    <system.data>\r\n      <DbProviderFactories>\r\n        <add name=\"Npgsql Data Provider\" invariant=\"Npgsql\"\r\n             description=\"Data Provider for PostgreSQL\"\r\n             type=\"Npgsql.NpgsqlFactory, Npgsql\" />\r\n      </DbProviderFactories>\r\n    </system.data>\r\n   ```\r\n\r\n1. Same for `C:\\Program Files (x86)\\Microsoft Visual Studio 14.0\\Common7\\IDE\\devenv.exe.config`\r\n\r\n1. Same for `C:\\Windows\\Microsoft.NET\\Framework\\v4.0.30319\\Config\\machine.config`\r\n\r\n1. Same for `C:\\Windows\\Microsoft.NET\\Framework64\\v4.0.30319\\Config\\machine.config`"}}
{"actor":{"display_login":"kenjiuno"}}