Author Archives: cetinbasoz

About cetinbasoz

A developer working primarily with C#,F#,VFP,SQL server, Silverlight,Linq ...

>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

>LINQ Operators – Part IV

> Grouping operators GroupBy : GroupBy is used to group a sequence into subsets. At first look it feels like it is same as T-SQL "Group By" but it is not. It slices a sequence into multiple "rows" where each … Continue reading

Posted in Uncategorized | Leave a comment

>LINQ Query Operators – Part III

> Ordering Operators: Ordering operators like T-SQL "Order By" is used for ordering sequences in different ways. There are 5 ordering operators: OrderBy OrderByDescending ThenBy ThenByDescending Reverse Except the last operator Reverse() all those are used as: operator( keySelector ) … Continue reading

Posted in Uncategorized | Leave a comment

>LINQ Query Operators – Part II

> Projection Operators: Select: Selects items from a source, projecting the results as necessary. When the input sequence would be selected as is without any projection ( aka * in T-SQL ) using Select() is not necessary and looks a … Continue reading

Posted in Uncategorized | Leave a comment

>LINQ Query Operators – Part I

> Orders.OrderBy(o => o.OrderDate).Skip(5) .csharpcode, .csharpcode pre{ font-size: small; color: black; font-family: consolas, “Courier New”, courier, monospace; background-color: #ffffff; /*white-space: pre;*/}.csharpcode pre { margin: 0em; }.csharpcode .rem { color: #008000; }.csharpcode .kwrd { color: #0000ff; }.csharpcode .str { color: #006080; … Continue reading

Posted in Uncategorized | Leave a comment

>A few Linq resources

> It has been a long time since I posted my last entry. Sorry about that. I still don’t have time for long posts but I thought I could at least provide some pointers to resources, samples, tools and such. … Continue reading

Posted in Uncategorized | Leave a comment

>Query keywords – join, let

> join: Similar to SQL join, the join keyword is used to join sets. One thing you should note that, if there is a direct relationship in the object model a join is not needed. This behavior differs from SQL. … Continue reading

Posted in Uncategorized | Leave a comment