Articles by S. M. Ahasan Habib (Articles: 11, Tip/Tricks: 6)

Articles: 11, Tip/Tricks: 6

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.86

Database Development
SQL Server	Database script execution with test 3 Feb 2013 Updated: 3 Feb 2013 Rating: 5.00/5 Votes: 11 Popularity: 5.21 Licence: CPOL Views: 26,272 Bookmarked: 13 Downloaded: 0 Please Sign up or sign in to vote. Database script execution with testing
	Duplicate Rows/XML-Nodes Identification and Clean-up from Database 21 Oct 2013 Updated: 27 Nov 2013 Rating: 4.70/5 Votes: 17 Popularity: 5.66 Licence: CPOL Views: 52,576 Bookmarked: 19 Downloaded: 259 Please Sign up or sign in to vote. In this article I explain how can we identify duplicate rows from database table and clean them up. I also cover duplicate XML nodes inside XML type fields having the same problem and a solution.
Programming Languages
C#	Sexy C# 16 Dec 2013 Updated: 18 Dec 2013 Rating: 4.79/5 Votes: 157 Popularity: 10.47 Licence: CPOL Views: 176,389 Bookmarked: 289 Downloaded: 1,590 Please Sign up or sign in to vote. In this article I will explain one by one of those hot and sexy features with code example. In some section I use question(Q) and answer(A) pattern so that audience can understand better.
	Lazy Object Initialization with System.Lazy of T class 30 Jun 2013 Updated: 1 Jul 2013 Rating: 4.82/5 Votes: 24 Popularity: 6.65 Licence: CPOL Views: 61,529 Bookmarked: 45 Downloaded: 305 Please Sign up or sign in to vote. I explain how to use System.Lazy class with support of lazy initialization of object
	All About TransactionScope 1 Dec 2013 Updated: 6 Jan 2014 Rating: 4.93/5 Votes: 181 Popularity: 11.10 Licence: CPOL Views: 434,587 Bookmarked: 225 Downloaded: 2,834 Please Sign up or sign in to vote. In this article, I explain with transaction related theory and code sample, how in various scenarios we can use TransactionScope with various options for managing real life transactions.
Web Development
ASP.NET	ASP.NET MVC Controller Dependency Injection for Beginners 12 Mar 2013 Updated: 31 Dec 2013 Rating: 4.82/5 Votes: 129 Popularity: 10.16 Licence: CPOL Views: 605,906 Bookmarked: 216 Downloaded: 4,686 Please Sign up or sign in to vote. In this article I demonastrate a very simple and straightforward way to inject controller dependency to ASP.NET MVC framework with constructor.
	Custom JSON Serializer for the Entity Framework 29 Apr 2009 Updated: 29 Apr 2009 Rating: 4.82/5 Votes: 13 Popularity: 5.20 Licence: CPOL Views: 51,803 Bookmarked: 38 Downloaded: 678 Please Sign up or sign in to vote. Custom JSON serializer for the Entity Framework
	NHibernate Second Level Caching Implementation 17 Jan 2013 Updated: 21 Dec 2013 Rating: 4.85/5 Votes: 31 Popularity: 7.16 Licence: CPOL Views: 100,566 Bookmarked: 42 Downloaded: 786 Please Sign up or sign in to vote. In this article, I tried to explain step by step, how Nhibernate second level caching can be implemented
	Production Server Migration Challenges 19 Jun 2013 Updated: 9 Dec 2013 Rating: 4.97/5 Votes: 24 Popularity: 6.86 Licence: CPOL Views: 49,151 Bookmarked: 32 Downloaded: 0 Please Sign up or sign in to vote. I explain in this article what type of challenges may face when any one start migrating their production server.
	Parse CSV file chunk by chunk and save in database 11 Feb 2013 Updated: 25 Nov 2013 Rating: 4.90/5 Votes: 27 Popularity: 6.93 Licence: CPOL Views: 128,237 Bookmarked: 64 Downloaded: 1,968 Please Sign up or sign in to vote. In this article I will demonstrate how to read a large CSV file chunk by chunk (line basis) and populate DataTable object and bulk insert to database.
HTML	Knockout js for Beginners 11 Nov 2013 Updated: 12 Nov 2013 Rating: 4.88/5 Votes: 104 Popularity: 9.74 Licence: CPOL Views: 292,400 Bookmarked: 146 Downloaded: 9,315 Please Sign up or sign in to vote. This article will help beginners to understand how knockout will work with ASP.NET and communicate client-side server side and the usefulness of the responsive UI design.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.87

Database Development
SQL Server	Using Table variable instead of Cursor Variable [Tip/Trick] 21 Oct 2013 Updated: 3 Nov 2013 Rating: 5.00/5 Votes: 9 Popularity: 4.77 Licence: CPOL Views: 37,695 Bookmarked: 8 Downloaded: 108 Please Sign up or sign in to vote. I will explain here how to use table variable and over come cursor limitation
	How to execute multiple database script files from a specific directory [Tip/Trick] 18 Feb 2013 Updated: 18 Feb 2013 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 17,313 Bookmarked: 8 Downloaded: 617 Please Sign up or sign in to vote. I will explain very simple way to execute multiple script files (*.sql) from a directory.
Programming Languages
C#	A Generic Factory Method-Create Object From Interface Parameter using Reflection [Tip/Trick] 14 Oct 2013 Updated: 14 Oct 2013 Rating: 4.38/5 Votes: 6 Popularity: 3.40 Licence: CPOL Views: 16,380 Bookmarked: 3 Downloaded: 92 Please Sign up or sign in to vote. I will demonstrate a generic factory method which will create object from interface type parameter from an assembly (either current or provided) with the help of reflection
SQL	SQL Server 2012 Auto Identity Column Value Jump Issue [Tip/Trick] 13 Oct 2013 Updated: 14 Oct 2013 Rating: 4.85/5 Votes: 56 Popularity: 8.44 Licence: CPOL Views: 329,725 Bookmarked: 34 Downloaded: 0 Please Sign up or sign in to vote. From SQL Server 2012 version, when SQL Server instance is restarted then its auto Identity column value is jumped based on identity column datatype.
Web Development
ASP.NET	Run .exe inside ASP.NET and catch exception using AppDomain [Tip/Trick] 3 Feb 2013 Updated: 18 Feb 2013 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 45,603 Bookmarked: 14 Downloaded: 0 Please Sign up or sign in to vote. .NET exe file run inside asp.net and catch exception from .exe.
	.NET TransactionScope and its default Transaction Isolation level issue [Tip/Trick] 1 Feb 2013 Updated: 1 Feb 2013 Rating: 5.00/5 Votes: 5 Popularity: 3.49 Licence: CPOL Views: 48,825 Bookmarked: 9 Downloaded: 0 Please Sign up or sign in to vote. .NET TransactionScope and its default Transaction Isolation level issue.

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

S. M. Ahasan Habib

Architect

Bangladesh

How do I describe myself to you? How can I explain that this is true?
I am who I am because of you! My work I love you !!