layout: true <div class="my-header"></div> <div class="my-footer">Andrei Ignat , http://msprogrammer.serviciipeweb.ro/</div> --- class: center, middle # Database2Rest => ( press > ) https://ignatandrei.github.io/Presentations/Database2Rest.html Code at https://ignatandrei.github.io/Presentations/Database2Rest.zip --- # Agenda 0. About me 2. Database2Rest - manual 3. Database2Rest - Odata 4. Generator with CodeTemplates 4. Notable mention : https://github.com/Azure/data-api-builder 7. Discussion / Questions ? --- class: center, top # About me  Andrei Ignat http://msprogrammer.serviciipeweb.ro/ www.ASP.NET forum moderator YouTube 5 minutes .NET and tools : http://bit.ly/5MinTools Book Making Open Source Component : http://bit.ly/NetOpenSourceComponent Book Copy Paste from StackOverflow : https://amzn.to/2PQ8EDc Monthly meetings: https://www.meetup.com/Bucharest-A-D-C-E-S-Meetup/ --- class: center, top # Database2Rest - manual 1. Add DbContext : scaffold from database 2. Add controller / minimal API : scaffold from VS 3. Run See API when adding controller / minimal API --- class: center, top # Database2Rest - OData See program.cs and controller in project ManualWithOdata Also see https://localhost:7204/odata/Departments?$select=Name and https://learn.microsoft.com/en-us/odata/webapi-8/fundamentals/query-options?tabs=net60 --- class: center, top # Generator with CodeTemplates DB2Code https://marketplace.visualstudio.com/items?itemName=ignatandrei.databasetocode Code at https://github.com/ignatandrei/queryViewer/ --- class: center, top # Notable mention : https://github.com/Azure/data-api-builder For the moment, CLI , not generating from database https://learn.microsoft.com/en-us/azure/data-api-builder/get-started/get-started-azure-sql --- class: center, top # Questions? Andrei Ignat http://msprogrammer.serviciipeweb.ro/ www.ASP.NET forum moderator YouTube 5 minutes .NET and tools : http://bit.ly/5MinTools Book Making Open Source Component : http://bit.ly/NetOpenSourceComponent Book Copy Paste from StackOverflow : https://amzn.to/2PQ8EDc Monthly meetings: https://www.meetup.com/Bucharest-A-D-C-E-S-Meetup/