All Questions

I am trying to define two classes with the same collection-relation, through the same key on a third class, preferably using EF 6 code annotations. I have three tables; Current is a quick reference. ...

I am setting up an automated integration test environment for a large, existing Entity Framework 6 project that uses a MySQL database. My goal is to create a fresh, empty database schema directly from ...

Still on EF 6 "classic" (not core), when I do something like the following: var basicPersonList = myContext.Persons .Select(p => new PersonSimpleData { FamilyName = p....

I have a C# (C# 7.5) application that is using EF6. I have a table that contains two foreign keys. Both are one:one relationships and both are required. When I load a record from the database, the ...

I have an Order table that contains a nullable foreign key to another table called Product (each order can only map to one product). Each order will only point to one product. The relation is ...

After installing Windows 11 Update 24H2, I have not been able to work with a COM Library developed with C# and accessed from Delphi. The failure occurs when I do a Where filter using a numeric ...

I'm using VS2022 and have an ASP.NET MVC project with Entity Framework 6. All Nuget packages are current. I have a data connection InstrumentEntities; in the Server Explorer, I can see all the tables ...

I need to map an existing database using Entity Framework 6 in order to read (only) data. The model that bugs me is kind of a TPH inheritance strategy where the child type depends on a discriminator ...

I'm working on a .NET Framework 4.6.1 application using Autofac (5.2.0) for dependency injection and Hangfire for background jobs. I have a service class StoreDataCleanupService that depends on an EF ...

Using Entity Framework 6 in an ASP.NET Core Web API. I have the following controller: [Route("[controller]/[action]")] [ApiController] public class ContactController : ControllerBase { ...

I have methods used in IQueryable.Select(...) that shares the same logic of mapping an Entity class to a DTO class, but filter the navigation properties in the projection differently. The problem is ...

I have a query that I want to return an entity with a filtered collection navigation property. According to the EF6 document I should be able to load it via explicit loading. However, after the ...

Running NbLinksExpirationStatus takes about 12 seconds to execute, which is not fast enough for what i am trying to achieve. Could it be Contains() problem and is there any way i can make it execute ...

We have a .NET Framework 4.8 application that uses Entity Framework 6. Now we are having a problem that we need to add some tables that don't guarantee any uniqueness (no primary key and rows can ...

I have a C# / ASP.NET MVC project using Entity Framework 6. When I am deploying database migrations by running Update-Database -Verbose in the Package Manager Console in Visual Studio, everything ...