How can I optimize and simplify my query logic?
I’m working on a method that retrieves a list of Student entities from a database based on several optional filtering and sorting criteria. The query is quite complex due to the following reasons:
How can I optimize and simplify my query logic?
I’m working on a method that retrieves a list of Student entities from a database based on several optional filtering and sorting criteria. The query is quite complex due to the following reasons:
Entity Framework does not consider applied migrations
I recently started to work on a .NET project using Entity Framework (5.0.11). This project already has 5 registered migrations, and after creating a new model (+ register it to DbContext), I generated a new migration.
How do migrations using VS Code on Ubuntu
By running the following code on VS Code terminal. I had installed all the dependencies, dotnet SDK, dotnet runtime, and EF core. I am not running any DBMS like Sqllite / MSSQL server even on a docker container and get these errors for both sql providors.
No erorrs but Entity Framework not creating database
After running the command add-migration InitialMigration I get the “Build succeeded” message and then after running the update-database I get the “Done.” message. No errors are shown. However, do database is created. How can I find out what is going on? I tried refreshing my database connection but still no database.
How to create 3 tables using EF OData concept, without foThe title key reference constraint in C table
For example A, B, C are 3 tables I want to create in A table 1 column collection of id’s in B table primary key.
EF Core: How to scaffold and work with 2 schemas from Postgres with shared FK between them
I try for the first time to manage two schemas in Postgres where one id from the 1st schema is referenced as FK in the 2nd schema in another table. I tried scaffolding the schemas as separate contexts and separate folders for the entities, however the referenced table is duplicated in both schemas. How do you go about it?
Error creating migration in Entity Framework when a table has 2 foreign keys into another table
I’m trying to create a new table that has 2 foreign keys into another table. I’ve done this before and didn’t have any trouble, but now when I try to create the migration, I’m getting the following error:
System.InvalidOperationException: ‘The current provider doesn’t have a store type mapping for properties of type ‘EmptyPartition’.’
El error solo me ocurre cuando hago consultas asíncronas de SQL ya sea Procedimientos almacenados o codigo SQL como “Select * FROM…” utilizando el patron repositorio sobre un Dbset. cuando son consultas asincronas de tipo Linq funciona correctamente.
FOREIGN KEY constraint on table x may cause cycles or multiple cascade paths
Before you begin, I know that this is a common problem, as it can be seen from this post, but please bear with me.