Profile Picture

Sirwan Afifi

Stories from a web developer.

© 2020. Sirwan Afifi All rights reserved.

Importing JSON files into SQL Server

I was assigned to a task to import a GeoJSON file into a SQL Server database. The file was pretty big; I couldn't even open the file in an…

Using IHostingEnvironment in a test project

Assume that you have a service which accepts as its dependency: Now we wan to be able to load that JSON file inside a test project in order…

Migrating To Gatsby

Jekyll got me into blogging mostly because of its markdown support. When I first saw it, it was clear to me I had to have it. I'd say it was…

Morse code

Morse Code is a set of dots and dashes (short mark, dot or 'dit' (·) and longer mark, dash or 'dah' (-)). Basically, it's a character…

Calling Stored Procedures using Dapper

Today I wanted to call a Stored Procedure using Entity Framework Core. It is possible using method, which is one of the powerful features…

Highlighting Current Link in Razor Pages

Let's say you have several pages in your Razor Pages application. Now you want to make the menu items active depending on the page you are…