by Yogesh | Jun 28, 2016 | LINQ Tutorial
ThenBy This operator always followed by orderby, means we always use it after using ordeby operator. If we use orderby and ThenBy together then first items will be sorted as per orderby given condition and resultant output sequence will be sorted by ThenBy...
by Yogesh | Jun 28, 2016 | LINQ Tutorial
Ordering Operators in linq C# These operators return same number of output elements as input elements in sorted form. OrderBy This operator sort input elements as per given key. For example we have a employee table which have a salary field now we want to get employee...
by Yogesh | Jun 27, 2016 | LINQ Tutorial
Like TakeWhile, the SkipWhile query operator uses a predicate to evaluate each element in the input sequence. SkipWhile will ignore items in the input sequence until the supplied predicate returns false. using System; using System.Collections.Generic; using...
by Yogesh | Jun 27, 2016 | LINQ Tutorial
The Skip query operator will ignore the specified number of input elements from the start of the input sequence and return the remainder. The following code skips over the first three elements and returns the rest: using System; using System.Collections.Generic;...
by Yogesh | Jun 27, 2016 | SQL Server
create function ganesha(@id int) returns int as begin declare @work int select @work=avg(salary) from emp_info where id=@id; return @work; end; declare @my int select dbo.ganesha(1) b) alter function myfun(@date datetime) returns varchar(50) as begin declare @myoutput...
