Group By and Sum using Linq On Entity
It requires to get group by with sum. var amount = plod.objProduct.Where(i => i.SID == nslres.SID).GroupBy(s […]
case when statement for order by clause in sql server
It is great feature where can when can be used in order by clause in sql […]
New feature in sql server 2012
Lots of New feature has been introduced with sql server 20012, it is the latest version […]
Advantages of Entity Framework
Entity frame work has several advantages like below 1)Orm supprt: It is based on object relational […]
Advantages of Razor View Engine
From Mvc 2.0 there is only aspx view engine which supports only aspx web form syntax […]
Page life cycle of MVC
Page life cycle of MVC is like below .When Browser request to application it will do […]
For Using sp_executesql with param definition and output parameter
If anyone wants to output value with param definition , by below it can be done. […]
AuditLog Trigger
For creating audit log this trigger can be used to fire trigger USE [PCCAS] GO /****** […]