-
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 => s.SID).Select(x => new { Totamt = x.Sum(y => y.PrdPrice) }).FirstOrDefault().Totamt;
-
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 server , below is the query where at the time of creation record…
-
New feature in sql server 2012
Lots of New feature has been introduced with sql server 20012, it is the latest version from Microsoft after sql server 2008 r2. Below are some features …. 1)Sequence…
-
Advantages of Entity Framework
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 storage 2)Rapid development: by using entity…
-
Advantages of Razor View Engine
From Mvc 2.0 there is only aspx view engine which supports only aspx web form syntax . But from MVC 3.0 new view engine introduced Razor view engine .Feature…
-
Page life cycle of MVC
Page life cycle of MVC is like below .When Browser request to application it will do first 1)App initialization: It will create initialization of Application of IIS 2)Routing: It…
-
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. SET @SQLString = N’SELECT @UserIDOUT = ‘ + @ModifiedByColumn + ‘ FROM #ins’;…
-
AuditLog Trigger
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 ******/ SET ANSI_NULLS ON GO SET…