C#•2y ago

Synchronizing 2 tables's ID between eachother using EntityFramework Core

Hello, I don't know if someone here is proficient with EntityFramework Core, but I've got a question about if sharing an id between tables is possible.

Lets say I got a table

EmployeeTickets

EmployeeTickets

and a table

CustomersTickets

CustomersTickets

. Both table have a

Id

Id

field, but that id field is like a primary key for both tables. Eg: If

EmployeeTickets

EmployeeTickets

have a row with Id 1, If I insert something in

CustomersTicket

CustomersTicket

, the Id must be 2, and not 1.

Does EntityFramework provide a way to handle that kind of stuff, or do I need to do it manually

ACiDCA7•3/18/24, 9:06 PM

havent tried it but it should work with sequences

ACiDCA7•3/18/24, 9:09 PM

on second read it i think if you would roll better with another database structure

SamophobiaOP•3/18/24, 9:09 PM

Unfortunately I cannot change the database structure with this project, Its definetly something we would be looking for in the future

ACiDCA7•3/18/24, 9:10 PM

well then, good luck with sequences