EF Core event after entities materialized from database

asp.net core/EF-Core mysql update database error

I am absolutely new to asp.net core development. I am trying to create a simple asp.net core web api with a single model and mysql to store the model data and then I would want to retrieve it as REST API perhaps using Swagger....My current set up looks like following: ...Books.cs:...using Microsoft.EntityFrameworkCore; using MySQL.Data.EntityFramew...

Can I fire an event on connect database in Entity Framework Core?

I've one DbContext with all working to access my Postgresql DB, but I need to run one little SQL command when connection session starts with DB. I need to do this for every interaction. To be more specific, it's a function for set a session variable with user name logged....It's possible to do something to handle that in EF Core?...--SOLUTION--...I...

.Net Core 2.1 EF Core Null Reference Exception when searching database with Where linq query

I have a pretty simple query here:...public async Task<IActionResult> Index(string sortOrder) { ApplicationUser user = await _userManager.GetUserAsync(User); var context = _context.Engine .Include(e => e.EngineType) .Where(e => e.Company == user.Company); return View(await context.ToListAsync());...

Add child entities to database and assign them to parent object in database Entity Framework Core

I have a datamodel named "Document" which looks like this:...public class Document { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } //[ForeignKey("Id")] public List<DocumentLine> Lines { get; set; } public DateTime PurchaseDate { get; set; } public double TotalValue { get; set; } } ...It...

EF Core - Removing a related entity from collection navigation property does not update database

I am trying to understand this sentence:...By default, for required relationships, a cascade delete behavior is configured and the child/dependent entity will be deleted from the database....found in the "Removing relationships" paragraph in this Microsoft documentation of EF Core: ...https://docs.microsoft.com/en-us/ef/core/saving/related-data#rem...

.net core C# use dynamic property name on EF Core Database first generated model class

I have a user details class...public partial class UserDetails { public int? Level { get; set; } public string Unit { get; set; } public string Bio { get; set; } public bool? Gender { get; set; } public int? Mobile { get; set; } public string Photo { get; set; } } ...I am writing an update met...

What is the difference between EF Core Database-First and EF Core Code-First approaches?

I was wondering... since there is no EDMX in EF Core, what is the difference between those 2? And if the major difference would be the possibility to change the database tables, why not use code first then use EF code-first migrations?

How to connect to two different database in ef core database first

How to create two different database context to use two different database in EF core. i am using database first approach....Currently using the following line to use in my startup.cs...builderModel.Services.AddDbContext<DB1Context>(options => options.UseSqlServer(configuration.GetConnectionString("DB1Context"))); ...Thanks

How to implement Entity Framework Core 3.1.2 with Firebird database using 'database first approach'

I am currently developing a .NET Core 3.1 Web API which should communicate with a Firebird database (storing/retrieving data). I would like to handle that communication using ...Microsoft.EntityFrameworkCore... 3.1.2. Entity Framework is completely new for me so excuse me if this question is too simple. But I couldn't find the answer online....Beca...

Recommended way of copying/managing data in my database on startup in .net core/ ef core?

The gist of my situation is that I'm dealing with a big database, and depending on the contents of it my code could do all kinds of unexpected things. The data is large, but it's not expected to change heavily any time soon, it's all in a single database on an mssql database on my computer. Let's call it a table of dogs that never change but are es...