Entity Framework Model Update

c# entity-framework linq-to-entities sql-server-2008 visual-studio-2010

Question

I have just started using EF and found it cool, but I ran into a problem,

Problem:
I changed my DB schema of a column inside the table User, It was Varbinary(50) previously I then changed it into VarChar(50), and then inside the MyModel.edmx designer I chose "Update model from database", after clicking finish I received this error.

Error:

   Error 2019: Member Mapping specified is not valid.
    The type 'Edm.Binary [Nullable=False,DefaultValue=,MaxLength=100,FixedLength=False]' of member
   'Email' in type 'LearnDBModel.User' is not compatible with SqlServer.varchar 
    [Nullable=False,DefaultValue=, MaxLength=50,Unicode=False,FixedLength=False]' of member 'Email'
    in type 'LearnDBModel.Store.User'.

Let me know how to fix it

1
24
7/4/2013 3:26:45 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

I've run into similar issues before, and found that the way to solve it was to delete the table from the model. Save and close the model. Then reopen the model and re-add the table.

61
5/19/2012 6:51:18 PM

Popular Answer

Shawn de Wet's solution works fine but In case you dont want to remove the table (for example relationship to some other tables..) you can use another solution: Open your edmx file with xml Editor, Ctrl + F to find a line similar to

Property Name="Email" Type="Binary" Nullable="false" MaxLength="50" FixedLength="false"

Update it to:

Property Name="Email" Type="String" Nullable="false" MaxLength="50" Unicode="false" FixedLength="false"

Save it and rebuild.

Chris Phan

Related Questions

Instead of "Generate Database from Model," Entitiy Framework uses "Update Database from Model."

I have created a Entity Framework 4 model with Visual Studio 2010 and generated a database from it. Now I found myself adding new properties (with default values), changing documentation of columns, changing names of columns, changing types of columns several times. All tasks that do not require much "extra work" in order not to be possible to be a...
entity-framework visual-studio-2010
asked by David

Update model from database in entity framework is not working

delete the applicable table(s) from your ...model..., than select ...Update model from database..., EF usually only checks for new fields, not changes to existing fields.
c# entity-framework
asked by Jason Loki Smith

Updating models from database in Entity Framework 6.0

I'm developing a Web API Service (in Visual Studio 2013), and I've added, in my solution, ADO.NET Entity Data Model (Database First)....All the tables I've included, are correctly created in my edmx diagram....Then I've made some changes: I've added two new columns in the source database, and I've removed one column. So, when I try to update model ...
ado.net-entity-data-model c# entity-framework entity-framework-6 sql-server-2008
asked by GVillani82

Entity Framework 6 Batch Updates and AuditLog using Entity Framework Extended

I am using Entity Framework 6 and I am using EntityFramework Extended to perform some batch updates and batch deletes. The batch updates and batch deletes work OK however I also need to know the entities that were updated / deleted (i.e. the current and previous values). I thought that using the AuditLogger provided by EntityFramework.Extended wo...
entity-framework entity-framework-5 entity-framework-6 entity-framework-extended
asked by quophyie

Entity Framework 6 Model-First - Update Production Database Based On Local Changes

I'm new to EF and inherited a project that apparently used database-first development....The production environment uses SQL Azure and I'm basically trying to figure out the standard approach for updating its schema. ...At first, I tried enabling migrations for the EF project, before attempting the process described here: ...http://www.dotnet-trick...
azure-sql-database ef-database-first ef-model-first entity-framework entity-framework-6
asked by Colin

Update model causes interface to be removed from DbContext when using Effort with Entity Framework

Yes, the class is defined as a partial class. Create a new file that also declares the same partial class and add your additional methods there....As for the [Key] attribute being lost, you can try and use a ...MetadataType... attribute and put all your meta data there....namespace Cssd.IT.PortalIntegration.DataAccess.HR.Dao { using System; ...
c# effort entity-framework-6 unit-testing
asked by Robert McKee

Entity Framework's auto generated class's code gets re generated every time model is updated

I am using ADO.Net Entity Data Model which connects to a SQL Server database to generate entity classes....I am creating partial classes for the generated classes with this attribute:...[MetadataType(typeof(Employee))] ...to put ...DataAnnotations... on the fields. So I remove all fields from generated class (....g.cs...) and move them to the othe...
asp.net-mvc c# entity-framework entity-framework-6 sql-server
asked by WAQ

How to update multiple models at the same time in ASP.NET MVC 5 Entity Framework

I am trying to update Two models at the same time. ...Models: ...Page...Fields...One page has multiple fields, I want them to update at the same time. ...public class PageEditViewModel { public Page mPage { get; set; } public IEnumerable<Field> Fields { get; set; } } ...Here is my View:...<div class="row"> <div ...
asp.net-mvc entity-framework-6
asked by Aleem

Updating entity framework model after changing the data type of column in database table

I am working with entity framework 6 with database 1st approach. I changed the datatype of my columns in the table and after updating my model I got the following error:...Error 1 Error 2019: Member Mapping specified is not valid. The type 'Edm.Int32[Nullable=False,DefaultValue=]' of member 'Warranty' in type 'pjModel.Bill' is not compatible...
entity-framework-6 mapping member sqldatatypes updatemodel
asked by Amit Kaushal

Collection in entity framework model is not updating

The feature you're missing is how the Context Cache works. When you attach an entity (either manually or by requesting an entity from the database) to the context, it's ...watched... by entity framework for changes and tracking those changes....You've added an object to an entitiy's propety, then added it to the context. Entity Framework is now w...
c# database entity-framework entity-framework-6
asked by Erik Philips

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow