Embedding SQL Scripts in our project

In the last subsection, we told DbUp to look for SQL Scripts that have been embedded in our project. So, we are now going to embed SQL Scripts for the tables and stored procedures in our project so that DbUp will execute them if they haven't already been executed when our app loads:

  1. In Solution Explorer, right-click on the project, and choose Add | New Folder. Enter SQLScripts as the folder name.
  2. Right-click on the SQLScripts folder and choose Add | New Item....
  3. In the dialog box that appears, select the General tab and then Text File and enter 01-Tables.sql as the filename:
  1. Copy the contents of the ...

Get ASP.NET Core 3 and React now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.