Entity Framework Core

4 answers

How to fix Add-Migration problem?

Hi, I am trying to add another entity to the database in my e-commerce solution which includes client and admin projects using Blazor WASM and Server, Asp.Net Core API, and data access projects. However, I am getting an error message as shown below: How…

asked

Cenk 986

answered

Cenk 986

1 answer

.Net core application with EFCore using Sqlite DB on linux giving error "Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 14: 'unable to open database file'."

I'm running a simple .Net Core application on Linux using EFCore and SQLite, but I'm getting the following error: An exception occurred while iterating over the results of a query for context type 'ApplicationDbContext'. …

asked

Hrushikesh Patel 0

commented

Bruce (SqlWork.com) 60,201

3 answers

EF Core - High Memory Usage For Query that Runs for 20 seconds

I'm wondering if there is a better way to optimize the below query. Granted, it's pulling in 80,000 - 160,000 records, but the RAM usage on my web server, shoots up to ~3gig while it's running for a total of 20 seconds, when testing it in my API, but,…

asked

muttBunch 100

answered

Bruce (SqlWork.com) 60,201

1 answer

EntityFrameworkCore 7 SetProperty(avar,avalue) Unable to cast object of type 'System.Linq.Expressions.TypedParameterExpression' to type 'System.Linq.Expressions.LambdaExpression'.

My code: 1.Error ADal aDal = new ADal(); Func<AModel, float> p = property => property.Balance; aDal._databaseContext .ModelDbSet .Where(w => w.ID == 5) .Take(1) .ExecuteUpdate(e => e.SetProperty(p, 636)); Out error (Almost no answer…

asked

Allen 5

commented

İsa Sayın 0

0 answers

EF Core .Net 8 error after TLS 1.0 was disabled.

The admins where I work have disabled TLS 1.0 but now all of a sudden, my .Net 8 app is getting the following error: Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred…

asked

Lange Gregory 20

commented

Umut Çömlekçioğlu 0

2 answers

Queries with EF Core causes 'Cannot continue the execution because the session is in the kill state'

Some EF Core queries are throwing the following error in our code : Cannot continue the execution because the session is in the kill state. Une erreur grave s'est produite pendant la commande actuelle. Les résultats devront être supprimés, le cas…

asked

Arthur Menétrey 20

answered

Arthur Menétrey 20

1 answer

How to exclude matching records in EF Core Database

I've been working on a project from a gentleman that is no longer on my team. We want to have the below code running as a Windows Service, running every 5 minutes (easy for me to do the Service). However, if we run the below code in our API, manually…

asked

muttBunch 100

commented

muttBunch 100

1 answer

Access failed to localdb using EFCore in vs2022

Hi, I created my first Avalonia UI app in MVVM pattern and already installed EFCore 8.0.6 in the project. But failed to access the localdb. My troubleshoot: Created a simple console project. No issue. See attached pic1. In Avalonia app, checked the…

asked

Spellman.Lau 101

answered

Spellman.Lau 101

2 answers

My EmailConfirmed is not working

Hi, I'm new to this, so I'm not so good, your help is my pleasure, thank you. I am having a problem with login, the API emailConfirmed still works when I give it token and userId. As far as I know, the EmailConfirmed doesn't confirm itself. I think I…

asked

Nhựt Lại 45

accepted

Nhựt Lại 45

1 answer

A second operation was started on this context instance before a previous operation completed. This is usually caused by different threads concurrently using the same instance of DbContext

I have a project using Azure Function with ASP.NET Core 8 and Service Bus, for data access I use EF Core. I'm getting hit a lot and we still haven't found the cause of the error: "A second operation was started on this context instance before a…

asked

Pedro Otávio 20

accepted

Pedro Otávio 20

1 answer

Entity Framework bulk functionalities (bulk insert,bulk delete)

I'm currently working on an enterprise project that requires some logic for bulk functionalities using Entity Framework. We found a couple of options but both are under licence: EF. Core.BulkExtensions…

asked

Greivin Chaves 0

commented

David V. Corbin [Atmosera] 6

3 answers

Which is better to use, DbContext.Add() or DbSet.Add()?

Hi, If you allow, I would like to ask a question. In CRUD operations, we can add to the database in two ways: DbContext.Add(object) and DbSet.Add(object). Which one is more correct to use? public class Context : DbContext { public DbSet<Category>…

asked

Yalçın Mete 60

accepted

Yalçın Mete 60

3 answers

How to filter a query in EF Core using a Value Object (Email value object) and the filter using Contains method?

I'm using C# EF Core version 7. I have a value object called Email which contains a string Value getter property which will hold the email value, and i have entity called Person which have Id and email i have configuered my entity using fluent api as…

asked

Osama Al-qarutee 0

answered

Mobin Valikhani 0

1 answer

My listview is listing only the id instead of 3 items on the table

PLEASE HELP ME I am working on sqlite database , i have the following code in c# maui return (await conn.Table

asked

Gbenga Banuso Odumosu 40

edited the question

Rakesh Gurram 5,070 Microsoft Vendor

0 answers

System.Reflection.TargetInvocationException: "Expression 'dest => dest' must resolve to top-level member" when configuring AutoMapper profile

I'm encountering an exception when trying to configure AutoMapper in my ASP.NET Core application. The exception message is: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. --->…

asked

Julia Ohorodnichuk 0

commented

Ping Ni-MSFT 3,040 Microsoft Vendor

1 answer

Unable to create a DbContext' Error when Using EF Core in .NET 8 ClassLibrary Project

Hello everyone, I've developed a ClassLibrary project using .NET 8 and C#, and I've utilized EF Core 8 in it. I've defined my own models and context within it. However, when I attempt to use the add-migration command, I encounter this error: "Unable…

asked

Kamyab Faghih 20

accepted

Kamyab Faghih 20

1 answer

How do I store a negative TimeSpan in Entity Framework?

Hi all; I store shifts to events with a TimeSpan as the offset from the start of the event and another TimeSpan as the duration of the shift. The setup shift starts before the event (so everyone see the event as 11:00am - 4:00pm as desired while the…

asked

David Thielen 2,506

accepted

David Thielen 2,506

2 answers

EF Core 3.1 - System.InvalidOperationException: 'The entity type 'Pntbec03' requires a primary key to be defined. If you intended to use a keyless entity type call 'HasNoKey()'.'

Hello . I need to handle a EF Core Entity relating to a table , but without having EF managing all its columns , but just a subset of them. I have scaffolded the small database to which the table belongs into a DbContext , and I though I could create…

asked

leo del ciello 66

commented

Hongrui Yu-MSFT 780 Microsoft Vendor

2 answers

How to retrieve the any table from SQL DB and display dynamically in one page in asp.net core

Requirements are as below. 1. In single page of asp.net core, need to display any table data dynamically like jtable from jQuery plugin... With generic code with ado.net or web api orAPI or entity framework core

asked

phani sekhar 1

commented

Hutty 20

2 answers

Is it correct to make connection string dynamic?

Hi, I'm currently working on a project which need data from other databases. The database where I'll get the datas are depends on users. Now I want to make my connectionString dynamic. Is it correct to make connection strnig dynamic. The user will enter…

asked

Atilla Rüstəmli 20

edited the question

Zhi Lv - MSFT 32,071 Microsoft Vendor

Filter

Content

717 questions with Entity Framework Core tags

How to fix Add-Migration problem?

.Net core application with EFCore using Sqlite DB on linux giving error "Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 14: 'unable to open database file'."

EF Core - High Memory Usage For Query that Runs for 20 seconds

EntityFrameworkCore 7 SetProperty(avar,avalue) Unable to cast object of type 'System.Linq.Expressions.TypedParameterExpression' to type 'System.Linq.Expressions.LambdaExpression'.

EF Core .Net 8 error after TLS 1.0 was disabled.

Queries with EF Core causes 'Cannot continue the execution because the session is in the kill state'

How to exclude matching records in EF Core Database

Access failed to localdb using EFCore in vs2022

My EmailConfirmed is not working

A second operation was started on this context instance before a previous operation completed. This is usually caused by different threads concurrently using the same instance of DbContext

Entity Framework bulk functionalities (bulk insert,bulk delete)

Which is better to use, DbContext.Add() or DbSet.Add()?

How to filter a query in EF Core using a Value Object (Email value object) and the filter using Contains method?

My listview is listing only the id instead of 3 items on the table

System.Reflection.TargetInvocationException: "Expression 'dest => dest' must resolve to top-level member" when configuring AutoMapper profile

Unable to create a DbContext' Error when Using EF Core in .NET 8 ClassLibrary Project

How do I store a negative TimeSpan in Entity Framework?

EF Core 3.1 - System.InvalidOperationException: 'The entity type 'Pntbec03' requires a primary key to be defined. If you intended to use a keyless entity type call 'HasNoKey()'.'

How to retrieve the any table from SQL DB and display dynamically in one page in asp.net core

Is it correct to make connection string dynamic?