title: How to model a Messaging/Chatting system in C# with Entity Framework
body: <p>I have a simple question</p>
  
  <p>I'm developping a chat system service but I came across something interesting.</p>
  
  <p>I'm currently operating this way :</p>
  
  <p>First table :</p>
  
  <pre><code>[Messages] :
  SenderID(user),
  RecipientID(user),
  Content(string) 
  </code></pre>
  
  <p>Of course, everytime a user sends a message to the other user, I add it to the table. But I thought about the fact that If a table has a million lines, it would become a mess</p>
  
  <p>So I thought about another way being :</p>
  
  <p>First Table :</p>
  
  <pre><code>[Conversation]
  ConversationID,
  USER1(user),
  USER2(user)
  </code></pre>
  
  <p>Second table :</p>
  
  <pre><code>[Messages] in which I have 
  ConversationID,
  Content(string) 
  </code></pre>
  
  <p>So basically, I'm asking, which configuration should I use? </p>