No EDMX diagram generated after “EF with designer” wizard in postgresql

Question

1.00/5 (2 votes)

See more:

I am working with EntityFramework6.npgsql I am creating "EF designer with database", It does not show any error but no diagram present in the edmx file. Also lots of "reference missing" errors occur. Image is attached after generating "EF with designer"

What I have tried:

I have tried to change versins of dll files also

Posted 27-Feb-18 20:46pm

Sudhir Dehade

Updated 28-Feb-18 1:50am

v2

Add a Solution

Comments

Maciej Los 28-Feb-18 3:30am

We can't read in your mind and also do not have an access to you HDD. Can you be more specific and provide more details about your issue?

Sudhir Dehade 28-Feb-18 7:27am

Have you ever used entity-framework..?
If yes then you should know what I am talking, I want to generate model diagram "Entity Data Model XML" i.e. EDMX. All process goes fine but there is no entities generated in the EDMX diagram....

Maciej Los 28-Feb-18 7:41am

Wow!
It's very interesting statement: "All process goes fine", especially when you wrote in your question: "Also lots of "reference missing" errors occur"...
First thought: NuGet packet is not installed properly, but seems you don't need our help, because you don't want to share details.

phil.o 28-Feb-18 8:21am

Being rude to people actually trying to help you will lead you nowhere near any solution.

Sudhir Dehade 1-Mar-18 6:32am

I am not being rude.. It was a question that if you used it or not??

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2018-02-28T01:51:00

Solution 1

Please, refer this:
Fanda's development blog: Npgsql with Entity Framework 6[^]
PostgreSQL and Entity Framework 6 Code First – Learning to Code[^]

Quote:
Because Npgsql doesn't support schema creation, you must create database manually and you can use this line to skip schema migrations and creation/updates.

Posted 28-Feb-18 1:51am

Maciej Los

Updated 28-Feb-18 2:16am

v3

Comments

Sudhir Dehade 28-Feb-18 7:52am

Thank You.. !

Maciej Los 28-Feb-18 7:53am

You're very welcome.
BTW: you should accept my answer as a solution (green button), if it helped you to solve your problem.

Sudhir Dehade 28-Feb-18 8:10am

My problem still not solved, the blog you suggested I have done all that before, but I am unable to get "why .edmx diagram is not generating??"....
As that diagram is not generated when I build the solution I get errors like
"Error 6004: The table 'DBName.public.TableName' is referenced by a relationship, but cannot be found. [SolutionName] [Path of EDMX file]."
No classes present in ".tt" file..

Sudhir Dehade 28-Feb-18 8:25am

I have existing database...
" you can use this line to skip schema migrations and creation/updates. " what do you mean by this??

phil.o 28-Feb-18 8:26am

It appears code-first approach is not supported with npgsql.
You have to use the database-first approach, apparently.

Sudhir Dehade 28-Feb-18 8:37am

There are 4 option in "Choose Model Contents" Wizard
1. EF Designer from DB.
2. Empty EF designer model
3. Empty Code First Model
4. Code First from DB

Which I suppose to select...???
And Thank you for your replies till now...