EF Core 7 deadly sin

Load testing tool Bombardier https://github.com/codesenberg/bombardier   EF Core 7 deadly sin Get only the rows that you need Casting IQueryable -> IEnumerable use .Count() from IQueryable rather than IEnumerable, which will query all data and parsing all. Not using AsNoTracking Can be faster 4x times. Explicit joins Select and map to the object directly rather… Continue reading EF Core 7 deadly sin

DateTime – How to properly save and read date time in ASP.Net

There could be many ways of saving DateTime in an App. The simplest way is storing it as it is typed in by users if the website’s users are within a single country. If a website is serviced globally, confusion starts. Normally users might assume the date-time is local time. For example, if a user… Continue reading DateTime – How to properly save and read date time in ASP.Net

Tools and Libraries for an ASP.Net developer in 2018

Tools Resharper One of the most popular productivity tool for Visual Studio users. As Visual Studio keep adding the same functions introduced by Resharper, it’s getting pretty OK just use Visual Studio without Resharper. Still, I love using Resharper as it helps me focus on problem-solving.   In particular, I like its continuous testing feature. Bad… Continue reading Tools and Libraries for an ASP.Net developer in 2018

Use Hangfire with SQLite in ASP.Net 4.5.

I’ll install Hangfire with SQLite, which could be quick and easy solution for small projects, which do not need full blown DB server. Versions of each framework and libraries are as follow. APS.Net MVC 4.5.2 SQLite 1.0.103.0 Hangfire 1.6.7.0 Hangfire SQLite extension 1.1.1.0 Confusion selecting correct SQLite library. When go to http://hangfire.io/extensions.html page, we can see the… Continue reading Use Hangfire with SQLite in ASP.Net 4.5.

How to use bower to manage front-end library in Visual Studio 2015 : for beginners

Background While looking for the JS libary to populate folder as beautiful tree structure and hopefully having modern UI, I found a useful angularjs based open source called, angular file manager(git), which has beautiful and easy-to-use UI, worth to spend some time for my work. The manual of the app said ‘use bower install –save angular-filemanager’ to… Continue reading How to use bower to manage front-end library in Visual Studio 2015 : for beginners