Skip to content

Instantly share code, notes, and snippets.

@danielplawgo
danielplawgo / AddOrder.cs
Created March 11, 2019 05:25
Interceptory w Entity Framework
public partial class AddOrder : DbMigration
{
public override void Up()
{
CreateTable(
"dbo.Orders",
c => new
{
Id = c.Int(nullable: false, identity: true),
Number = c.String(),
@danielplawgo
danielplawgo / AddDescriptionToProduct.cs
Last active March 4, 2019 14:38
Temporal Table i Entity Framework
public partial class AddDescriptionToProduct : DbMigration
{
public override void Up()
{
AddColumn("dbo.Products", "Description", c => c.String());
//AddColumn("dbo.ProductsHistory", "Description", c => c.String());
}
public override void Down()
{
@danielplawgo
danielplawgo / query1.sql
Last active February 28, 2019 04:51
Temporal Tables - Historia zmian w SQL Server
CREATE TABLE dbo.Products
(
[Id] int IDENTITY(1,1) PRIMARY KEY,
[Name] nvarchar(250) NOT NULL,
[Description] varchar(max) NULL,
[ValidFrom] datetime2 (2) GENERATED ALWAYS AS ROW START,
[ValidTo] datetime2 (2) GENERATED ALWAYS AS ROW END,
PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo)
)
WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.ProductsHistory));
@danielplawgo
danielplawgo / ConfigureAudit1.cs
Created February 14, 2019 14:32
Konfiguracja Audit z Entity Framework Plus
private Audit ConfigureAudit()
{
var audit = new Audit();
audit.CreatedBy = UserName;
audit.Configuration.Exclude<Product>();
return audit;
}
@danielplawgo
danielplawgo / DataContext1.cs
Created February 11, 2019 13:58
Audit z Entity Framework Plus
public class DataContext : DbContext
{
public DataContext()
: base("Name=DefaultConnection")
{
}
public DbSet<Category> Categories { get; set; }
@danielplawgo
danielplawgo / DownloadViewModel.cs
Created February 3, 2019 09:00
Topshelf - tworzenie usługi systemowej
public class DownloadViewModel
{
[Required]
public string Url { get; set; }
}
@danielplawgo
danielplawgo / HomeController.cs
Created January 25, 2019 11:50
Grupowanie wiadomości w nLogu w ramach żądania HTTP
public class HomeController : Controller
{
private static ILogger _logger = NLog.LogManager.GetCurrentClassLogger();
public ActionResult Index()
{
_logger.Info("Home.Index started.");
Random random = new Random();
var value = random.Next(1, 3);
@danielplawgo
danielplawgo / Product.cs
Created January 18, 2019 14:46
Postman - testowanie API
public class Product
{
public int Id { get; set; }
public string Name { get; set; }
public string Category { get; set; }
public decimal Price { get; set; }
}
@danielplawgo
danielplawgo / Category.cs
Created December 28, 2018 05:57
Entity Framework, Automapper oraz projekcja
public class Category
{
public int Id { get; set; }
public string Name { get; set; }
public string Description { get; set; }
public virtual ICollection<Product> Products { get; set; }
}
@danielplawgo
danielplawgo / Category.cs
Created December 17, 2018 04:24
CsvHelper - praca z plikami csv
public class Category
{
public int Id { get; set; }
public string Name { get; set; }
}