DDEX VSIX fix for VS2015 retail. #718

kenjiuno · Aug 17, 2015

Hi.

This is pr for #598 DDEX VSIX for VS2015 retail.

Non gac install. Npgsq.dll is installed with NpgsqlDdexProvider vsix package.
The optional setup process allows you to define <DbProviderFactories> at C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\devenv.exe.config instead of machine.config.
EFv6 EDM wizard (edmx file) should work.

Known problem(s):

DataSet designer doesn't work well for now. It loses Password property and it fails to connect.

kenjiuno · Aug 17, 2015

(Check official doc http://www.npgsql.org/doc/ddex/)

NpgsqlDdexProvider v3.0.4 Setup insturction:

Setup_NpgsqlDdexProvider.exe
Run VisualStudio, [TOOL]→[Setup Npgsql DbProviderFactories...]
At C#/VB.NET project, try [Check Npgsql project installation] in project's popup menu on Solution Explorer.

NpgsqlDdexProvider v3.0.0-3.0.3 Setup insturction:

NpgsqlDdexProvider will ask you to install on first use.

Exit the VisualStudio.
And then, run VisualStudio as an Administrator!

Select Setup NpgsqlDdexProvider... in TOOLS menu.
Note: It should be done per VisualStudio. It isn't needed for each solution and project.

It asks permission to modify your devenv.exe.config:

This will add the Npgsql in devenv.exe.config:

  <system.data>
    <DbProviderFactories>
      ...
      <remove invariant="Npgsql" />
      <add name="Npgsql Data Provider" invariant="Npgsql" description=".Net Data Provider for PostgreSQL" type="Npgsql.NpgsqlFactory, Npgsql, Version=3.0.0.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" />
    </DbProviderFactories>
  </system.data>

Setup succeeded.

Restart the Visual Studio once.

New! Dec 22, 2015
NpgsqlDdexProvider 3.0.4 provides [Check Npgsql project installation] in project's context menu.

Click a button to start the check!

It will suggest them if you need one or more actions:

[Test and result] shows test cases and their results:

You will be able to generate models with Entity Data Model wizard after restarting Visual Studio 2015.

References:

Server Explorer trouble shooting: https://github.com/kenjiuno/Npgsql/wiki/Server-Explorer-trouble-shooting
EDM wizard trouble shooting: https://github.com/kenjiuno/Npgsql/wiki/EDM-wizard-trouble-shooting

kenjiuno · Aug 17, 2015

My private build is available at https://github.com/kenjiuno/Npgsql/releases/tag/NpgsqlDdexProvider

roji · Aug 17, 2015

Thanks @kenjiuno, I'll try to review this ASAP!

roji · Aug 24, 2015

@kenjiuno, I don't know have enough time at the moment to dive into VSIX - you can go ahead and merge this when you feel it's OK. Some comments:

It seems weird to have a menu option for setting up the DDEX provider, can't this automatically be part of the installation instead? Any reason to make this optional?
Do you want to fix the DataSet designer before merging? Or is the VSIX usable enough to be published?
Before merging to develop can you please squash all commits into one with git rebase?
After merging to develop we should also cherry-pick this to 3.0.2 (or a later minor version)
I'll take care of building the VSIX on the build server, and then we can start publishing it on the Visual Studio Gallery too.

kenjiuno · Aug 27, 2015

Hi. @roji Thanks for checking this!

It seems weird to have a menu option for setting up the DDEX provider, can't this automatically be part of the installation instead? Any reason to make this optional?

Yes, it is ideal to process required file edits on vsix installation.

The problem is that installation is done without running Visual Studio shell (devenv.exe).
It will take much time to find out better way for now.

Do you want to fix the DataSet designer before merging? Or is the VSIX usable enough to be published?

I think many developers are interested in use of Entity Framework (EDM wizard).

I'll postpone the fix if it will take more than 1 week.

Before merging to develop can you please squash all commits into one with git rebase?

Ok, I'll do it periodically.

kenjiuno · Sep 30, 2015

Ok, new pushed commit contains Npgsql-ddex.sln and src/NpgsqlDdexProvider/Build-all-ddex.csproj for building ddex 2012,2013 and 2015 versions at once.

kenjiuno · Oct 1, 2015

We need to tweak Version attribute in 3 source.extension.vsixmanifest files dynamically:
<Identity Id="958b9481-2712-4670-9a62-8fe65e5beea7" Version="3.0.0" Language="en-US" Publisher="Npgsql" />

Vs2012/source.extension.vsixmanifest
Vs2013/source.extension.vsixmanifest
Vs2015/source.extension.vsixmanifest

kenjiuno · Oct 2, 2015

Some ideas'd be done:

Add2doc: Run visual studio as admin in order to successful Setup NpgsqlDdexProvider.
Fix: use "runas" verb for Setup NpgsqlDdexProvider (elevation of Administrators privileges).
Add2doc: How many times should run Setup NpgsqlDdexProvider
Fix: Show "done nothing" if setup is already done on Setup NpgsqlDdexProvider
Add2doc: T-shooting: "Unable to add data connection, Keyword not supported: compatible. Parameter name: keyword."
Model First
Add2doc: Model first
Add2doc: supported/unsupported operations/features on EF facet. EF Power Tools

kenjiuno · Oct 19, 2015

It mentions 3 distribution types of VS's package: VSIX/MSI/VSI

Visual Studio Extension Deployment
https://msdn.microsoft.com/library/vstudio/dd393694(v=vs.100).aspx

We'll need to combine VSIX and MSI(or NSIS) in order to support EDM wizard, even if we don't use GAC since Npgsql 3.0.

VSIX package installs: NpgsqlDdexProvider, Npgsql, and EntityFramework5.Npgsql.
MSI (or NSIS) install: VSIX package, modify devenv.exe.config, and deploy SSDLToPgSQL.tt (Edited)

Single VSIX package distribution is fantastic, and may be possible, if we can prepare tooling like: Direct Code-first code-generator for PostgreSQL with Npgsql support! (without EDMX and EDM wizard)

roji · Oct 24, 2015

@kenjiuno, the last commit you added to this PR, 6276f4470dc8c202a67b5cc71115f7aebd06da25, contains some non-ASCII characters in the commit message ("build fix 2012　2015"). In UTF8 the problematic character is encoded as 0xe3 0x80 0x80, which I think is a Japanese whitespace character. This caused some trouble with the build server database, and I think in general it's probably better to stick to ASCII in commit messages...

Can you please rewrite the commit message?

kenjiuno · Oct 24, 2015

Hi.

Can you please rewrite the commit message?

Yes, I have confirmed that it is non ASCII white space.
Sorry, I didn't notice it. It looks like we type 2 ASCII space characters.
I have pushed fixed comment!

Tweak NpgsqlDdexProvider2012 configuration names.

(cherry picked from commit 658b5f9631d232c49c992b7315d8189c40e8641f)

(cherry picked from commit 766556ee2fb2d8a28fde38d03e9fa3bb5e4e1d29)

(cherry picked from commit 193df08155e9fb5f2338b534abd09b79ac06d568) Conflicts: packages/repositories.config

hypocentrum · Nov 3, 2015

Hi Kenji,
Thanks for the great work.

I have followed the instructions but I cannot choose the Npsql data provider from ADO.Net Entity Model Wizard.
I'm currently using VS2013 Update 4 and installed EntityFramework6.Npgsql straight from nuget.
Is there something I might be missing?

kenjiuno · Nov 3, 2015

Hi.

Thanks for trying NpgsqlDdexProvider!

I'll check about your issue.

2015-11-03 12:44 GMT+09:00 hypocentrum notifications@github.com:

Hi Kenji,
Thanks for the great work.

I have followed the instructions but I cannot choose the Npsql data
provider from ADO.Net Entity Model Wizard.
I'm currently using VS2013 Update 4 and installed EntityFramework6.Npgsql
straight from nugget.
Is there something I might be missing?

—
Reply to this email directly or view it on GitHub
#718 (comment).

kenjiuno · Nov 4, 2015

I'm currently using VS2013 Update 4 and installed EntityFramework6.Npgsql straight from nuget.

Please confirm if both (EntityFramework6.Npgsql and NpgsqlDdexProvider) versions are 3.0.3?

Please build your project once. It will copy files to OutputPath. And you will be able to use PostgreSQL data connection.

hypocentrum · Nov 9, 2015

Thanks!! After I built the project it worked flawlessly.

kenjiuno · Dec 30, 2015

I'll close this pr, setups are merged: 3.0.x for 82275da, (3.1.x for 79f5d1e)

Please open new issue if you encounter any problems...

kenjiuno mentioned this pull request Aug 24, 2015

Model First not supported? #424

Closed

roji force-pushed the develop branch from 707b2a9 to fb88921 Compare August 27, 2015 12:02

kenjiuno force-pushed the 598-non-gac branch from 7ec5321 to cde846f Compare August 27, 2015 14:10

kenjiuno mentioned this pull request Aug 27, 2015

Entity Data Model Wizard doesn't generate model from db #445

Closed

kenjiuno mentioned this pull request Sep 29, 2015

EF6 & Npgsql #804

Closed

kenjiuno force-pushed the 598-non-gac branch 2 times, most recently from 64fbbe0 to 277827f Compare September 30, 2015 12:32

roji force-pushed the develop branch from 91478cd to dca9b27 Compare October 7, 2015 19:25

kenjiuno force-pushed the 598-non-gac branch from 277827f to 6276f44 Compare October 20, 2015 13:55

kenjiuno mentioned this pull request Oct 23, 2015

EFv5 support on Npgsql develop #828

Merged

2 tasks

kenjiuno force-pushed the 598-non-gac branch from 6276f44 to 58f84da Compare October 24, 2015 09:26

kenjiuno added 8 commits October 25, 2015 22:33

DDEX VSIX fix for VS2015 retail. 2015/09/30

9c5c18a

Some changes?

d6dbbc7

NpgsqlDdexProvider2015 went into NpgsqlDdexProvider.

9721684

Tweak NpgsqlDdexProvider2012 configuration names.

nsis included.

d37eab1

Model gen.

8dc4953

version hack

5d23a33

(cherry picked from commit 658b5f9631d232c49c992b7315d8189c40e8641f)

EFv5 provider redir.

3064bf6

(cherry picked from commit 766556ee2fb2d8a28fde38d03e9fa3bb5e4e1d29)

Checker wip

254e978

(cherry picked from commit 193df08155e9fb5f2338b534abd09b79ac06d568) Conflicts: packages/repositories.config

kenjiuno added 2 commits October 25, 2015 22:33

build fix 2012 2015 and so on

d7b4bba

refine checker.

17b927f

kenjiuno force-pushed the 598-non-gac branch from 58f84da to 17b927f Compare October 25, 2015 16:01

kenjiuno added 2 commits October 29, 2015 22:11

A little bit wizard.

1279cc6

Support nuget invoke.

50527bd

kenjiuno mentioned this pull request Oct 31, 2015

Installer for Npgsql (into the GAC) #128

Closed

roji force-pushed the develop branch from 8f20b42 to 82829b4 Compare December 6, 2015 11:03

roji force-pushed the develop branch from 50ac853 to 90b2b9e Compare December 17, 2015 09:27

roji force-pushed the develop branch from 09b533c to c028b22 Compare December 27, 2015 10:02

kenjiuno closed this Dec 30, 2015

This was referenced Jan 3, 2016

Cleanup for NpgsqlDdexProvider. #931

Closed

Initial DDEX support : new pr #213

Merged

Search code, repositories, users, issues, pull requests...

DDEX VSIX fix for VS2015 retail. #718

DDEX VSIX fix for VS2015 retail. #718

Uh oh!

Conversation

kenjiuno commented Aug 17, 2015

Uh oh!

kenjiuno commented Aug 17, 2015

Uh oh!

kenjiuno commented Aug 17, 2015

Uh oh!

roji commented Aug 17, 2015

Uh oh!

roji commented Aug 24, 2015

Uh oh!

kenjiuno commented Aug 27, 2015

Uh oh!

kenjiuno commented Sep 30, 2015

Uh oh!

kenjiuno commented Oct 1, 2015

Uh oh!

kenjiuno commented Oct 2, 2015

Uh oh!

kenjiuno commented Oct 19, 2015

Uh oh!

roji commented Oct 24, 2015

Uh oh!

kenjiuno commented Oct 24, 2015

Uh oh!

hypocentrum commented Nov 3, 2015

Uh oh!

kenjiuno commented Nov 3, 2015

Uh oh!

kenjiuno commented Nov 4, 2015

Uh oh!

hypocentrum commented Nov 9, 2015

Uh oh!

kenjiuno commented Dec 30, 2015

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

3 participants