gavilanch

using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;

namespace ConsoleApp4
{
    class Program
    {

gavilanch

<select class="form-control" @onchange="ChangeMessageFilter">
                                                <option value="---" selected=@(Filter.Message == "---")>---</option>
                                                <option value="Request" selected=@(Filter.Message == "Request")>Request</option>
                                                <option value="Response" selected=@(Filter.Message == "Response")>Response</option>
                                            </select>

gavilanch

"Key": {
  "Type": "Store",
  "StoreName": "My",
  "StoreLocation": "CurrentUser",
  "Name": "CN=SUBJECT_NAME"
}

gavilanch

"IdentityServer": {
 "Key": {
  "Type": "Development"
 }
}

gavilanch

USE [master]
GO
/****** Object:  Database [ValuesDB]    Script Date: 16-Jul-20 10:45:22 PM ******/
CREATE DATABASE [ValuesDB]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'ValuesDB', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\ValuesDB.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'ValuesDB_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\ValuesDB_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
GO

gavilanch

peliculasQueryable = peliculasQueryable.OrderByDescending(x => x.VotosPelicula.Average(y => y.Voto));

gavilanch

services.AddDbContext<ApplicationDbContext>((serviceProvider, dbContextBuilder) =>
{
    var connectionStringPlaceHolder = Configuration.GetConnectionString("PlaceHolderConnection");
    var httpContextAccessor = serviceProvider.GetRequiredService<IHttpContextAccessor>();
    var dbName = httpContextAccessor.HttpContext.Request.Headers["tenantId"].First();
    var connectionString = connectionStringPlaceHolder.Replace("{dbName}", dbName);
    dbContextBuilder.UseSqlServer(connectionString);
});

gavilanch

"ConnectionStrings": {
    "PlaceHolderConnection": "Data Source=.;Initial Catalog={dbName};Integrated Security=True",
  }
...

gavilanch

services.AddDbContext<ApplicationDbContext>(options =>
options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")
));

gavilanch

[HttpGet("{id}")]
public async Task<ActionResult<Person>> Get(int id)
{
    var person = await context.People.Include(x => x.MoviesActors).ThenInclude(x => x.Movie).FirstOrDefaultAsync(x => x.Id == id);
    if (person == null) { return NotFound(); }
    return person;
}