Base solution for your next web application
Open Closed

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


User avatar
0
demo.solaru created

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.

Markdown is supported
Copy & paste or drag & drop images (max 30 MB per image)

2 Answer(s)
  • User Avatar
    0
    ismcagdas created
    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.

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    demo.solaru created

    Thank you!

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)