title: C# ASP.NET Core building dynamic forms
body: <p>I want to implement something similar like SharePoint online does and that is the list functionality. I want to create dynamic lists add new columns, etc. The user can fill in the form and save the data.</p>
  
  <p>The bottle neck is the database, I have some hard time understand how this should be built. </p>
  
  <p>I was thinking to create dynamic SQL Server tables, columns, etc, but maybe this is not the good approach. Can somebody advise on how the database should look like?</p>
  
  <p>I was thinking about creating one table called <code>Lists</code> and there store List properties. Then a many to many relation to another table called <code>Fields</code> where I can store all fields related to a specific form. Many to many relation because some fields are common for all forms like: Id, CreatedBy, Created, Modified, ModifiedBy, etc. Now comes the difficult part. Where should I store the actual data? Should I create another table called <code>FormData</code> and store in there the data? And what relation should it have with <code>Lists</code> and <code>Fields</code> tables?</p>