Is it possible to get Added items not committed in EFCore with .NET Core?

In Memory Database with.Net Core not adding data to entity collection

I am creating xunit test with EF Core 2.0.0 and InMemory 2.0.0. I noticed that the entities are not being added in the context. However it is being added at context..Local...Below is the snippet of the code... public UnitOfWorkTest() { _appointment = new Appointment { AppointmentType = AppointmentTypes.EyeTest, AppProgress ...

How to add EF core migrations to .net core 2 class library?

I created a .net core 2 class library. and I created the entities and entities type configurations. I created the DbContext ...public class EFDBContext : DbContext { public EFDBContext(DbContextOptions options) : base(options) { } } ...then I created a TemporaryDbContextFactory...public class TemporaryDbContextFactory : IDesignTimeDbCo...

Getting error in Entity Framework when trying to add an item

I'm getting the below error when trying to add an item to the database context. I'm using Entity Framework in a Web API project. The sample code is shown below....Exception...System.Data.Entity.Infrastructure.DbUpdateException... HResult=0x80131501 Message=An error occurred while updating the entries. See the inner exception for details. So...

Why am I getting duplicate ID columns when using Table Per Hierarchy in Entity Framework Core?

I am trying to use "table per hierarchy" to model a variety of account types in my database using EF Core (2.1) and I am having a problem where I am getting additional foreign key columns added for the derived types. I have seen ...this... question/answer but I don't think it is the same as my situation....Here are my account classes:...public abst...

.Net Core 3.0 possible object cycle was detected which is not supported

I have 2 entities that are related as one to many...public class Restaurant { public int RestaurantId {get;set;} public string Name {get;set;} public List<Reservation> Reservations {get;set;} ... } ...public class Reservation{ public int ReservationId {get;set;} public int RestaurantId {get;set;} public Restaurant Restaurant {g...

ASP.NET Core Web API & Entity Framework Core; why am I getting this error?

I understand that the serializer in ASP.NET Core may not be able to handle certain responses, but why do I get this error when I don't try to return the object in question?...See the error here: ...https://imgur.com/a/2se9eWB...When I try to affiliated my ...ProjectResourceRequest... with my ...ProjectResourceAssignment..., it writes to the databas...

Migrate .NET Core 2.2 to .NET Core 3.1 and keep referencing EF Core 2

I have a C# application written with .NETCore 2.2 and Postgres and I would like to migrate it to .NET Core 3.1....The problems is that there are so many breaking changes, especially in Entity Framework that it is not possible to rewrite everything now. At the same time, other developers continue development on .NET Core 2.2 branch and I need to do ...

Is it a good idea to add .Net Framework class library to .Net core console application

I have created a new .net core console application and, I have all my BL and DAL in a NuGet package which is in .net Framework(some class libraries in this are in .Net framework 2.0). if I install this NuGet in .Core library it will not work fine which is obvious....so the question is, if I add a .Net Framework(4.7) class library and install this N...

Entity Framework .Net core not adding stored procedure classes

I am generating Entity Framework classes in a .NET Core application using this command:...Scaffold-DbContext "Server=server name;Database=DB name;user id=user name;password=password;Trusted_Connection=False;Encrypt=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models/DB ...It is working well and creating models for all the ta...

.Net Core - How to add SQL Column Constraint using EF Core

In a .net core 3.1 web application, what file am I suppose to edit to add a DEFAULT constraint to a table that is being created by EF?...Right now I have a migrations folder with a InitialCreate, RenamedTable, and TableDefault migration. Before creating the TableDefault migration, I went into the DbContextModelSnapshot.cs file and added this to on...