Category "entity-framework-core"

EF Core 6 with Pomelo EntityFrameworkCore MySql fails to create database

I am using EF Core 6 with Pomelo.EntityFrameworkCore.MySql and code first. I have the following code in my connection string. public sealed partial class MyDbCo

An error occurred while accessing the Microsoft.Extensions.Hosting services. After Adding ASP.NET identity

I have DataContext and StartUp class in different projects and to add a new migration in Data project I used the below command: dotnet ef migrations add Identit

EFCore navigational properties are not mapped

I have a model Contact with three navigational properties of type Place but when I make a request in to database ids are filled but navigational properties are

ASP.NET Core - Entity Framework Core - Drop Down List - DbContext SaveChanges Issue

I'm new to using EF as well as ASP.NET Core. I'm working on a simple web application and I am getting an error when I go to save a new record. When the DbCont

Add one object in list nested entity in EF Core

I create a repository layer in my app. I don't need all list EntityList. I want add in Foo.EntityList 1 object which equals entityId, and return foo in notImpor

C# - Adding condition to func results in stack overflow exception

I have a func as part of specification class which sorts the given iqueryable Func<IQueryable<T>, IOrderedQueryable<T>>? Sort { get; set; } W

In Entity Framework Core 3.1, what is the best way to dynamically provide table name to a query?

I have seen options for .NET 5, .NET Core 2.0, etc. but none of them seem to work for .NET Core 3.1 What is the best way to provide table name, in a variable, t

How can I learn the credentials for the Connection String in optionsBuilder.UseOracle(@"User Id=<>;Password=<>;Data Source=<>")?

I want to connect from my codebase which is console C# project to an Oracle database. I am using Entity Framework Core 6.0: using Microsoft.EntityFrameworkC

.NET6 calling oracle stored procedures with params and refcursor

First time I am using .net6 with entity framework trying to call stored procedure. CREATE OR REPLACE PROCEDURE get_registration ( IDIn IN Number DEFAULT nu

Audit.Net: Audit Record Not Rolling Back When saving master record throws DbUpdateException

I have been using Audit.EntityFramework.Core v14.6.3 in my .Net Core v2.2 Web API. When I update a table record, it threw dbUpdateException error due to a check

Register to be created from factory

I'm trying to use DryIOC to resolve a scoped entity framework context. While this registration works, it feels weird: container.Register<MyDbContext>( Reu

EF Core - ValueConverter or OwnedType for simple ValueObjects?

I use value objects to encapsulate validations like maxLength. This is an extract of a sample class without factory method and validation: public class CallingN

How to insert properly into a many-to-many relationship?

When inserting data into a many-to-many relationship, should you insert to the join-table or to both original tables? My table models: public DbSet<User>

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

Other Categories