Entity Framework Core - Knowledge Base (KB)

How to add an EF6 Association to a Candidate Key / Unique Key which is not the Primary Key?

Using ...Schema First..., I have a database structure, as so...ExternalDataItems --- edataitem_id PK -- surrogate auto-increment - NOT for FK relation here datahash UX -- Candidate Key / Unique Index (binary(20)) ExternalMaps --- emap_id P...

How does Entity framework implement deleting parent and a child record on the ame SaveChanges()

I have the following two entity sets representing Dept & Emp:-...public partial class Dept { public Dept() { this.Emps = new HashSet<Emp>(); } public int DeptID { get; set; } public string Name { get; set; } public string ...

Entity Framework 1to1 relationship via association table not working in EDMX

I have the following tables in SQL Server database ...Which has a 1-1 association table (FooBar) which has unique indexes on corresponding FooId, BarId, and the primary key is (FooId, BarId)....To be clear FooBar does not allow any FooId (due to unique co...

The difference between EF6 and EF4.1 in files hierarchy

I'm a beginner to Entity Framework ....I notice that When I use ...EF6 with Visual studio 2013...:...I have ....Designer.cs... empty file with this comment:... // T4 code generation is enabled for model 'C:\Users\Luka\Desktop\Test\EF-db2008\AdventureWork...

does Visual Studio 2015 include .edmx support?

Does Visual Studio 2015 include .edmx support?...I have a project that includes an .edmx data model and double-clicking it in VS2015 just opens the XML editor....There's no DbContext generator option in the file->new dialog.

Entity Framework edmx click on diagram very slow

Background first: I have a database-first EF6 model in Visual Studio 2015 (latest nuget 6.1.3 pointing to a local SQL Server 2014 SP1 Express database) on a Windows 10 Pro laptop. After I upgraded from Windows 8.1 and Visual Studio 2013. I also upgraded t...

EntityFramework: how to modify edmx to change format of entity names and properties

I am using the Entity Framework to generate data access code from an old database....The database table names and properties are all named in capitals with ..._... to separate words ie. ...CLIENT..., ...CLIENT_NAME..., ...D_CLIENT_ID... etc....I hav...

Map/use built-in MySQL function in Entity Framework

Quite a simple question, I hope: I want to use built-in MySQL functions just as YEARWEEK or INSERT in Entity Framework 6 (similar to the ...System.Data.Entity.DbFunctions... namespace). Is there a way to add a mapping to those functions?...I already tried...