C
C#•2y ago
bookuha

Many-To-Many with same fields of same type

I have a tables Users and Transactions. I want to make my Transactions store two entities: sender and reciever (Both are users) How do I configure with Entity Framework Fluent API?
10 Replies
Tvde1
Tvde1•2y ago
what have you tried so far? 😁 Any reason you think 
class Transaction
{
    public User Sender { get; set; }
    public User Receiver { get; set; }
}
class Transaction
{
    public User Sender { get; set; }
    public User Receiver { get; set; }
}
wouldn't work?
bookuha
bookuha•2y ago
How do I configure this with FluentAPI? Like, I need to specify that it is a joining table And I can reference a transaction by User object and vise versa Thats the problem 😦 I dont even know how to google it lol
Tvde1
Tvde1•2y ago
have you tried anything yet? Any errors?
bookuha
bookuha•2y ago
Yes, I did. But I found it wrong. But seemingly this actually is a solution:
bookuha
bookuha•2y ago
https://stackoverflow.com/questions/55252077/adding-a-second-one-to-one-relationship-with-the-same-table-in-entity-framework
Stack Overflow
Adding a second one-to-one relationship with the same table in enti...
I am doing code-first entity framework design. I have a table, Account, which has a property, Supervisor: public class Account { public int Id { get; set; } public Account Supervisor { get; s...
bookuha
bookuha•2y ago
Or [InverseProperty] attribute must be used I guess
bookuha
bookuha•2y ago
bookuha
bookuha•2y ago
yeees I feel so happy because finally solution is here @Tvde1 thank you!
Tvde1
Tvde1•2y ago
https://learn.microsoft.com/en-us/ef/core/modeling/relationships This article also contains all you need to know about EF relationships
Relationships - EF Core
How to configure relationships between entity types when using Entity Framework Core
bookuha
bookuha•2y ago
🍎🍐🍋 yes! I was not aware of multiple relationships between two entities
Want results from more Discord servers?
Add your server
More Posts
Observable collectionHello, i'd like to know/understand why the event Collectionchanged isn't triggered when i change a vHow do I split these strings?If I have these inputs, wich could be random numbers. How do I split the string into two parts wher?.Show() Is not working [Closed]I'm creating my "antivirus" but when I put it to display the new form with .Show it doesn't work theHow to stop two right-aligned elements wrapping aroundI have a navbar component with these two elements, the signin/signout links and the search form: ```Does anyone have any thorough resources or documentation on how to implement a custom Identity setupI am trying to implement Identity on a project that does not already include it. I have found some rCompiling and adding DLLs in VS CodeHi. How do I compile my static class into a DLL file and then include that DLL file in my main projeDrop composite PK and add new column PK with identity with EF Code firstHello. I have following table ClaimFeeType(picture below). I want to remove composite PK constraint How can I start the task by string?I need something like this, is this possible to do? void Main() { var input = Console.ReadLine(How do I deal with a browsers own autocomplete suggestions?I have the following input in an Angular component: ```html <input autocomplete="family-name" formCoOnly numbers```Console.WriteLine(" Please enter a Number"); MyNumber1 = Convert.ToInt32(Console.ReadLine());`