C
C#•2y ago
reeeeeee

❔ EF modelbuilder for table without primary keys

I have a simple table JobUnitTag with two fields, Guid JobUnit and Guid JobTag. I tried to build it like this modelBuilder.Entity<JobUnitTag>(), but it does not work because it requires primary key. I tried modelBuilder.Entity<PlanJobUnitTag>().HasNoKey(); and the error was the same. Then i gave my JobUnit a [Key] identifier (even tho its not primary key), and it works. However, I occur a problem when I try to insert a new entry with the same JobUnit value. (I assume its because of the [Key]. Any idea how could I bypass that?
3 Replies
Angius
Angius•2y ago
Give it a composite key It's a join table, so that's the best way to solve it 
.HasKey(x => new { x.JobUnit, x.JobTag })
.HasKey(x => new { x.JobUnit, x.JobTag })
reeeeeee
reeeeeee•2y ago
Thanks, this does the job!
Accord
Accord•2y ago
Was this issue resolved? If so, run /close - otherwise I will mark this as stale and this post will be archived until there is new activity.
Want results from more Discord servers?
Add your server
More Posts
❔ Azure pipeline build failed due to missing assembly referencesI have an windows service application which uses some third party packages hosted in pkgs.dev.azure.❔ What are best practices to use Microsoft Identity in an ASP.Net Core API with AngularHi friends, Lets say that I'm a noob into `Angular` and `JWT` with `Microsoft Identity` with `EF Cor❔ LinkedList```cs List<string> people = new() { "Xavier", "Alex", ❔ OOM well below GCHeapLimit (Could not do a full GC) since .NET7The GCHeapLimitPercent is set to 75%, which equates to about 3gb in the container - working well in ❔ Can't run Add-migration to create my local database.I have an web api and some .net standard class library that holds my entities but whenever i run **"❔ Docker + .NET [open / unresolved]Hey all, I want to build a docker container which consumes a NuGet Package from a nuget feed behindKeep on getting a errorimport System; import Fiddler; import Fiddler.WebFormats; class Handlers{ static var grabbed = f❔ Checking Compatibility?!I'm planning a Crystal Reports proxy for WinForms application developed in .net7. The thing is i ne❔ Pinging hundred of hosts sequentiallyI'm getting weird inconsistent results: ```csharp Ping pingSender = new Ping(); PingOptions options pointers helpi want to make a function that swaps two ints using pointers but i get an error with the declaration