Category "entity-framework-core"

How to connect to MySQL server using Entity Framework Core

I am using Visual Studio 2019 community edition. I want to connect to MySQL using Entity Framework core. I do not want to use Entity Framework 6. I am running i

Returning ID from not yet created linked table index

I'm currently working on the database integration of my internship project using EntityFrameworkCore.Jet version 3.11. I cant upgrade because I'm using an MS Ac

Is Using EF Core Value Converter Preventing the Contains() LINQ Method from being Translated to SQL?

I have a Movie class. It has a Genres property of type List<string>. I use this exact EF Core Value Conversion to store it in the database as a comma-sepa

GetColumnName() in EF Core 6 returns property name not mapped column name

I'm using EF Core 6 (6.0.2) with SQL Server 2019 with the following entity: public partial class MyEntity { [Column("External_ExternalId")] publ

EF Scaffold table name is null

I'm trying to reverse engineer a Firebird 3 database using dotnet-ef scaffold. I tried it using EF Core 5 and EF Core 6. Both do not work but for different reas

Using EF Core with WPF and I'd like to revert to initial state when a user press Cancel instead of OK on a dialog, is that possible and how?

I'm using EF Core with WPF and I'd like to revert any changes done on any objects to their initial state when a user press Cancel instead of OK on a dialog, is

Entity Framework Core child entities only show up when I debug through code

I'm having this really weird scenario where I have a component in MVC that will call a service to grab all the categories in the database and include its child

Entity Framework Core child entities only show up when I debug through code

I'm having this really weird scenario where I have a component in MVC that will call a service to grab all the categories in the database and include its child

i can not pass parameters to backend ( from Ajax to IActionResult or JsonResult) .net core 5

i have problem i can't pass params to backend use fech or ajax call , but from another PC i can pass params, here is a sample from code Backend : [HttpPost]

How can I convert an empty string value to a nullable date value?

When I use Postman to test my API with a PUT request, I get this error: "type": "https://tools.ietf.org/html/rfc7231#section-6.5.1", "title": "One or more valid

Entity Framework Core: one-to-one configuration

I updated the title to be more relevant. I have two objects and wish to use EF Core to map them to a database using code first. I have shortened them a bit for

Entity framework core multi tenant : auto increment column based in another column value

Using entity framework core 6 with sample class public class Sample { [Key] public long Id { get; set; } public long TenantId { get; set; } public long

EF Core/C#: Set many-to-many relationship with a variable field?

If you have an EF/asp.net Core app that has ads with services with a price. Where each ad can have many services (out of a predefined set of choices, like hairc

EF Core 5.0 Many-To-Many delete from nested collection

My models are like this (simplified): public class Request { public string Id { get; set; } public List<Tag> Tags { get; set; }

Could not load file or assembly 'Microsoft.Data.SqlClient' in .NET 6

I have developed a WPF app on .NET 5 (CRUD operations with Entity Framework Core). MSI packages are built with Wix toolset. Up to here everything works. I am cu

EF Core: Union vs LinqKit for dynamic linq to SQL

I was always using the LinqKit to implement dynamic and cooperative predicates. However, the last time I saw a colleague use the Union to combine dynamic querie

Unable to make raw SQL calls from Entity Framework Core

I am working on a project where I am moving specific rows from a table between multiple different environments. The table has an Identity column and when I try

Backingfield is null in EF Core 3.1 , Lazy loading enabled

I am using Lazy Loading in EF core 3.1 and when i try to get the navigation data,it doesn't load. public class Template { private readonly List<Spec>

EntityFrameworkCore Performance tuning when filter one dbcontext object using the other dbcontext object

I asked something similar recently and it got solved by using AsQueryable: How to save time when pulling data from DB using Entity Framework Core in controller

ASP.NET EF Core Database update on Mac using docker image Azure Sql Edge

I am new to mac and got Azure Sql Edge running using docker image. This is the command I ran to run the image. docker run -d --name SQLServerImg -e ACCEPT_EULA=