If we have some nested collection (navigation property) in the entity model and this navigation also has a navigation property, what can you load using Entity Framework with minimal performance penalty?
I'm getting the following error: System.NullReferenceException: 'Object reference not set to an instance of an object.' Microsoft.AspNetCore.Mvc.Razor.RazorPage.Model.get returned null. I'm trying to pass an Id from a view to a controller HttpPost action method. Here is my code: Controller: public…
I have two Enumberable lists: list1 & list2 I want to take something from list2 and update it in list1 based on a condition e.g: list1.Id has say for instance 1, 2, 3, 4, 5 etc. list2.Id has 3, 4…
Below is the object namespace TestingForCw2.Shared { public class Dog { [Key] public Int32 Id { get; set; } public string DogName { get; set; } public Int32 DogAge { get; set; } } } This is the code for…
Struggling to properly seed my database when my app starts up. FlightId, DepartureAirportId, ArrivalAirportId, FlightDateTime and FlightDurationHours all get added but how can I ensure the Airport column is added. I have set-up a one to many relationship with Entity…
I want to save data in database using Form with HttpPost but it is not being saved. This is my controller (CustomersController) Route for adding a new customer (basically returns a view with the form): [Route("customers/new")] public ActionResult New() {…
I am getting details in list format using this query, in that I am also getting user id. reportProblemsList = objEntities.ReportProblems.ToList(); Now I want to get user details based on that user id from users table. So I have tried…
I have a simple many-to-one relationship: public class Company { public IEnumerable<User> Users { get; set; } public int Id { get; set; } } public class User { public int CompanyId { get; set; } [Required] public Company Company…
I have a LINQ query like this: var data = from user in _context.Users select new { UserId = user.Id, Username = user.UserName, RoleNames = (from userRole in _context.UserRoles join role in _context.Roles on userRole.RoleId equals role.Id where userRole.UserId ==…
I'm using a project with 1 code-first DbContext and 1 database-first DbContext in an asp.net webapi project. Running the following commands to update the db/context results in the following errors: dotnet ef dbcontext scaffold Name=ConnectionStrings:Cloud Microsoft.EntityFrameworkCore.SqlServer System.InvalidOperationException: A named connection…