I’m trying to pull data from an external API and save this data in a MS SQL Database using Entity Framework. I’m new to Entity Framework and can’t figure out how to make my data persistent. The Database is created following the Code First principle according to the following Model:
I’m trying to implement DDD approach in my project but realized that I have too big aggregates and trying to minimize the amount of data loaded from the database. I have an aggregate Order which during some operations depends on another aggregate- Company. To perform operation RefreshOrderNumber() I need three properties from the Company entity and totally not interested in other fields from the **Company. So, I got an idea to create a value type for Order – OrderCompanyInfo and incapsulate those fields on it
I am new to asp.net core. So this might not be a good question.
I try to execute the following query:
I apologize in advance for my mistakes, as I am new to the forum and .net
I have tried following examples that look fairly simple for getting the id of a primary key after inserting a new record for use in other tables that need to use it as a foreign key, but despite following these examples to the letter I am still getting a null reference exception for the id.
I’m trying to create a consult using the framework I mencioned before.
I use asp.net core 2.1 and EF Core 2.
I had called FromSql() to use raw query. But there is something strange result occurred.
I am trying to pass a list of strings that contain fields that need to filtered.
Problem: Get users which exists in all entities, like Ali exists in ENT01,ENT02,ENT03