You'll see output like this: RoleId RoleName Powershell "Invoke-SqlCmd -Database NerdDinner -Query 'SELECT * FROM webpages_Roles'" You can insert a row into the Roles table from the client: INSERT INTO dbo.webpages_Roles (RoleName)Īnd you can run an interactive command in the Docker container to check that the row has been inserted: docker container exec ` There are no post-deployment scripts in this SQL project, so the tables are all empty. You can run a simple container without any Docker volumes, and that gives you a disposable database container: docker container run `Ĭonnect to the database container from a SQL client and you'll see the Nerd Dinner schema deployed - the custom tables for dinners and RSVPs, and the ASP.NET membership tables: That lets you run the database in different ways, to support different scenarios.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |