I am very very new to entity framework so I might have done terrible mistakes. I have two tables in database and I want to join these tables to show in one view page.My code: CompanyController using CompanyData.DAL; using Microsoft.AspNetCore.Mvc; using CompanyData.Models; namespace CompanyData.Controllers…
I have two entities (Product and Supply) that have a many-to-many relationship. I also have an entity between then that holds the two ID's (SupplyProduct). My entities: public class Product { [Key] public int ProductId { get; set; } [Required]…
Following this tutorial from Microsoft gives me this Model for a TodoItem: namespace TodoApi.Models { public class TodoItem { public long Id { get; set; } public string? Content { get; set; } public bool Completed { get; set; }…
I'm using a MudDialog that takes in an Id and creates an edit form from a component. When I click on any of the white space around the edit form or even between any of the form fields then the…
The following query is not returning the proper results, it will return properly for company, but not the other two parameters. For clarification this is inside a post method of a page taking the user's input for company, name, and/or…
I'm working on a Docker related application, written in C#, based on Entity Framework. One of the Docker containers, is the ms-sql-server, which is used for database access. In order to access the SQL-server, following connectionString is created: Server=ms-sql-server;Initial Catalog=Ownobjects;User…
i was following this tutorial about paginate. it all worked, but if i add some sorting & filtering from my old code, it doesn't work. and the error says NullReferenceException: Object reference not set to an instance of an object.…
So I'm transferring domain classes (a lot) to the postgres with EF6. Classes can have value type properties, like int and float, and are being transferred to postgres as NOT NULL. I can't make my domain classes properties nullable, as…
The API has no issue at the beginning, it was working fine. But when more and more data was accumulated in the database (mariadb), the event participants cannot get their workshop data, such as their attendance records, their history sessions,…
I am new to SQL Server database design let alone C# and the .NET framework. I was wondering if I could get some help regarding the implementation of my SQL Server database with a simple blogging API. Here is the…