Entity Framework Core

2 answers

Getting an error :Add-Migration : The term 'Add-Migration' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

Tried trouble shooting , verfied DB context class. Reinstalled Vs after troubleshooting and getting answers saying there is a problem with package manager .

asked

Shyamali Mishra 0

commented

Robert L. Bonham 10

1 answer

Entity Framework Core 8, table with a user-defined data type. UDT

We are migrating a 4.5 large application which uses sql data reader to query the MS SQL database to .NET 8 EF core. The database has at least one user-defined column, code below. There is currently 20 years of data in the database. We are migrating…

asked

Phil Alexander 0

edited a comment

Hui Liu-MSFT 48,546 Microsoft Vendor

1 answer

how to include a spatial index in c# EF

This query is not using the spatial index: (@__point_0 sys.geometry)SELECT TOP(1) [t].[Id], [t].[Bus_StopsId], [t].[Point] FROM [TripRef_Stops] AS [t] WHERE [t].[Point].STBuffer(5.0000000000000002E-05).STContains(@__point_0) = CAST(1 AS bit) - it is…

asked

Stephen Cameron 0

answered

Stephen Cameron 0

1 answer

Using Enity Framework 6.1 and initial query VERY slow.

When performing the initial query using EF, it can take up to 9 mins. Though if you rerun it again and again it takes seconds. If I capture the query from the profiler, it always runs in seconds. If I wait about 10 / 15 mins the slow initial process…

asked

Gary Paquette 0

commented

Hongrui Yu-MSFT 2,075 Microsoft Vendor

2 answers

Map only the selected columns when using EntityFramework

In my recent Entity Core project I am having database table called "YmPlant" and it has 20+ columns. But for my requirement I just need data only from 3 columns. Also I am not required to do the write operations. Only read from YmlPlant table. …

asked

Nuwan Wickramanayaka 21

commented

John Viele 0

2 answers

How to Optimize Database Interactions in Entity Framework Core?

I am using Entity Framework Core for database interactions in my .NET application. I am seeking advice on optimizing database queries and transactions for better performance and efficiency. Any tips or best practices would be appreciated.

asked

Kevin Beasley 0

commented

Nubbi 0

2 answers

.Net Framework > .Net Migration Problem - Incremental upgrade with Entity Framework 6.4.4

Hi, (apologies for the lengthy description) I'm working on setting a roadmap for a phased/incremental upgrade path of a .Net Framework 4.8 solution to .Net 8.0+. The existing solution has a large number of projects with direct project references and has…

asked

AndyB 0

answered

Bruce (SqlWork.com) 65,576

2 answers

How to use EF Core when two properties in the Principle entity point to the same attribute in the dependent entity?

I have 2 Model classes: Department.cs cs public class Department { public string DepartmentId { get; set; } public string Name { get; set; } public string Description { get; set; } [ForeignKey("FacultyId")] public…

asked

Uchchay Dugal 21

answered

Hazrat Ali 0

1 answer

Invalid UserName in ASP.NET Core 6

I am working on an ASP.NET Core 6 MVC application that uses ASP.NET Core Identity. When I try to create a new user using the UserManager, I get this error: User name ' ' is invalid, can only contain letters or digits Username do not has any…

asked

mostafa ahmed 41

accepted

mostafa ahmed 41

2 answers

Cycling problem

Hi, I have 2 entity which have one to many relation between. Lets name them School and student. When I'm creating School I'm getting cycling problem . I did all the configuration in Configure class but nothing worked. There is a way with [JsonIgnore] but…

asked

Atilla Rüstəmli 40

edited a comment

SurferOnWww 2,906

3 answers

This error appears to me. I use .NET 8. The project is divided into three layers. The presentation layer is a web project. The rest of the layers are class libraries. I installed the necessary libraries, all of which are version 8.

asked

saleh salem 20

commented

saleh salem 20

2 answers

How to get license terms for Entity Framework 4.3.0 nuget package and also source code?

Hello, I am not sure if this is right forum for this question. What i need is the license terms from Microsoft for using the Entity Framework 4.3.0 nuget package in the application which is disctributed commercially. Also, since Entity Framework is…

asked

Shinde, Kalpana 0

answered

Bruce (SqlWork.com) 65,576

1 answer

EF Core AUTO_INCREMENT problem with MySQL database

The only problem i have now that i finished my database design is that the AUTO_INCREMENT is not specified when creating the tables by EF Core. This is the modelBuilder modelBuilder.Entity<Conturi>(entity => { …

asked

Stefan 0

commented

Hongrui Yu-MSFT 2,075 Microsoft Vendor

1 answer

Entity Framework complains that there is no primary key

using System; using System.Collections.Generic; using System.ComponentModel.DataAnnotations; namespace WpfApp6.Models; public partial class Product [Key] public int IdProduct { get; set; } public string NameOfProduct { get; set; } = null!; public…

asked

vitaminchik 486

edited the question

DillanSimmons 1

1 answer

Inserting data in many to many relation ship in EF core

i have two tables 1-Employees (ID ,EmpName) 2- Project (ID,ProjectName) data is already inserted in boh tables ,there is many to many relationship between these two so middle table created in table i.e EmployeesProject now i want to insert data (keys of…

asked

Erum Mirza 6

commented

Aviad Pineles 20

1 answer

Add-Migration works, but Update-Database says "no migrations to update". I tried deleting the Mig.. Folder

Visual Studio and EF Core problem. Migrations don't work. Add-Migration Title works to update the schema, but Update-Database in NuGet Command Console says that the db is already up to date, but the db does not have my new table in it. I tried…

asked

John Murphy 30

commented

Mario Escudero 0

2 answers

How can I save a collection of CultureInfo type using EF Core without adding backing fields?

In a class, I have a collection of type List<CultureInfo> OfficialLanguages. I need to respect domain driven design for this project. I cannot add a backing field of type List<string> officialLanguagesCodes and handle it that way. When I have…

asked

Joseph Gregory 20

accepted

Joseph Gregory 20

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

edited an answer

Bruce (SqlWork.com) 65,576

1 answer

BulkInsert for Entity Framework Core

Entity Framework core now has ExecuteUpdate and ExecuteDelete for doing large updates and deletes But when is EF core going to get the much need BulkInsert that does the job of SQL SERVER's BCP There are third party tools, but they are very expense…

asked

Greg Frazer 0

commented

Hongrui Yu-MSFT 2,075 Microsoft Vendor

2 answers

How to save a many to many relationship with Entity Framework

Hi, I have a many to many relationship between Flight and Journey, so I have created an intermediate table to create the relationship: the thing is, I have a list of flights and one Journey, so how can I create the code to make the assembly so I can…

asked

Jhon Hernandez 21

answered

MARTIN JOY 0

Filter

Content

743 questions with Entity Framework Core tags

Getting an error :Add-Migration : The term 'Add-Migration' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

Entity Framework Core 8, table with a user-defined data type. UDT

how to include a spatial index in c# EF

Using Enity Framework 6.1 and initial query VERY slow.

Map only the selected columns when using EntityFramework

How to Optimize Database Interactions in Entity Framework Core?

.Net Framework > .Net Migration Problem - Incremental upgrade with Entity Framework 6.4.4

How to use EF Core when two properties in the Principle entity point to the same attribute in the dependent entity?

Invalid UserName in ASP.NET Core 6

Cycling problem

This error appears to me. I use .NET 8. The project is divided into three layers. The presentation layer is a web project. The rest of the layers are class libraries. I installed the necessary libraries, all of which are version 8.

How to get license terms for Entity Framework 4.3.0 nuget package and also source code?

EF Core AUTO_INCREMENT problem with MySQL database

Entity Framework complains that there is no primary key

Inserting data in many to many relation ship in EF core

Add-Migration works, but Update-Database says "no migrations to update". I tried deleting the Mig.. Folder

How can I save a collection of CultureInfo type using EF Core without adding backing fields?

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

BulkInsert for Entity Framework Core

How to save a many to many relationship with Entity Framework