Some useful sqls I am sharing here. Description Sql Get Row Number of any table SELECT ROW_NUMBER() OVER (ORDER BY Name ASC) AS ROWID, * FROM TableX Delete Duplicate Records WITH CTE (Col1,Col2, DuplicateCount) AS ( SELECT Col1,Col2, ROW_NUMBER() OVER(PARTITION BY Col1,Col2 ORDER BY Col1,Col2) AS DuplicateCount FROM Table1 ) DELETE FROM CTE WHERE DuplicateCount […]
In this part I would like to demonstrate the power and advantage of [ServiceDependecy] attribute in WCSF framework. Advantage We can restrict the instance creation of classes and make reuse a single instance across page requests. This would drastically decreases memory utilization and simultaneously reduces the instance management code and makes the easier. You can […]
Hello All. In this example I am trying to show how to format currency based on user’s browser setting. Our aim is to show them the formatted currency like: Format Language $1,000.00 United States 1,000.00د.إ. Arabic R$ 1.000,00 Portugese 1.000,00 TL Turkish Step 1: Create the ASP.NET Application Create a new web application and on […]
We can download “Web Client Software Factory – February 2008” from the following link and install it. http://www.microsoft.com/downloads/en/details.aspx?FamilyId=47755838-049B-4291-AFEA-A379AE28D7B3&displaylang=en Additional Requirements WCSF requires following things to be installed. Windows XP/Vista/2003 Visual Studio 2008 .Net 3.5 Verification After installation you will be able to see the following new project type.
Web Client Software Factory (WCSF) is a framework for Web Client creation with proven practices and patterns. It is built up on ASP.NET. Advantages of WCSF Model View Presenter (MVP) support Automatic Service Instance Creation resulting in reduced coding and memory overheads Hides Complexity in traditional ASP.NET application More support for Unit Tests Reusability through […]
One of the cool benefits of WCSF is the support of Model View Presenter (MVP). The advantages of MVP are many: Isolation of User Interface management code through Presenter Isolation of Business Logic code through Controller Improved Unit Test support for code Note: The MVP here also contains a Controller class Learn by Example From […]
This article shows how to create a new web project in Web Client Software Factory. Step1: Select “Web Client Solution” Open your Visual Studio and select File>New Project. Select the Web Client Solution from the category shown in image. Click Ok and you will get the following wizard. Click Finish to end the wizard.
Test Driven Development (TDD) TDD confines to be a good agile methodology. It will give the long term advantage of maintainability to the code that will give confidence while refactoring. I believe if properly used there is no much time cost incurred in using TDD, because I a big fan of TDD . Advantages of […]
I have tried many Lambda expression evaluations and enjoyed the reduced coding efforts they provide. But really I would like to evaluate the speed benefits that Lambda provides. In this article I am trying to compare the speed difference of Lambda expressions with traditional programming. The results are mind-blowing. Simple Scenario : Finding Sum We […]