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.