Asp.Net Core & EF 7 Inserting on Table has Trigger

ASP.NET Core EF Many to Many referencing table

I'm trying to create a user with contacts table. I'm not sure if I'm doing it the right way as there is a column added which I didn't declare....The entities:...public class User { public int Id { get; set; } public bool IsAvailable { get; set; } public List<Contact> Contacts { get; set; } } public class Contact { public int UserId...

Error in DbContext after adding a column to table (ASP.NET/EF Core)

All was working fine until I added a new column to my table. I could not find how to update the model class, so I added the column myself in model. But now, when I run my application, I get error: "Object reference not set to an instance of an object."...During debug, I found that it is the problem with creation of instance of my dbcontext:...MyDbC...

EF Core migrations using asp.net core, SQL Server and Docker yields dotnet SDK error

I'm using Docker for Windows Version 1.13.0-rc5-beta35 (9606)...Windows 10 Pro...Visual Studio Code...I've created an ASP.NET Core project with Docker using the yeoman generator:...yo aspnet yo docker ...I ran into issues when I was trying to get the API to connect from a Docker container to a SQL Server instance I had running locally....To solve t...

Inserting into two tables using a view model in asp.net core/ issue with database connection

What is the best way to insert into two tables at once? I am having an issue with the connection string. Below are my data models as well as my view model. I am using the code first approach with asp.net core.... public ActionResult Create(BuildPackagingViewModel viewModel) { var build = new Build() { BuildStep ...

ASP.Net Core 2 - Using a DBContext having defaultConnectionString from appsettings

I want to create a basic CRUD in ASP.Net Core 2 with EntityFrameworkCore....My ...appsettings.json... file is like this-..."DefaultConnection": "server=localhost; port=3306; database=inventory_management; user=root; password=;" ...I want to read connection from this file. What I have done is - In ...Startup.cs... - Startup... //Configuration...

Force inherited classes in ASP.NET Core Entity Framework Core to dedicated MySQL table

Having a model ...Thread... that should countain all attributes of another model called ...Post... I use inheritance:...class Post { public int Id{get;set;} public string Title{get;set;} // ... } class Thread: Post { public int ForumId{get;set;} // ... } ...EF Core put both in a single table and adds the column ...Discriminator....

Controller Action not triggered - Simple Project - ASP.NET MVC CORE 2.0

I have a very simple web application, where I try to let people register a user. Therefore, I try to save user-registration data to Entity Framework, but with no luck....For some reason, IActionResult ...RegisterUser... isn't triggered when submitting a form (I tried setting breakpoints, nothing happened). Can anyone detect why?...Startup.cs...publ...

Can i create multiple tables using same model in EF core asp.net

Can I create multiple tables using the same models with EF Core? My requirement to create multiple tables(with diff names) with the same models and they do not need to share any information. Is that possible with Entity Framework Core in asp.net core?

How to insert data into multiple tables with a foreign key using EF core?

What is the best way to insert data into multiple tables with one or more new rcords containing a foreign key to the first table using Entity Framework Core? ...Given these entities:...public class ParentEntity { public int Id {get; set;} public string Name {get; set;} } public class ChildEntity { public int Id {get; set;} public ...

"Cannot insert explicit value for identity column in table" when inserting object with EF Core

I am trying to insert a new row to my table, using EF Core, SQL Server and C#, but I am having trouble getting EF Core to use the identity column properly....Here's what I am doing:...I am creating a new object using the Entity Framework generated class (I've included the entity class definition at the end of my post)...EmployeePermissions employee...