Click here to Skip to main content
15,031,937 members

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

Articles: 11, Tip/Tricks: 6

RSS Feed

Average article rating: 4.86

Database Development
SQL Server
Posted: 3 Feb 2013   Updated: 3 Feb 2013   Views: 22,092   Rating: 5.00/5    Votes: 11   Popularity: 5.21
Licence: The Code Project Open License (CPOL)      Bookmarked: 12   Downloaded: 0
Please Sign up or sign in to vote.
Database script execution with testing
Posted: 21 Oct 2013   Updated: 27 Nov 2013   Views: 46,625   Rating: 4.70/5    Votes: 17   Popularity: 5.66
Licence: The Code Project Open License (CPOL)      Bookmarked: 19   Downloaded: 253
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#
Posted: 16 Dec 2013   Updated: 18 Dec 2013   Views: 158,947   Rating: 4.79/5    Votes: 157   Popularity: 10.47
Licence: The Code Project Open License (CPOL)      Bookmarked: 288   Downloaded: 1,553
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.
Posted: 30 Jun 2013   Updated: 1 Jul 2013   Views: 57,476   Rating: 4.82/5    Votes: 24   Popularity: 6.65
Licence: The Code Project Open License (CPOL)      Bookmarked: 45   Downloaded: 303
Please Sign up or sign in to vote.
I explain how to use System.Lazy class with support of lazy initialization of object
Posted: 1 Dec 2013   Updated: 6 Jan 2014   Views: 400,966   Rating: 4.93/5    Votes: 180   Popularity: 11.09
Licence: The Code Project Open License (CPOL)      Bookmarked: 221   Downloaded: 2,791
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
Posted: 12 Mar 2013   Updated: 31 Dec 2013   Views: 571,809   Rating: 4.82/5    Votes: 129   Popularity: 10.16
Licence: The Code Project Open License (CPOL)      Bookmarked: 215   Downloaded: 4,663
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.
Posted: 29 Apr 2009   Updated: 29 Apr 2009   Views: 48,611   Rating: 4.82/5    Votes: 13   Popularity: 5.20
Licence: The Code Project Open License (CPOL)      Bookmarked: 37   Downloaded: 675
Please Sign up or sign in to vote.
Custom JSON serializer for the Entity Framework
Posted: 17 Jan 2013   Updated: 21 Dec 2013   Views: 91,766   Rating: 4.85/5    Votes: 31   Popularity: 7.16
Licence: The Code Project Open License (CPOL)      Bookmarked: 42   Downloaded: 779
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
Posted: 19 Jun 2013   Updated: 9 Dec 2013   Views: 43,591   Rating: 4.97/5    Votes: 24   Popularity: 6.86
Licence: The Code Project Open License (CPOL)      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.
Posted: 11 Feb 2013   Updated: 25 Nov 2013   Views: 113,505   Rating: 4.90/5    Votes: 27   Popularity: 6.93
Licence: The Code Project Open License (CPOL)      Bookmarked: 63   Downloaded: 1,911
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
Posted: 11 Nov 2013   Updated: 12 Nov 2013   Views: 275,367   Rating: 4.88/5    Votes: 104   Popularity: 9.74
Licence: The Code Project Open License (CPOL)      Bookmarked: 146   Downloaded: 9,267
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
Posted: 21 Oct 2013   Updated: 3 Nov 2013   Views: 34,283   Rating: 5.00/5    Votes: 9   Popularity: 4.77
Licence: The Code Project Open License (CPOL)      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
Posted: 18 Feb 2013   Updated: 18 Feb 2013   Views: 15,833   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 585
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#
Posted: 14 Oct 2013   Updated: 14 Oct 2013   Views: 14,670   Rating: 4.38/5    Votes: 6   Popularity: 3.40
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 91
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
Posted: 13 Oct 2013   Updated: 14 Oct 2013   Views: 296,040   Rating: 4.85/5    Votes: 56   Popularity: 8.44
Licence: The Code Project Open License (CPOL)      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
Posted: 3 Feb 2013   Updated: 18 Feb 2013   Views: 41,562   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 14   Downloaded: 0
Please Sign up or sign in to vote.
.NET exe file run inside asp.net and catch exception from .exe.
Posted: 1 Feb 2013   Updated: 1 Feb 2013   Views: 42,574   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      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 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 !!