Source Control for Stored Procedures/Functions/Views when deploying application #10102

demo.solaru created 3 years ago

Hello,

Because of perfomance issues, we are migrating certain APIs from LINQ to Stored Procedure and Functions. But before we setup all stored procedure wanted to know how we can best achieve Source Control for Database Entities(SP, Functions, Views) along with Entity Framework Code first. And whenever we deploye application it should also consider update stored procedure from source control.

Currently using Aspnetzero 7.0.0, Angular 7, .Net Core 2.2 with MS SQL DB.

Suggestions would be appriciated.

2 Answer(s)

0

ismcagdas created 3 years ago
Support Team

Hi @demo.solaru

I have replied your question on https://github.com/aspnetboilerplate/aspnetboilerplate/issues/6032. You can add an empty migration and modify its code to create/update your stored procedures.
0

demo.solaru created 3 years ago

Thank you!

Have an answer to this question? Log in and write your answer.