Questions tagged [edmx-designer]

The edmx Designer is a tool that enables point-and-click modification of an .edmx file representing a conceptual/storage model defined using Microsoft Entity Framework.

The ADO.NET Entity Data Model Designer (Entity Designer or edmx Designer) is a tool that enables point-and-click modification of an .edmx file. It can be used to visually create and modify entities, associations, mappings, and inheritance relationships. It can also be used to validate an .edmx file.

The edmx Designer consists of the following components:

  • A visual design surface for editing the conceptual model. The user can create, modify, or delete entities and associations.
  • A Mapping Details window for viewing and editing mappings. The user can map entity types or associations to database tables, columns, and stored procedures. For more information, see Mapping Details Window (Entity Data Model Designer).
  • A Model Browser window that provides tree views of the conceptual model and the storage model. For more information, see Model Browser Window (Entity Data Model Designer).
  • Toolbox controls for creating entities, associations, and inheritance relationships.

The edmx Designer is integrated with Visual Studio components.

The edmx Designer works with an .edmx file. An .edmx file is the combination of three metadata files:

  1. the conceptual schema definition language (CSDL)
  2. store schema definition language (SSDL)
  3. mapping specification language (MSL) files.

When the Entity Data Model Wizard runs, an .edmx file is created and added to the solution. This file is automatically opened in the edmx Designer when the Entity Data Model Wizard finishes. The .edmx file can also be opened in the edmx Designer by double-clicking it in Solution Explorer.

Resources

MSDN

97 questions
1
vote
0 answers

How to fix the error "The ObjectContext instance has been disposed" when we already included the entity?

The answer looks like obvious, but, what I am facing is different. I have 3 tables.. Clients related to Users that is related to Messages. The idea is that I can have a message sent from somebody or nobody, but, always will have a…
Dan
  • 1,518
  • 5
  • 20
  • 48
1
vote
0 answers

SQLite ef edmx designer in Visual Studio 2013 update 4 for database first targetting .net framework 4

I have been trying to get the SQLite install package to work with my setup.I need to target the .Net Framework 4 but it seems like to get design support for Studio 2013 I had to install the SQLite 4.5.1 package. I spent much time just getting the…
1
vote
1 answer

T4 doesnt generate KEY when key exists in database view & in EDMX

We are using EF6.1.1 I have a database view. The view has "ID" column and is not nullable. I added that view on edmx designer. I notice the key icon infront for "ID" column in the designer. When I right click on "ID" column on the designer I also…
LP13
  • 30,567
  • 53
  • 217
  • 400
1
vote
2 answers

EDMX is overwriting Key data annotations

This applies to EF 5 and database first modeling. My model was built useing the EF generator from an existing DB. I'm using the [Key] data annotation in my model classes because the primary key fields have names that are not in line with EF…
tintyethan
  • 1,772
  • 3
  • 20
  • 44
1
vote
1 answer

How to create a model using .edmx designer in visual studio 2012?

I'm new with Entity Framework 5.0. I'm looking for a tutorial on how to create a DB model using the .edmx designer in visual studio 2012.
1
vote
0 answers

Unexpected result of Generate Database from Entity Model. What goes wrong?

With Entity Framework I have a database with a conceptual model different from the physical storage model. When I ask the model to generate the database from model, a SQL script is created according to the conceptual model. When I ask to update…
user1885610
1
vote
0 answers

EntityFramework model with multiple keys

I am trying to create EDMX model for existing database, the DB has the following schema (not the best one, but this is what i have and i can not change it): Table: ObjectTypes (ObjectTypeID "Identity", ObjectName) Data: 1, Customer Data: 2,…
Alex Dn
  • 5,465
  • 7
  • 41
  • 79
0
votes
1 answer

How to add navigation property for entity in different edmx file

I have two .edmx files each containing different entities, using the same database. On file one i have my app logic entities, one of them is a table called Report. On the other file i have infrastructure entities such as User table and some…
Michael
  • 22,196
  • 33
  • 132
  • 187
0
votes
0 answers

Changing default T4 template for new EDMX files

How do I force VS to choose a custom template when creating EF models? Details: I built a custom template for generating EF entity classes from models. The solution has many projects with their own models and it is likely more will be added over…
0
votes
0 answers

Alternate way to get to "Update model from Database" and Model Browser without opening up edmx file using ADO.NET Entity Model Designer?

The edmx file is taking a long time to load. It's taken 3.5 minutes. That is one problem. I open up the edmx file using ADO.NET Entity Model Designer only to get to "Update model from Database" and also Model Browser. Is there a way to get to them…
user79284
  • 175
  • 1
  • 2
  • 18
0
votes
1 answer

Entity Framework won't detect foreign key from database

I've got two tables - Appointment and User. Appointments can be linked to two different Users - a student and a member of staff. The Appointment table contains two foreign keys: StaffUsername and ExternalID. These reference columns in the User table…
Philip Stratford
  • 4,513
  • 4
  • 45
  • 71
0
votes
2 answers

I can update database table from edmx model?

Is possible update database table from edmx model, for example if I create a new field in edmx diagram to a table, I want update corresponding mapped table in database adding this new field ... in visual studio menu I find the voice "update model…
0
votes
0 answers

EDMX canvas and generating a database from Model question

I generated the database from the model now I notice that all the tables have an "s" appended to then Userid object transloated to Userids in SQL. which nwhen I run the code Userid userid = db.Userids.Find(id); gives me this…
R.Merritt
  • 477
  • 5
  • 17
0
votes
1 answer

Exporting edmx diagram from edmx designer cut off tables using PDFCreator

I am trying to export edmx diagram from the edmx designer in Visual Studio 2013 to a png image using PDFCreator. The problem I have is that PDFCreator cut off some tables. In PDFCreator I select ARCH E3 as paper size. Also it is exported to png…
Willy
  • 9,848
  • 22
  • 141
  • 284
0
votes
0 answers

Cannot add junction tables (as a result of many to many relationship) to entity data model designer (edmx)

I have a database model in entity framework. The edmx has some tables and now I am trying to add two new ones (they are junction tables). I have seen that someone added these 2 tables in the past but for some reason these tables were not being shown…
Willy
  • 9,848
  • 22
  • 141
  • 284