Web
Analytics
Yogesh | Angular | ASP.NET Tutorials

For Consultation : +91 9887575540

Stay Connected :

LINQ TakeWhile with example

LINQ TakeWhile with example

TakeWhile: This operator is useful when we want to iterate a long list of items. During iteration we can get list of items by using predicate function. Let’s take a example where I will generate numbers using IEnumerable range method and get items as per predicate...

sql joins in sql server

–Self Join select *from emp as p where p.salary=p.gsalary –Equi Join select d.*, e.* from dept as d , emp as e where d.id=e.deptids –Inner Join select d.*, e.* from dept as d inner join emp as e on d.id=e.deptids –Outer Join –Left Outer...
LINQ Partitioning Operators with example

LINQ Partitioning Operators with example

The partitioning query operators take an input sequence and partition it, or “return a chunk” in the output sequence. One use of these operators is to break up a larger sequence into “pages,” for example, paging though ten results at a time in a user interface. 1....
SelectMany query operator in linq

SelectMany query operator in linq

SelectMany query operator produces a variable number of output elements for each input element. In simple words if any collection have collection as an its element then using selectmany we can read that child connection item.  Example using System; using...
triggers in sql server

triggers in sql server

create trigger getid on [login] after insert as select @@identity as mynewid insert into [Login](username ,password) values('aabc','bbcc') disable trigger getid on [login] enable trigger getid on [login] create trigger trig_uppercase on [state] after insert ,update as...