Entity Framework 6 - Knowledge Base (KB)
60 results in tag: ef-database-first
empty .Designer.cs file after generating .edmx using EF 4.x on ASP.Net MVC4 application
I have started a very simple ASP.Net MVC4 applictaion with a Database first approach (with existing DB). I have generated ....edmx... using ADO.Net Entity Data Model template. The process has created a ...xxxxxxx.Designer.cs... file under ...xxxxxxx.edmx....
asked by shaz
How to change [DisplayName] of EF generated class properties?
We know EF generates classes based on Tables we added to ....edmx... file. Which will not any [DisplayName] DataAnnotations for them. ...How can I add this [DisplayName] of generated classes without modifying them? because generated classes can be overrid...
asked by James123
Create one to one relationship by using entity framework database first
In ...EF Code First..., we can create one-to-one relationship by coding like this:...public class User { public int UserID {get;set;} public string Name {get;set;} public int UserDetailID {get;set;} public UserDetail Detail {get;set;} } public class Use...
asked by yan
What is the best practice for multiple "Include"-s in Entity Framework?
Let's say we have four entities in data model: Categories, Books, Authors and BookPages. Also assume Categories-Books, Books-Authors and Books-BookPages relationships are one-to-many. ...If a category entity instance is retrieved from database - including...
asked by anar khalilov
Ignore certain columns on update
Hello I have something like this:...public ActionResult Edit(int id) { var movie = (from m in _db.Movies where m.Id == id select m).First(); return View(movie); } [HttpPost] public ActionResult Edit(Movie movie) { try { var origi...
asked by Santiago
Update MVC database first to reflect db changes
i'm new to MVC and have to update my model....I have an SQL Server database already connected to my project, today I add a new column. Now I need to update my MVC code to reflect the change. ...Everything online tells me to update the .edmx and .tt files ...
asked by juleekwin
Generate Entity Framework model from Visual Studio database project
I'm using EF5 with a Database-First model. And a database project in visual Visual Studio to maintain the Sql Server database schema of an application....To update the EF model, I'm deploying the changes in a empty database... ...Is it possible to generat...
asked by Alex
Entity framework nesting complex types
I have a stored procedure that returns multiple result sets. Each one is a complex type. The first result set would contain a list of items of the same complex type as the second result set, etc. These do not cleanly correlate to specific entities. Fo...
asked by ChristyPiffat
EF 6 database first: How to update stored procedures?
We are using ...Entity Framework 6.0.0... and use database first ...(like this)... to generate code from tables and stored procedures. This seems to work great, except that changes in stored procedures are not reflected when updating or refreshing the mo...
asked by Halvard
MVC 4 and EF6 database first: issue with mapping
I am following along Pro ASP.NET MVC 4 by Adam Freeman on VS 2010 (I downloaded the MVC 4 template online). I have worked with the .edmx file before, but in Chapter 7 he does not do this. I setup a basic connection string with SQL Server in my web.config ...
asked by jmzagorski
MySql Connector with EF 6
I am having a weird issue with MySql Connector(6.8.3) and EF6. I was working on a WebApi project where I use MySql and EF6 with Database first approach. Everything worked fine[even deployed on one of the test servers] until I changed the database from 'Te...
asked by usp
Upgrade from Entity Framework 5 to 6
After upgrading our project from using Entity Framework 5 to Entity Framework 6 (though NuGets update function) i get the following error on my generated Entities class:...Error 1 The type or namespace name 'Objects' does not exist in the namespace 'Sy...
asked by RossBille
Entity Framework 6 database first many to many relationship
I am trying EF6 and trying to utilize a many to many relationship....Using Database first here is my scripted out database....CREATE TABLE [States] ( Id int identity (1, 1) not null primary key, Name varchar(50) not null, Abbreviation varchar(...
asked by EvilToaster101
Entity Framework DB-First, implement inheritance
I'm trying to implement inheritance using entity framework 6.0 and database first approach. OK, let's say I have a ...Person... and an ...Organization... entity like below:...// a simplified version of organization entity public class Organization { p...
asked by Ashkan
How to sync model after using Code First from Database using Entity Framework 6.1 and MVC 5?
Assumptions...Using EF 6.1, MVC 5, VS 2013, C#...I have an existing database model designed in Toad DM for SQL Server and it's very important keep it always updated...Steps and Notes...Using ADO.NET Entity Data Model I chose ...Code First from Database...
asked by gkaio
Change entity framework database first auto generated domain classes
Can i change entity framework database first auto generated classes (under .tt) to derive from a base class (BaseEntity)?...Some of my domain classes has two property (CreateDateTime & CreateUserId) and i want to set this properties automatically before S...
asked by Mohammad Zare
Use SQL Server database instead of local database asp.net mvc 5 database-first asp.net Identity tables
I have created an MVC Web App using Database First. The default db for the ASP.Net Identity data is a local database. I need to change this to my sql server db which already exists. I have looked everywhere. The only articles about this seem to deal with ...
asked by EB.
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 migratio...
asked by Colin
How to update record using Entity Framework 6?
I am trying to update record using EF6. First finding the record, if exists, update it. Here is my code:-...var book = new Model.Book { BookNumber = _book.BookNumber, BookName = _book.BookName, BookTitle = _book.BookTitle, }; using (var db =...
asked by user1327064
Complex type inside Database-first model of a DDD project
Let’s say in my EF6 project [Database-first approach] I have a complex type called ...Address... [just to clarify my complex type does not have any identity and is only a merge of aggregation of standalone data and it is not even responsible for its own...
asked by MHOOS
