Viimased blogi sissekanded

Kanal : DT blogi



Optimize database traffic with future results in NHibernate

One nice feature that NHibernate has is future results. It is technically a capability to put queries on hold until data is actually asked. #06:13 25.03.2020 kanalilt DT blogi


Displaying enum as select list in ASP.NET Core

Some properties of model classes come as enums and we want to show enum values in select list when edit form is opened. Sometimes we want enum element names but sometimes we want to use custom names or even translations. his blog post demonstrates how to get enum element names to select list on ASP. #10:41 24.03.2020 kanalilt DT blogi


EF Core 5. 0: Using ToQueryString() method to translate LINQ query to SQL.

Entity Framework Core 5. 0 comes with SQL-based brother to ToString() method for LINQ-queries. This method is called ToQueryString() and it returns provider-specific SQL without connecting to database server. In some means it’s similar to ToTraceString() method of Entity Framework. #05:15 20.03.2020 kanalilt DT blogi


Using query strings in ASP.NET Core unit tests

Using query string in controller unit tests is actually easy until we don’t need anything more advanced. We can buld up a string with query parameters and go with it. But what if things get more complex and we need encoding or multiple values? Here’s how to build safe query string for ASP. #04:37 18.03.2020 kanalilt 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