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
2
votes
1 answer

Entity Framework: association between two edmx models

I have a bigger project that uses multiple edmx files to manage the data model for an asp.net application. What I want to achieve is to link two entities accross two edmx models. So basically, just a foreign key like this: EntityA.ForeignEntityId…
Cleo
  • 620
  • 2
  • 10
  • 32
2
votes
0 answers

EntityFramework database first exposing generated class as Datacontract

I made a webservice which is supposed to return an entity 'UserProfile'. Most operations return the expected result but I get empty responses when I directly return a generated class. Service: List IMusicOwnerService.getProfiles() …
user22015
  • 23
  • 4
2
votes
1 answer

How to preserve the Model.Context.cs file header content after updating model from db with Entity Framework?

The Model.Context.cs file is automatically generated when using Entity Framework Database First. I have modified the header part of the class to be compatible with a Unit of Work and Repository pattern: public partial class MyDatabaseContext :…
ElHaix
  • 12,846
  • 27
  • 115
  • 203
2
votes
0 answers

Create parent object with child collection - "Framework 4.1 MVC 3.0"

I would like to know how can I create parent object with its child collection in one step using ADO.net Entity Data Model. Example: This is the parent object "Video" and its Child VideoData Diagram I need to create video object with Video data…
1
vote
1 answer

ADO.NET Entity Data Model extension not working

I want to develop a Visual Studio extension to add extra properties on entity types. As suggested in the answer to a related question I had asked before, I have installed the ADO.NET Entity Data Model Designer Extension Starter Kit as the first…
1
vote
1 answer

How to integrate my own structural annotations engine in the Entity Framework designer?

In the accepted answer to this SO question there is an explanation about structural annotations, a way to customize the data on the EDMX files generated by the Entity Framework designer. This feature is used by the Portable Extensible Metadata…
Konamiman
  • 49,681
  • 17
  • 108
  • 138
1
vote
0 answers

Entity Framework: how to add an association, based on an existing property

I'm using the database-first approach while setting my first steps in Entity Framework. In my SQL Server database I have two tables, Location and Area. Both have an Id column and the Location table already has an AreadId property. I would like to…
Dominique
  • 16,450
  • 15
  • 56
  • 112
1
vote
3 answers

Eroor "Could not load file or assembly MySql.data" when trying to add a new database connection

I'm trying to add a new MySql database connection. My version of MySql.Data is 6.9.9.0 and is referenced as this in my EFModel project's app.config and in the Nuget Package Manager of the project. When I test it, the connection with my server is…
1
vote
1 answer

I can't update my edmx since the Entity Data Model Designer is unable to open it

Hi everyone and thanks for taking the time to see my question. I'm running VS 2017 with Entity Framework 6 and asp.net MVC and have to add some field to one of my Entities. I added the corresponding fields in the database, but when I open the edmx…
Pierrick Martellière
  • 1,554
  • 3
  • 21
  • 42
1
vote
2 answers

Entity Framework Error unable to load the specified metadata resource

Yes I did read and try entity framework Unable to load the specified metadata resource I typically use code first and have had no issues. However I needed to troubleshoot a project with EDMX Context: public partial class x500Entities : DbContext { …
user6321478
1
vote
1 answer

why the Model.tt classes will not get updated when i chose to update my .edmx file from database

i am working on an asp.net mvc-4 web application . and i am using Entity Framework 5. where i mapped my database tables using EF. now i use to have the following model class inside my .tt folder:- public partial class CustomAsset { …
John John
  • 1
  • 72
  • 238
  • 501
1
vote
1 answer

IBM Data Server EF 6 Provider for Entity Framework 6 - Limitations - Possible Workarounds

I have downloaded EntityFramework 6 and EntityFramework.IBM.DB2 (6.0.1) available on nuget.org and also installed IBM add-in for visual studio 2015. During EDMX creation i'm getting the below error (which is already specified in the readme.txt file…
Ramu
  • 343
  • 1
  • 6
  • 21
1
vote
0 answers

Referential Constraint Box Shows Too Many Fields

I am trying to set up a reference between two tables using Visual Studios EDMX Designer. The two tables have a number of fields that are named the same, these are used for logging purposes. When I create the link, the Referential Constraint dialog…
Gavin Coates
  • 1,366
  • 1
  • 20
  • 44
1
vote
0 answers

Updating the EDMX file brings in massive tables

HI I have one table used in this code, C#. I added 2 columns to the table and now want to update the model. I right click to open the EDMX file, I put the cursor in the blue diagram, right click to update model from database, I choose refresh and…
user3167167
  • 93
  • 2
  • 9
1
vote
0 answers

Entity Framework, how to treat a view as a child table

I have a table, call it Transaction, and a view, call it TransactionExtra, which is based on Transaction, e.g., create view TransactionExtra select t.id as t_id, x.* from Transaction t join X x on .... In Entity Framework, I'd like to be able to…
tpdi
  • 34,554
  • 11
  • 80
  • 120