rafaelpadovezi’s gists

rafaelpadovezi / starting-savechanges

Created March 16, 2021 23:29

Log - Starting SaveChanges

	dbug: CoreEventId.SaveChangesStarting[10004] (Microsoft.EntityFrameworkCore.Update)
	SaveChanges starting for 'TestContext'.
	dbug: CoreEventId.DetectChangesStarting[10800] (Microsoft.EntityFrameworkCore.ChangeTracking)
	DetectChanges starting for 'TestContext'.
	dbug: CoreEventId.DetectChangesCompleted[10801] (Microsoft.EntityFrameworkCore.ChangeTracking)
	DetectChanges completed for 'TestContext'.
	dbug: RelationalEventId.ConnectionOpening[20000] (Microsoft.EntityFrameworkCore.Database.Connection)
	Opening connection to database 'Timesheet' on server 'localhost,1433'.
	dbug: RelationalEventId.ConnectionOpened[20001] (Microsoft.EntityFrameworkCore.Database.Connection)
	Opened connection to database 'Timesheet' on server 'localhost,1433'.

rafaelpadovezi / medium-savepoint.cs

Created March 12, 2021 20:38

Creating savepoints

	using var transaction = context.Database.BeginTransaction();

	context.Add(new Employee { Name = "John Doe" });
	context.SaveChanges();

	transaction.CreateSavepoint("A");

	context.Add(new Employee { Name = "Jane Doe" });
	context.SaveChanges();

rafaelpadovezi / medium-begin-transaction.cs

Created March 12, 2021 20:37

Add entities - explicity transaction

	var employee = new Employee
	{
	Name = "John Doe",
	Entries = new List<TimeEntry>
	{
	new TimeEntry
	{
	Start = TimeSpan.FromHours(8),
	End = TimeSpan.FromHours(12)
	}

rafaelpadovezi / medium-save-changes.cs

Created March 12, 2021 20:35

Adding entities

	var employee = new Employee
	{
	Name = "John Doe",
	Entries = new List<TimeEntry>
	{
	new TimeEntry
	{
	Start = TimeSpan.FromHours(8),
	End = TimeSpan.FromHours(12)
	}

rafaelpadovezi / medium-configuring-db-context.cs

Created March 12, 2021 20:34

Medium - Configuring db context

 protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
 {
     optionsBuilder
         .UseSqlServer(
             "Data Source=localhost,1433;Initial Catalog=Timesheet;User Id=sa;Password=Password1")
         .LogTo(message => Debug.WriteLine(message));
 }

rafaelpadovezi / db-coalesce-tests.cs

Created May 21, 2020 13:12

	public class Contract
	{
	public int Id { get; set; }
	public string Url { get; set; }
	}

	public class ModelContext : DbContext
	{
	public static readonly ILoggerFactory DebugLoggerFactory
	= LoggerFactory.Create(builder => { builder.AddDebug(); });

rafaelpadovezi / orgaos-20190306.json

Last active March 6, 2019 22:42

This file has been truncated, but you can view the full file.

	[
	{
	"id": 4,
	"uri": "https://dadosabertos.camara.leg.br/api/v2/orgaos/4",
	"sigla": "MESA",
	"nome": "Mesa Diretora da Câmara dos Deputados",
	"apelido": "Mesa Diretora",
	"codTipoOrgao": 1,
	"tipoOrgao": "Comissão Diretora"
	},

rafaelpadovezi / index.html

Last active March 3, 2018 17:07

	<!DOCTYPE html>
	<html lang="en">

	<head>
	<meta charset="utf-8">
	<title>Composição partidária das Comissões da Camara Federal - Junho/2017</title>
	<style>
	body {
	font-family: Cambria, Cochin, Georgia, Times, Times New Roman, serif
	}

rafaelpadovezi / comissions.json

Created June 24, 2017 22:07

[{"name":"Comissão de Agricultura, Pecuária, Abastecimento e Desenvolvimento Rural","children":[{"name":"PDT","children":[{"name":"ASSIS DO COUTO"},{"name":"AFONSO MOTTA"},{"name":"MÁRIO HERINGER"},{"name":"DAGOBERTO NOGUEIRA"}]},{"name":"PSDB","children":[{"name":"IZAQUE SILVA"},{"name":"DOMINGOS SÁVIO"},{"name":"GUILHERME COELHO"},{"name":"NELSON PADOVANI"},{"name":"NILSON LEITÃO"},{"name":"RAIMUNDO GOMES DE MATOS"}]},{"name":"PP","children":[{"name":"AFONSO HAMM"},{"name":"DILCEU SPERAFICO"},{"name":"JERÔNIMO GOERGEN"},{"name":"LÁZARO BOTELHO"},{"name":"LUIS CARLOS HEINZE"},{"name":"NELSON MEURER"},{"name":"ROBERTO BALESTRA"},{"name":"BETO ROSADO"},{"name":"FAUSTO PINATO"},{"name":"LUIZ FERNANDO FARIA"},{"name":"ANDRÉ ABDON"},{"name":"JORGE BOEIRA"},{"name":"BETO SALAME"}]},{"name":"DEM","children":[{"name":"ALBERTO FRAGA"},{"name":"ONYX LORENZONI"},{"name":"CARLOS MELLES"},{"name":"HÉLIO LEITE"}]},{"name":"PMDB","children":[{"name":"ANDRÉ AMARAL"},{"name":"CELSO MALDANER"},{"name":"DULCE MIRANDA"},{"name"

Rafael rafaelpadovezi