Entity Framework – Schema MigrateDatabaseToLatestVersion
I’ve been using EF for quite sometimes and I use Code First to build my schema. The question that I always have in mind is “Once the project is released and we need to add a…
-
-
Run a selective column query in Entity Framework
EF is an ORM tool for Microsoft. It helps developer in interacting with the database (CRUD) and running a custom stored procedure. I’ve been using it and it’s all running perfectly fine. But I have a…
-
Enum in javascript and binding it to Dropdown list
It’s pretty clean to set, bind and use enum in your javascript //Enum declaration var AvailableActions = { “Action”: 1, “Priority”: 2, “Status”: 3 }; //Bind function Load() { for (var action in AvailableActions) { jQuery(“#MandatoryActionList”).append(“<option…
-
SQL Splitting function performance
I was required to create a SQL Splitter function and I tried to browse internet to find an article about it but I never thought there is someone has done wonderful job in comparing the performance…
-
Best practice of creating a custom exception in .NET
This is a great article explaining how to create a custom exception that follows the standard http://dotnetconcepts.wordpress.com/2010/05/28/custom-exceptions-in-c/
-
Degrading performance IIS 7 with Windows Authentication and Kerberos
If you use IIS7 with windows authentication and kerberos, you might want to look into this support article from microsoft. This support article also cover IIS6 http://support.microsoft.com/kb/954873
-
IIF in SQL Server 2012
Now you can use IIF in SQL Server 2012 instead of CASE (again this only if you have 2 possible values that you want to evaluate) –This will return Apple SELECT IIF(‘APPLE’ = ‘APPLE’, ‘Apple’, ‘Banana’)…
-
OFFSET FETCH in SQL Server 2012 – Paging
In SQL Server 2005, normally when we do paging we need to use CTE or nested SELECT Statement, but in SQL Server 2012 we can use OFFSET and FETCH to do the paging Let’s start of…