ichiroku11

using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.CompilerServices;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApp {
	class Sample {
		private static int GetValue([CallerMemberName]string caller = null) {

ichiroku11

select
	te.trace_event_id as te_event_id,
	te.name as te_event_name,
	xe.package_name as xe_package_name,
	xe.xe_event_name as xe_event_name
from sys.trace_events as te
	inner join sys.trace_xe_event_map as xe
		on  te.trace_event_id = xe.trace_event_id
where
	te.name in (N'RPC:Completed', N'SQL:BatchCompleted');

ichiroku11

select
	xe_p.name as package_name,
	xe_o.name as event_name,
	xe_oc.name as column_name,
	xe_oc.column_type as column_type,
	xe_oc.type_name as type_name,
	xe_oc.description as column_description,
	*
from sys.dm_xe_packages as xe_p
	inner join sys.dm_xe_objects as xe_o

ichiroku11

select
	xe_p.name as package_name,
	xe_o.name as target_name,
	xe_oc.name as column_name,
	xe_oc.column_type as column_type,
	xe_oc.type_name as type_name,
	xe_oc.description as column_description,
	*
from sys.dm_xe_packages as xe_p
	inner join sys.dm_xe_objects as xe_o

ichiroku11

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Dapper;

namespace ConsoleApp {
	class Program {

ichiroku11

.container .box {
	background-color: #e4efff;
	width: 100px;
	margin-bottom: 10px;
	padding: 1em 0.1em;
	text-align: center;
}

.container:hover .box {
	background-color: #ffefe4;

ichiroku11

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Text;
using Microsoft.EntityFrameworkCore;

namespace ConsoleApp {
	public class AppDbContext : DbContext {
		public DbSet<Monster> Monsters { get; set; }

ichiroku11

using System;
using System.Data.SqlClient;
using System.Linq;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Logging;
using Microsoft.Extensions.Logging.Abstractions;

namespace ConsoleApp {

ichiroku11

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Logging;
using Microsoft.Extensions.Logging.Abstractions;

ichiroku11

use Test;

begin tran;

-- テーブル作成
drop table if exists dbo.Character;
create table dbo.Character(
	Id int,
	Name nvarchar(4) not null,
	Level int not null,