C# – How to propagate database changes to the .edmx file

centity-framework-4visual studio 2010

I generated an .edmx file from database.

I want to know if I make changes to my database schema then how will those changes be reflected in my Entity Data Model Designer diagram? I made changes to my database schema but found the changes did not appear in my Entity Data Model Designer diagram. Can someone explain to me how to propagate database schema changes to my Entity Data Model Designer diagram?

Best Answer

I think what you are asking is if you change your schema, how is this then updated in your EDMX file?

Open your EDMX file in Visual Studio
Right click on the design surface
Select 'Update Model from Database'
Follow the wizard to 'Refresh' your model.

Your changes should now be visible on the design surface in the respective containers.

Related Solutions

C# – How to cast int to enum

From an int:

YourEnum foo = (YourEnum)yourInt;

From a string:

YourEnum foo = (YourEnum) Enum.Parse(typeof(YourEnum), yourString);

// The foo.ToString().Contains(",") check is necessary for enumerations marked with an [Flags] attribute
if (!Enum.IsDefined(typeof(YourEnum), foo) && !foo.ToString().Contains(","))
{
    throw new InvalidOperationException($"{yourString} is not an underlying value of the YourEnum enumeration.")
}

Update:

From number you can also

YourEnum foo = (YourEnum)Enum.ToObject(typeof(YourEnum) , yourInt);

C# – How to enumerate an enum

foreach (Suit suit in (Suit[]) Enum.GetValues(typeof(Suit)))
{
}

Note: The cast to (Suit[]) is not strictly necessary, but it does make the code 0.5 ns faster.

Best Answer

Related Solutions

C# – How to cast int to enum

C# – How to enumerate an enum

Related Topic