Category Archives: Uncategorized

Hello world!

Welcome to my blog. Moving my blog from Windows live spaces and this is my first post here. It will take some time to get accustomed to. I hope this would be a new and motivating experience. Advertisements

Posted in Uncategorized | Leave a comment

>LINQ Operators – Part X

> I have been busy with a series of tasks and couldn’t find time to complete operators section. Although I had a safari account via university subscription and could read it online, I ordered a great book "C# 3.0 in … Continue reading

Posted in Uncategorized | Leave a comment

>LINQ Operators – Part IX

> Element operators: First, FirstOrDefault: Used to return the first element from a sequence. T-SQL counterpart is "top 1". Last, LastOrDefault: Used to return the last element from a sequence. T-SQL counterpart is "top 1 … order by desc" Single, … Continue reading

Posted in Uncategorized | Leave a comment

>LINQ Operators – Part VIII

> Aggregation operators Aggregation operators are Average, Count, LongCount, Sum, Max, Min and Aggregate. Aggregation operators are available only as methods in C# (VB also have a comprehension syntax for aggregation operators). Average: Gets the average of a numeric collection. … Continue reading

Posted in Uncategorized | Leave a comment

>LINQ Operators – Part VII

> Generation operators: Range: Given a start and count generates a list of integers. Enumerable.Range( 3, 10) Generates integers 3,4 … 12. Repeat: Is similar to replicate() –but not limited to strings- and generates a list of a given element … Continue reading

Posted in Uncategorized | Leave a comment

>LINQ Query Operators – Part VI

> Set operators In set operators we will discuss Distinct(), Union(), Intersect(), Except() and Concat(). Distinct: Removes the duplications and selects unique items. T-SQL counterpart is "Distinct". Union: Returns the union of items from multiple sets. In other words adds … Continue reading

Posted in Uncategorized | Leave a comment

>LINQ Operators – Part V

> Joining operators: Join: If you remember from query methods join is not needed in the case of direct relations in the model (however local queries are faster with join). You can create inner and left joins using Join operator. … Continue reading

Posted in Uncategorized | Leave a comment