It requires to get group by with sum. var amount = plod.objProduct.Where(i => i.SID == nslres.SID).GroupBy(s => s.SID).Select(x => new { Totamt =…
It is great feature where can when can be used in order by clause in sql server , below is the query where…
Lots of New feature has been introduced with sql server 20012, it is the latest version from Microsoft after sql server 2008 r2.…
Entity frame work has several advantages like below 1)Orm supprt: It is based on object relational mapping support,which maps between object and data…
From Mvc 2.0 there is only aspx view engine which supports only aspx web form syntax . But from MVC 3.0 new view…
Page life cycle of MVC is like below .When Browser request to application it will do first 1)App initialization: It will create initialization…
If anyone wants to output value with param definition , by below it can be done. SET @SQLString = N’SELECT @UserIDOUT = ‘…
For creating audit log this trigger can be used to fire trigger USE [PCCAS] GO /****** Object: Trigger [dbo].[Crime_AuditLog] Script Date: 04/29/2014 18:36:02…