C#•2y ago

Simple AP

Hello im trying to connect c# to database and i have a slight problem with foreign keys here is my code the hierarrchy is firma-> division->project->oddelenie plus there are employes here is my code

Dokument.rtf4.93KB

MaruOP•5/22/24, 11:09 AM

also i have this error ntroducing FOREIGN KEY constraint 'FK_DbDiviza_DbZamestnanec_VeduciDivRodneCislo' on table 'DbDiviza' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Could not create constraint or index. See previous errors.

MaruOP•5/22/24, 11:09 AM

its my first time working with this

MaruOP•5/22/24, 11:14 AM

KrosOrg.zip14MB

Pobiega•5/22/24, 11:22 AM

No zips or word documents please, either upload to github or similar or paste the relevant stuff on $paste

PPobiega No zips or word documents please, either upload to github or similar or paste th...

MODiX•5/22/24, 11:22 AM

If your code is too long, you can post to https://paste.mod.gg/ and copy the link into chat for others to see your shared code!

Pobiega•5/22/24, 11:22 AM

however, this is entirely a SQL problem - your database design has errors in it

Pobiega•5/22/24, 11:23 AM

in this case, your foreign keys have some form of ON DELETE/UPDATE action that conflicts with another foreign key

MaruOP•5/22/24, 11:30 AM

yes that is wha the error said but i lack the knowledge on how to fix it

Pobiega•5/22/24, 11:34 AM

check what foreignkeys you have on "DbDiviza"

MaruOP•5/22/24, 11:39 AM

i have 2

MaruOP•5/22/24, 11:39 AM

idfirm and id of employe

Pobiega•5/22/24, 11:47 AM

ok so, if deleting a firm, it makes sense for a division to also be deleted. agreed?

Pobiega•5/22/24, 11:47 AM

but why is there a foreign key for id of employee?

Pobiega•5/22/24, 11:48 AM

or do you mean that you have a employee.DivisionIdemployee.DivisionId field?

MaruOP•5/22/24, 12:06 PM

that makes sens

MaruOP•5/22/24, 12:06 PM

i thought that division would use employe as a division leader but

MaruOP•5/22/24, 12:08 PM

that seems to get rid of the problem when i

MaruOP•5/22/24, 12:09 PM

dleted the leaders of divison, project ect

MaruOP•5/22/24, 12:09 PM

im just gonna add into employe a boolen to set if its a leader of company,div ect

Pobiega•5/22/24, 12:10 PM

you can have a "division leader" just fine, but it needs to have ON DELETE NO ACTIONON DELETE NO ACTION

MaruOP•5/22/24, 12:11 PM

yea but i have no clue how to do that in c# XD

MaruOP•5/22/24, 12:12 PM

is it like a parameter or a method or

Pobiega•5/22/24, 12:14 PM

its not related to C# at all

Pobiega•5/22/24, 12:14 PM

how are you making your database?

MaruOP•5/22/24, 12:16 PM

im using entity frame work and creating it there

MaruOP•5/22/24, 12:16 PM

thru migrating

Pobiega•5/22/24, 12:16 PM

Okay, now we're getting somewhere

Pobiega•5/22/24, 12:16 PM

What version of EF?

MaruOP•5/22/24, 12:16 PM

8.0.5

Pobiega•5/22/24, 12:16 PM

ok good, so modern EF Core

MaruOP•5/22/24, 12:17 PM

well i did Add-Migration InitialCreate

Pobiega•5/22/24, 12:17 PM

you'd do this via the EntityConfiguration api, either via a IEntityTypeConfiguration<T>IEntityTypeConfiguration<T> or via OnModelConfiguringOnModelConfiguring

MaruOP•5/22/24, 12:17 PM

and also update-database

MaruOP•5/22/24, 12:17 PM

lemme check

Pobiega•5/22/24, 12:18 PM

can you show me your database context source?

Pobiega•5/22/24, 12:18 PM

preferably via $code

PPobiega preferably via $code

MODiX•5/22/24, 12:18 PM

To post C# code type the following:
```cs
// code here
```

Get an example by typing

$codegif

$codegif

in chat

For longer snippets, use: https://paste.mod.gg/

MaruOP•5/22/24, 12:19 PM

wrong

MaruOP•5/22/24, 12:19 PM

code

Pobiega•5/22/24, 12:19 PM

copy the URL from the pastebin

MaruOP•5/22/24, 12:19 PM

yea

MaruOP•5/22/24, 12:20 PM

https://paste.mod.gg/iseweprgwemw/0

BlazeBin - iseweprgwemw

A tool for sharing your source code with the world!

Pobiega•5/22/24, 12:20 PM

ok so uhh

Pobiega•5/22/24, 12:20 PM

not the migration

Pobiega•5/22/24, 12:20 PM

I need to see the database context

Pobiega•5/22/24, 12:20 PM

your migration is generated from your context + configurations

Pobiega•5/22/24, 12:21 PM

so you should delete your existing DatabaseSnapshot + migration

Simple AP

Similar Threads

Similar Threads

Similar Threads