Questions tagged [edmx]

An .edmx file is an XML file in the .Net Entity Framework that defines a conceptual model, a storage model, and the mapping between these models.

Resources:

How to Create an edmx

The Entity Framework and ASP.NET

edmx File Overview

781 questions
6
votes
3 answers

Can't open EDMX-file in designer

It opens as XML file only. In MS VS 2010 Ultimate + SP1. I need to open it in model-designer. What can I do??
Monochromie
  • 439
  • 5
  • 17
6
votes
1 answer

Visual Studio 2019 .EDMX Update Model From Database Does not work

@ajcvickers I am also facing the same issue.. My web project was created in VS 2015 then after 1 years I start the development on 2017 and just few days back we jumped to 2019 but seems like the same steps working in VS2017 but not in VS2019 --…
vijay sahu
  • 765
  • 1
  • 7
  • 29
6
votes
0 answers

In 2017, what is the best way to migrate an entity framework application away from using EDMX while preserving the relationships

I've seen a number of old question's asking the same (Tool to convert Entity Framework EDMX to Code First) but most back in 2009-2014 (EF "Model First": Create entity in edmx and db-table from class? / How to generate Entity Framework 6.x POCO…
Shawson
  • 1,858
  • 2
  • 24
  • 38
6
votes
2 answers

Datetime2 conversion in EF4

well, after having spent endless time googling for an answer , i have to add another question in this matter... i have a table with 2 datetime fields, generated by EF4 EDMX designer in VS 2010. the generated fields in SQL 2008 are datetime and not…
user300435
  • 95
  • 5
6
votes
1 answer

why Entity Framework mapped a table named "People" as an entity named "Person" inside my .edmx file

I am working on an asp.net mvc-4 web application and i am using Entity Framework 5.0 . now i have mapped my sql server 2008 tables using entity framework with database first approach. but i got this strange issue after completing the mapping, now…
John John
  • 1
  • 72
  • 238
  • 501
6
votes
1 answer

Entity framework error on updating model from database and vice versa

Here is what happens when I try to update model from database with VS express 2013 for the web, EF6.1.1 and .NET framework 4.5. In this case I just added a field to a table in the table definition and updated the database. After that I right click…
Boidot
  • 363
  • 1
  • 6
  • 18
6
votes
2 answers

How to convert complex type to actionresult

I am new to MVC, and trying to call a stored proc from the controller. In the model I have edmx which has all stored procs as functions Cannot implicitly convert type System.Collections.Generic.IEnumerable to…
Vignesh Subramanian
  • 7,161
  • 14
  • 87
  • 150
6
votes
1 answer

Edmx need Primary_Key?

Its a problem While Creating Edmx in .net that on creating Edmx of DataBase only those Tables and views are added who had a primary key. This problem resolved easily but just making a column primary key in Table or View but i didn't got the actual…
Amit Bisht
  • 4,870
  • 14
  • 54
  • 83
6
votes
2 answers

How to execute raw sql query with in entity framework?

I'm using asp.net mvc 3 with entity framework 5. I have my .edmx file & able to interact with my database using linq or SP, but I want to run some raw sql statement. I'm trying something like this: Using(var ctx=new HREntities()) { …
Badhon Jain
  • 938
  • 6
  • 20
  • 38
6
votes
2 answers

Why would the entityAspect of my query items be null?

Working with breeze backed by SharePoint, as described here, and using TypeScript rather than JS. In a DataService class I create an EntityManager and execute a Query: private servicePath: string = '/api/PATH/'; private manager:…
Jude Fisher
  • 11,138
  • 7
  • 48
  • 91
5
votes
2 answers

EF 4.3.1 with VS 2011

I need to know if it is possible to start using the latest version of EF (4.3.1) with VS 2011 without having to install these CTP components as stated here. I had these components installed but I removed them and since then I can't add a new edmx…
Socardo
  • 520
  • 6
  • 14
5
votes
1 answer

Specifying location of .csdl / .ssdl / .msl Metadata files within the output assembly

I have an EF project that containing my data model that I have been successfully using. The "Metadata Artifact Processing" option is set to "Embed in Output Assembly". As the .edmx file was in the root folder of the project the metadata string used…
GrandMasterFlush
  • 6,269
  • 19
  • 81
  • 104
5
votes
2 answers

Manually added stored procedures in edmx file

Is it possible to persistently add the manually added stored procedures in the edmx file? The database is generated from model. Every time I change something within the editor in the edmx file, the stored procedures are lost. Only the FunctionImport…
niklr
  • 1,671
  • 3
  • 24
  • 40
5
votes
1 answer

Entity framework, multiple edmx to share connection string - is it possible?

I saw a number of related questions but none of them is exactly what I am looking for. We are using one database and need to have separated edmx files, with different Model and ObjectContext class names. This results in having multiple connections…
Paul
  • 1,879
  • 1
  • 23
  • 44
5
votes
2 answers

Is it possible to update a sql database schema from an edmx in Visual Studio 2008?

So with LINQ-to-SQL I know you can update the database from the LINQ objects and update the LINQ objects from the SQL. I am using LINQ's entity framework (a.k.a. LINQ-to-entities) and I can update the entities from the SQL database, but I can't…
Phobis
  • 7,524
  • 10
  • 47
  • 76