You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

How to create a calculated column with values from related tables So far, everything needed has been in the same table, but you can add a calculated column that depends on values in another table.

Take advantage of Dapper to create one-to-one, one-to-many, and many-to-many entity relationships in your ASP.NET Core applications.