Archived articles - January 2016

Archive for January 2016 (4)

17

Jan

2016

Copy text value to clipboard using jQuery

Simple sample of using jQuery to copy value to clipboard

JavaScript31 titles

0

I recently needed to copy some value from the web UI to clients clipboard. Since this is not something you often need to use, I googled a little bit and found that this is easy to do with document.execCommand...read more

13

Jan

2016

Simplified FileAttributes usage with extension methods

Useful extension methods for common used file and folder attributes

0

In case you are working on a small project where you just store some files and access them, you do not really need a database to achieve accessibility and additional info to files or folders. File-system itself is providing some stuff which can be useful for this...read more

11

Jan

2016

Resize image on the client side with JQuery

Reducing the upload sie by resizing image on the client side

JavaScript31 titles

0

Image resizing is considered as a server side operation as JavaScript and HTML were not so sophisticated and HTML5 support was not widely adopted for quite some time. even now, some features are not equally supported by all major browsers. Anyhow, HTML5 is here to stay and over time we will get more and more features supported by all browsers. ...read more

03

Jan

2016

SqlBulkCopy with model classes in C#

Use SqlBulkCopy with model (POCO) classes in C#

0

So far (based on my experience) the fastest way to insert big number of records from application to database is to use SqlBulkCopy. The downsize of this is that SqlBulkCopy uses DataTable instace as an input parameter which is not so convenient when dealing with models which are strongly typed and a lot more easy to use than iterating through the DataTable...read more

.NET

16

Jun

2021

C# scripting with .NET Core global tool

Using .NET Core global tool to run C# script files

25

May

2021

Using interceptors with dependency injection in Entity Framework Core

EF Core interceptors via dependency injection in ASP.NET 5

8

May

2021

Implementing soft delete in EF Core using triggers

Entity soft delete implementation in EF Core

24

Apr

2021

Handling file upload in ASP.NET Core 5 with Swagger UI

Generating proper file upload in Swagger UI for file upload in ASP.NET Core 5

26

Mar

2021

Generic type controller methods in ASP.NET Core

Using generic type controller methods in ASP.NET Core with Swagger

17

Jan

2021

Mocking view mapped DbSets with XUnit in EF Core

Writing unit tests for view bounded entities in EF Core

JavaScript

28

Oct

2018

HTML5 localStorage with expiry with vanilla JavaScript

Using HTML5 localStorage with expiry

8

May

2018

Monitoring DOM changes with JavaScript

Handling DOM changes with plain JavaScript

9

May

2017

Non blocking CSS load on the page

Load external CSS files in an async manner

16

Mar

2017

Serialize html form to JSON without using JQuery

Transform user input from HTML form fields to JSON

17

Jan

2016

Copy text value to clipboard using jQuery

Simple sample of using jQuery to copy value to clipboard

11

Jan

2016

Resize image on the client side with JQuery

Reducing the upload sie by resizing image on the client side

SQL/T-SQL

23

May

2020

Identifying opened connections for the specific application in SQL Server

Connection listing queries in SQL Server

3

May

2018

Reading JSON data in T-SQL on SQL Server

Extracting values from JSON string on SQL Server using T-SQL

28

Apr

2016

Create XML/HTML with T-SQL

Generating XML/HTML output in SQL Server

24

Nov

2015

IP address to octets split in TSQL

Split IP addresse into octets in SQL Server

20

Jul

2015

Getting first and last second of the current year, month and day

Using minimum and maximum date time in SQL query

13

Apr

2015

Dealing with duplicate rows in SQL Server

Finding and cleaning up duplicate rows in SQL Server tables

Umbraco CMS

2

Mar

2018

Minify HTML output of your pages

Minification of HTML output using ASP.NET IHttpModule

18

Apr

2015

Generate sitemap.xml on the fly in Umbraco CMS

Simple sitemap.xml Umbraco handler

2

Mar

2015

Accessing UmbracoHelper in HttpHandler request

Working with UmbracoHelper and IPublishedContent in HttpHandler

14

Sep

2014

Same page language switching in Umbraco

Land on the same page in different language in Umbraco using Relations

4

Sep

2014

Getting cropped image the smart way

The way to get cropped image URL with option to load original image too

27

Aug

2014

Fastest way to return JSON result from a controller

Resturn JSON in MVC controller action