Source Code for Entity framework 6.0.2

Entity Framework 6 (code first) entity versioning and auditing

I'm looking at using Entity Framework 6.1.1 with SQL Server 2008 R2. ...Currently I'm creating my models and database using the code-first EF feature. My basic use-case is to create a journal of all changes to a particular entity (...ID... is the key column) to help auditors track all changes made and by whom. e.g:...|ID|Version|Created Date|Create...

Persisting and retrieving serialized entity property with Entity Framework 6.1 code first

The only solution is this,...public class Foo { public Guid Id { get; set; } // Not Mapped attribute will make EF // ignore this property completely [NotMapped] public Bar BarObject { get; set; } public string Bar{ get{ return JsonConvert.Serialize(BarObject); } set{ ...

Entity Framework 6 Foreign Key using strings and not to source model ID

I have the following (abbreviated) models:...public class Item { public int id { get; set; } public string itemId { get; set; } ... more properties ... public virtual List<Detail> Details { get; set;} } public class Detail { [Key] public int id { get; set; } public string itemId { get; set; } ... more properties ... // Navigation property [Forei...

Entity Framework Core 1.0 code-first migrations using code?

In previous versions of Entity Framework code-first migrations could be controlled programmatically with the DbMigrator class (e.g. check for and apply available migrations). Does that class still exist somewhere or is there a functional replacement? I found a post on an early RC version that indicated a substitute but that too seems to be missing ...

Deleting parent-child relation with Entity Framework or Entity Framework Core

I'm learning how to use Entity Framework, having a NHibernate background. There are plenty of tutorials on the net, but I didn't find something for my specific case. I don't want to delete the Category record, I only want to delete the relation!...I have following poco's:... public class TrainingCourse { [Key] public int Cour...

Log DbContext.SaveChanges Exception to the database in Entity Framework/Entity Framework Core

In try block you are adding some changes to db context. While saving you got some exception and using the same db context in catch block to log that exception. Here the db context still has unsaved changes made in try block. So you will get the same exception while saving the context. ...To avoid this you have to discard the changes from db context...

Entity Framework Code first self referencing ID inserts wrong entity

Fixed; I just needed to attach the parentdepartment to the dbset

Entity Framework Core Code First changing added entities values before save causes identity insert error

I got a problem with setting values before saving an added entity. When I don't change the entities values it saves without a problem....The error I get is this:...SqlException: Cannot insert explicit value for identity column in table 'TableName' when IDENTITY_INSERT is set to OFF....I am using .net Core 2.1 and my nuget packages are all up to dat...

Add migration - Both Entity Framework Core and Entity Framework 6 are installed

I have a solution with multiple projects one of them with EF 6 and another one with entityframeworkcore....The migrations were working fine before adding EF6 project, but now I can't use the migration's command : ...add-migration 'anything'...Both Entity Framework Core and Entity Framework 6 are installed. The Entity Framework Core tools are runnin...

De-normalizing data into a code first Entity Framework entity, without a SQL View

First, here's a simple example database model, which has ...Products... assigned to ...Categories..., where ...CategoryId... in ...Products... is the FK relationship to ...Categories.......Products...:...ProductId (PK), INT...ProductName VARCHAR(255)...CategoryId (FK), INT...Categories...CategoryId (PK), INT...CategoryName VARCHAR(255)...For the .N...