Some Useful features - Microsot Devleoper World!!

 Here are some of the new and exciting features in Microsoft Dev World.

Some of them are available in preview. 

• Dev Tunnels:
• This nice feature will control the way URL will be generated for your ASP.Net Core Web project and useful when you need your URL accessible from outside. eg. web hooks. 
• 
  
• Support for SQL Server triggers by Azure Function
• This will enable you to create Azure Functions which can be triggered as the data in the SQL table change.
• AlgGraph for Cosmos DB 
• Ledger Tables in Azure SQL - Table which only allow insert. No update or delete. 
• Tool:
• Windows Terminal
• Polyglot Notebooks VS Code Extension

EF Core Power Tool - To generate DB Context

 Nice tool with a lots of customization to generate the DB Schema. 

EF Core Power Tools 

There are lot of material available on how to get started and it is very straight forward to start using it. 

Best thing I like about this and why I used it to customize the name of the Class which is being generated. If you have multiple table with the same name but in the different schema, by default the class name are appended with 1,2. 

For example,

If you have two tables, 

Local.Customer
Master.Customer

Then default EF core will generate the class name as Customer & Customer1. Not that intuitive. 

With EF Core Power Tools, You can customize the class name generation. 

Create a new file with the name "efpt.renaming.json" and put it inside the same folder as your "efpt.config.json".

    

You can also customize the columns inside a table. 

* If you are renaming multiple tables from a single schema, add all of them in the same Tables array. 

 I would try to create a small video some time and share the link.

Until next Cheers!