Viimased blogi sissekanded

Kanal : DT blogi



Updating SQL Azure database using Visual Studio database project and Azure DevOps

Visual Studio database projects have been one of my important tools since Visual Studio 2010. Database projects were not easy to use with build servers ten years ago. Today things are different. #06:00 10.03.2020 kanalilt DT blogi


Creating storage accounts and blob containers using Azure fluent API-s

Using Azure fluent API-s it is easy to create storage accounts and blob containers. After experimenting with fluent API of Azure storage I found it to be good match for multitenant web applications where tenant files are held on Azure blob storage. #05:28 04.03.2020 kanalilt DT blogi


MSSQL data and log files on Azure blob storage

I discovered lately one killer feature of SQL Server – keeping data and log files on Azure blob storage. There are scenarios where we may want to go with blob storage instead of buying and building up our own stable and reliable storage. #07:52 03.03.2020 kanalilt DT blogi


Using data from MSSQL linked server with EF Core

My previous blog post Querying MySQL from SQL Server using linked server introduced how to link MySQL database to MSSQL and how to write queries that gather data from local and linked server. This blog post demonstrates how to get data mixed from those sources to Entity Framework Core. #22:39 27.02.2020 kanalilt DT blogi


Querying MySQL from SQL Server using linked server

SQL Server has interesting feature calles Linked Servers. It’s about linking other databases to SQL Server and using their data like it’s local. There are many powerful open-source systems written on PHP and they are mostly using MySQL as database. #04:40 06.02.2020 kanalilt DT blogi


Implementing repository querying interface in EF Core DbContext

My last bold statement was that we don’t need custom unit of work and repository classes with Entity Framework Core. One issue remained unsolved and it was querying part of repositories (yeah, those custom querying methods). #05:00 03.02.2020 kanalilt DT blogi


Building experimental hybrid Blazor WebAssembly application

After getting done with Blazor desktop applications I tried to build kind of hybrid Blazor WebAssembly application that can run on desktop and in web equally. Although I failed to make it as one single application, I still got it work with a little different architecture. #06:42 30.01.2020 kanalilt DT blogi


Exploring WebWindow examples for Blazor on desktop

Blazor on desktop is one of latest hot topics and . NET Conf: Focus on Blazor only added more fuel to fire. Blazor seems to come everywhere and it’s unstoppable. One of interesting desktop experiments is WebWindow by Steve Sanderson. #06:16 29.01.2020 kanalilt DT blogi


Start with Surface Duo development on preview emulator and SDK today

Surface Neo and Surface Duo are new devices by Microsoft, planned to launch for holidays season this year. Surface Neo runs Windows and Surface Duo is based on Android. For Surface Duo there’s already preview tooling and SDK available by Microsoft. #05:10 27.01.2020 kanalilt DT blogi


Creating subdomains to Azure DNS from ASP.NET Core

Multitenant wep applications detect current tenant usually by URL checking name of first level folder or subdomain. Usually tenants are defined by subdomain as it is easier to distribute them over data center, cloud services or hosting accounts. #06:01 23.01.2020 kanalilt DT blogi


Inject users and roles dynamically to ASP. NET Core integration tests.

After getting fake authenticated user to ASP. NET Core integration tests I made step further and introduced the way to use different user accounts. Using multiple users and roles instead of one test users is very common scenario in web applications. #05:00 22.01.2020 kanalilt DT blogi


Behind the compiler: 20 examples of C# code before and after compiling

Over years I have written many blog posts about C# and . NET that demonstrate also how things work internally and what C# compiler produces from the code we write. I have called these chapters usually as “Behind the compiler”. #05:00 20.01.2020 kanalilt DT blogi


Announcements from .NET Conf: Focus on Blazor

Microsoft made very interesting announcements at . NET Conf: Focus on Blazor online conference. There are many great things are happening and Blazor is also making a fast progress on finding its way to mobile and desktop. Here’s the short overview of what’s happening and what’s coming next. #03:41 15.01.2020 kanalilt DT blogi


Create fake user for ASP. NET Core integration tests.

After getting done with fake users for ASP. NET Core controller unit tests I wanted to make fake users available also in integration tests. It took some inventing and hacking but I made it work. This blog post shows you how to create fake users for ASP. #04:41 14.01.2020 kanalilt DT blogi


Create fake user for ASP.NET Core controller tests

I think most of ASP. NET Core applications have authentication enabled. When writing unit tests for controllers we have one set of tests that need authenticated user and other set of tests that need anonymous user. Faking User property of controller is a little bit tricky. #12:50 11.01.2020 kanalilt DT blogi


Embedded Power BI reports with ASP.NET Core

Last year I had some projects where I had to embed Power BI reports to ASP. NET Core applications. #05:17 10.01.2020 kanalilt DT blogi


DataSet and DataTable based ad-hoc reporting with ASP.

In one of my projects I have some ASP. NET Core views that display multiple tables with reporting data. Data comes from SQL Server views and stored procedures and these can be modified in database without deploying application to server again. I came out with very common solution in ASP. #04:21 08.01.2020 kanalilt DT blogi


Execute raw SQL commands in Entity Framework Core

I have never seen a real-life project where object-relational mapper generates 100% of needed SQL. There have always been those special cases when raw SQL commands are needed. #08:06 07.01.2020 kanalilt DT blogi


Get notification to e-mail when I post something

First of all – thanks to all my blog readers to be here with me. Last year was the one where the most important metric of blogs – number of page views – made its yearly record and reached a million. #11:08 03.01.2020 kanalilt DT blogi


Using CSOM from Azure Functions

I got back to active SharePoint and CSOM development some months ago and first thing to do was to port bunch of workflows from in-prem SharePoint to cloud. Where I live we don’t usually have any simple workflows. Most of them need some backing code due to custom logic. #08:13 02.01.2020 kanalilt DT blogi