Recommendations

  • Username/password used in AspCoreGen must have admin or enough priviledges in the database that you're going to work on.
  • Use a local MS SQL Server if possible.
  • Microsoft may charge you when developing while using a Microsoft Azure SQL based on the data you use. AspCoreGen will query and may generate multiple stored procedures while generating code. Use a local MS SQL Server instead while developing. When done, copy your local database to your Microsoft Azure SQL.
  • Use No spaces when creating Table names or Field names in your database.
  • Use Alphanumeric characters only when creating Table names or Field names in your database.
  • Use upper case letters for Table names and Field names if you have any plans of using Oracle in the future.
  • Create explicit relationships for your tables using Diagrams.
* Please see notes.