RadBlog

ORM 2018-01-16

Dapper – many to many relation in a single request

During my CQRS journey, I implemented many-to-many data querying, in the single database request. I achieved getting all products with associated entities at the same time. To achieve the same, we need to define a temporary table to store all first-level entities:

CREATE TABLE #Products

(

Id int,

Name NVarchar(128),

Price decimal

)

Then insert first-level entities into this table:

INSERT INTO #Products

SELECT P.Id, P.Name, P.Price

FROM dbo.Products AS P

ORDER BY P.CreateDate

OFFSET @Take * (@Page - 1) ROWS

FETCH NEXT @Take ROWS ONLY;

With such…

Design patterns 2018-01-08

CQRS – Third step – Simple read model

This post series is driven by my lightning talk about how to introduce CQRS to your project. I thought that would be good to explain this topic further for people who won’t be…

Keep Reading

ORM 2018-01-04

Autofac + MediatR – Shared transaction between ORMs on a command level

This post describes how to achieve database transaction, on a command level, with Autofac DI and MediatR. Sometimes there is a need to share transaction between two different…

Keep Reading

ASP.NET 2018-01-04

Autofac + ASP.NET – Shared transaction between ORMs on a request level

This post describes how to achieve database transaction, on a request level, with Autofac DI and ASP.NET WebApi. Sometimes there is a need to share transaction between two…

Keep Reading

Angular 2017-12-13

Angular – resolving route data

In angular 1 resolving data into a route and using them in controllers was really straightforward. Below injecting orders into ordersController.

$stateProvider

.state('app.orders', {

resolve: {

url: "/orders/{userId}",

orders: ['$stateParams', 'ordersService',

function ($stateParams, ordersService) {

var userId = $stateParams.userId;

return ordersService.getOrders(userId);

}

]

}

});

ordersCtrl.$inject = ['orders'];

function ordersCtrl(orders) { }

In angular 2 / 4 /…

Keep Reading

Other 2017-12-05

Public speaking – 5 reasons why you should try it

More than two years ago I started my journey with public speakings. And it went better than I expected. I want to share my feelings why is worth…

Keep Reading

Data science 2017-11-12

Azure Machine Learning – so god damn easy

This week my godfather asked me for a favor. He works in an agricultural conglomerate and is responsible for soil researchers for their clients. Currently, he found a document which covers analysis the…

Keep Reading

Design patterns 2017-10-31

CQRS – Second step – Different data access

This post series is driven by my lightning talk about how to introduce CQRS to your project. I thought that would be good to explain this topic further for people who won’t…

Keep Reading

Angular 2017-10-14

Kendo + slider + custom labels

In my project, I wanted to change labels from slider to different one. By default, labels are defined as a range of values – for example, from 0 to…

Keep Reading

Review 2017-09-19

DevConf 2017

DevConf (former DevDay) has ended. It was a great event with interesting presentations and inspiring people who were always willing to argue on some important topics like “Why…

Keep Reading