Entity Framework 6 - Knowledge Base (KB)

Entity Framework: How to appropriately handle SQL constraint-related errors

I use Entity Framework to access my SQL data. I have some constraints in the database schema and I wonder how to handle exceptions that are caused by these constraints....As example, I get the following exception in a case where two users try to add an (a...

Unique Key constraints for multiple columns in Entity Framework

I'm using Entity Framework 5.0 Code First;...public class Entity { [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)] public string EntityId { get; set;} public int FirstColumn { get; set;} public int SecondColumn { get; set;} } ..

Entity framework Code First One-to-One relationship

I have two entities which I want to be connected 1:1 relationship. User is principal and UserActivation is dependent, but I have no idea how that works....public class User { [Key] public Guid Id { get; set; } public string Name { get; set; } ...

Entity Framework Primary/Foreign constraint name

Is there any way to rename a primary/foreign key constraint name through either data annotations or fluent API?...I'm not talking about the property/column name. The constraint name. I did some search and didn't find any solutions yet. ...Please help!

DbUpdateException when adding item to Entity Framework Context

I have the following two classes:...public class Record { public int RecordId { get; set; } public DateTime? InsertDate { get; set; } = DateTime.Now; public DateTime BookingDate { get; set; } public string AmountTypeName { get; set; } ...