edmx

Exporting a large Entity Framework Diagram

I have a fairly large Entity Diagram. I tried to export it to an image, unfortunately because it's so large the image comes out all pixelated. See this link http://connect.microsoft.com/VisualStudio/feedback/details/534574/edmx-model-image-export-pixelation for the error report (made by someone else). So I was wondering is there anothe...

edmx file to an XML document

Can I connect an edmx to an xml document instead of a sql database.If so how can this be done? ...

Problems with EDM associations

Hi, I'm making an OData service and using an EDM to map the structure of my database and specify associations between tables and create Navigation Properties. I've imported my tables into the EDM using the wizard. Things compile fine until I put in associations. I'm sure I've been able to do this before but for some reason it is screwi...

Entity read stored procedure mapping?

So I have a customer requirement to only use stored procedures for all database operations. I created CRUD stored procedures for each of my tables, and then created my Entity models. So I see easily how to map my Insert, Update and Delete stored procedures to my entity (Customer for example), but there seems to be no way to map my Sele...

Upgrade/update SQL database to new schema version while keeping as much of the old data as possible

Im not used to work with SQL and I hardly know any DDL-scripting at all. Im using ADO.NET Entity Framework 4 in Visual Studio 2010 with EDMX-designer and a Self-Tracking Entity Generator. It does the hard work for me and I get a DDL-script to be used to create the database when it doesnt exist. So far so good... Then I make a change in m...

How to create a computed property in Data Services (OData)?

I am creating an OData service with WCF Data Services using an EDMX. How can I create a computed property for an entity type, so that its value gets computed in the service (C#) and does not come from the database? The value of this property is based on the value of other properties, which are mapped to fields in the database. ...

importing a pre-existing edmx file is a new vs 2010 solution

Hi I started from scrath a new vs 2010 solution. How can I add a preexisting edmx file generated with the vs tool avoiding mess :)? (The cleanest way) Thanks a lot!! ...

Entity Designer Database Generation Power Pack generates datetime and not datetime2 for ProviderManifestToken = 2008

Im having trouble with the DDL-generation from EDMX using the "Entity Designer Database Generation Power Pack" add-on. It generates datetime-columns instead on datetime2 even though ProviderManifestToken is set to 2008. Can it be fixed? I don't want to do this manually all the time because Im using the model-first-approach... ...

Entity data model, unique index

In my entity data model I have an entity with one property as the primary key and another property that will have unique values too, so I’d like to create a unique index on that other property. The situation is very similar to the Person entity with the PersonID and PersonSSN fields. Is there any way to specify in the designer or in the...

Update existing EntityCollection in Entity Framework

I try to work with link to entity, and i want to work directly with my entity in my application. using System; using System.Collections.Generic; using System.Linq; using System.Text; using Calandar.Business.Manager.Data; namespace Calandar.Business.Models.Args { public class SaveExpertArgs { public ExpertEntity Expert {...