• 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…