@if (ShowModal)
{
<div class="modal-backdrop show"></div>
<div class="modal fade show" id="exampleModal" tabindex="-1"
role="dialog" aria-labelledby="exampleModalLabel"
aria-hidden="true" style="display: block;">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title">
@Title
</h5>
<button @onclick="OnCancelClicked" type="button" class="close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
@ChildContent
</div>
<div class="modal-footer">
<button @onclick="OnCancelClicked" type="button" class="btn btn-secondary">@CancelButtonLabel</button>
<button @onclick="OnConfirmClicked" type="button" class="btn btn-primary">@OkButtonLabel</button>
</div>
</div>
</div>
</div>
}
@code {
private bool ShowModal;
[Parameter] public string Title { get; set; } = "Confirm";
[Parameter] public string CancelButtonLabel { get; set; } = "Cancel";
[Parameter] public string OkButtonLabel { get; set; } = "Ok";
[Parameter] public RenderFragment ChildContent { get; set; }
[Parameter] public EventCallback OnConfirm { get; set; }
[Parameter] public EventCallback OnCancel { get; set; }
public void Show() => ShowModal = true;
public void Hide() => ShowModal = false;
private async Task OnConfirmClicked()
{
ShowModal = false;
await OnConfirm.InvokeAsync();
}
private async Task OnCancelClicked()
{
ShowModal = false;
await OnCancel.InvokeAsync();
}
} [Parameter] public RenderFragment ChildContent { get; set; } @if (IsAdmin)
{
<input type="button" class="btn btn-danger" value="Delete" @onclick="OnDelete" />
<input type="button" class="btn btn-success" value="Edit" />
}
@code
{
[Parameter] public bool IsAdmin { get; set; }
[Parameter] public EventCallback OnDelete { get; set; }
} <EditDeleteButton IsAdmin="true" OnDelete="OnDeleteClicked"></EditDeleteButton>
<Confirmation @ref="Confirmation1"
OnCancel="OnCancelClicked"
OnConfirm="@(() => OnDeleteSelectedRoom.InvokeAsync(Room))">
<div>
Do you want to delete `@Room.Name`?
</div>
</Confirmation> @code
{
Confirmation Confirmation1;
[Parameter]
public BlazorRoom Room { get; set; }
[Parameter]
public EventCallback<BlazorRoom> OnDeleteSelectedRoom { get; set; }
void OnDeleteClicked()
{
Confirmation1.Show();
}
void OnCancelClicked()
{
// Confirmation1.Hide();
}
// ...
} @foreach (var room in Rooms)
{
<IndividualRoom
OnRoomCheckBoxSelection="RoomSelectionCounterChanged"
Room="room"
OnDeleteSelectedRoom="@(selectedRoom => Rooms.Remove(selectedRoom))">
</IndividualRoom>
} 
docker pull microsoft/mssql-server-linux:2017-latest
sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<YourStrong!Passw0rd>' \ -p 1433:1433 --name sql1 \ -d mcr.microsoft.com/mssql/server:2017-latest
Server Host: localhost Port: 1433 Authentication: SQL Server Authentication Login: SA Password: <StrongPasswordYouSet>
sudo docker exec -it sql1 "bash"
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P '<YourNewStrong!Passw0rd>'
CREATE DATABASE TestDB
CREATE TABLE Inventory (id INT, name NVARCHAR(50), quantity INT)
INSERT INTO Inventory VALUES (1, 'banana', 150); INSERT INTO Inventory VALUES (2, 'orange', 154);
SELECT Name from sys.Databases
SELECT * FROM Inventory WHERE quantity > 152;
dotnet new webapi -o dockerapi
dotnet add package Microsoft.EntityFrameworkCore.SqlServer dotnet add package Microsoft.EntityFrameworkCore.Design
public class Students
{
public int Id { get; set; }
public string Name { get; set; }
public string Phone { get; set; }
} dotnet ef dbcontext scaffold "Server=localhost,1433\\Catalog=tutorial_database;Database=<YOUR_DATABASE_NAME>;User=SA;Password=<StrongPasswordYouSet>;" Microsoft.EntityFrameworkCore.SqlServer
"ConnectionStrings": {
"TestingDatabase": "Server=localhost:1433\\Database=<YourDatabaseName>;User=SA;Password=<StrongPasswordYouSet>;"
} dotnet ef migrations add <NAME_OF_MIGRATION>
ef database update
SELECT TABLE_NAME FROM dockerdb.INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'