You may be changed the assembly name of the project that contained the model. The reference to the original assembly was still in the client application. ASP.net Web Application : – Manually delete dll and pdb files. ASP.net Web Site: – Perform an IIS reset then flush out the asp.net temporary files in the folder … Read more
Craig Stuntz does a good job of explaining that it is the designer related xml (the positions of entities and associations etc on the design surface) that causes most of the problems here. Conflict resolution within the edmx:Runtime element however, is very achievable. The best strategy for dealing with conflicts in the designer related xml … Read more
This problem occurs to me when a try to define type and size of a column with DataAnnotations. BAD: [Column(TypeName=”VARCHAR(254)”)] public string ColumnName { get; set; } OK: [MaxLength(254)] [Column(TypeName=”VARCHAR”)] public string ColumnName { get; set; }
With EF6 Tools & Visual Studio 2013 or Visual Studio 2012, you get the option code first from database (see screenshot below) If you don’t see this option you need to install Entity Framework 6 Tools for Visual Studio 2012 & 2013 http://www.microsoft.com/en-gb/download/details.aspx?id=40762 This doesn’t convert an EDMX to code first (as requested in question), … Read more
I was getting an exception like this. The problem was that I renamed my .edmx file and forgot to change the name in EF Web.config file’s connection string: metadata=res://*/MyModel.csdl|res://*/MyModel.ssdl|res://*/MyModel.msl;
Open the install media for VS2010 and browse to “:\WCU\EFTools”. Her you will find two files: ADONETEntityFrameworkTools_enu.msi ADONETEntityFrameworkTools_enu.cab Copy those files to a folder on your PC. Create a log file in the folder – for instance with the name “Log.txt” Open a cmd prompt (possibly run the cmd prompt as administrator) and navigate to … Read more
Setting the compatibility level of the database to 110 has worked for me. To check the compatibility level, run this script: select compatibility_level from sys.databases where name=”<YOUR_DB_NAME>” To set the compatibility level, use this script: alter database <YOUR_DB_NAME> set compatibility_level = 110
In my case am not allowed to modify existing tables but I discovered that when you add a new table with “Include foreign key columns in the model” checked in EF4 and the table doesn’t contain any foreign key relationships then you try to add a association it will trigger this error. Defining Constraints in … Read more
Don’t pass db models directly to your views. You’re lucky enough to be using MVC, so encapsulate using view models. Create a view model class like this: public class EmployeeAddViewModel { public Employee employee { get; set; } public Dictionary<int, string> staffTypes { get; set; } // really? a 1-to-many for genders public Dictionary<int, string> … Read more
Updating an EDMX the safe way: As you have found, the update from database does not always change existing properties correctly. From our day-to-day use of EDMX updating (100s of updates over 24 months), I would recommend the following sequence for updating an EDMX. Delete existing model and then update: Open the EDMX designer Ctrl-A … Read more