cetinbasoz.wordpress.com
cetinbasoz | Cetin Basoz's Blog
https://cetinbasoz.wordpress.com/author/cetinbasoz
Cetin Basoz's Blog. Just another WordPress.com site. A developer working primarily with C#,F#,VFP,SQL server, Silverlight,Linq . April 16, 2011. 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. LINQ Operators Part X. July 31, 2009. LINQ Operators Part IX. July 2, 2009. LINQ Operators Part VIII. July 2, 2009. Aggregation operators Aggregation operators are Average, ...
cetinbasoz.wordpress.com
Hello world! | Cetin Basoz's Blog
https://cetinbasoz.wordpress.com/2011/04/16/hello-world
Cetin Basoz's Blog. Just another WordPress.com site. LINQ Operators Part X. April 16, 2011. 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. A developer working primarily with C#,F#,VFP,SQL server, Silverlight,Linq . View all posts by cetinbasoz →. This entry was posted in Uncategorized. LINQ Operators Part X. Leave a Reply Cancel reply. Enter your comment here.
cetinbasoz.wordpress.com
>What if the backend wasn’t VFP | Cetin Basoz's Blog
https://cetinbasoz.wordpress.com/2009/02/20/what-if-the-backend-wasn’t-vfp
Cetin Basoz's Blog. Just another WordPress.com site. Linq is fun continued, part 2. Simplest table and query →. What if the backend wasn’t VFP. February 20, 2009. As a data backend my preference is SQL server and what I write are almost always based on SQL server. To keep long story short, instead of a DataSet we would create an ADO.Net entity model:. Using System.Collections.Generic;. Using System.Linq;. Using System.Text;. 160; class Program. 160; {. 160; {. 160; ...160; ...160; &#...
cetinbasoz.wordpress.com
>LINQ Operators – Part VII | Cetin Basoz's Blog
https://cetinbasoz.wordpress.com/2009/06/24/linq-operators-–-part-vii
Cetin Basoz's Blog. Just another WordPress.com site. LINQ Query Operators Part VI. LINQ Operators Part VIII →. LINQ Operators Part VII. June 24, 2009. Given a start and count generates a list of integers. Enumerable.Range( 3, 10). Generates integers 3,4 12. Is similar to replicate() but not limited to strings- and generates a list of a given element (either a single element or not) repeating it N times. Enumerable( ‘A’, 5).Dump(); / Char A 5 times. Enumrable.Repeat(1, 3).Dump(); / int. Customers.Wher...
cetinbasoz.wordpress.com
>LINQ Operators – Part VIII | Cetin Basoz's Blog
https://cetinbasoz.wordpress.com/2009/07/02/linq-operators-–-part-viii
Cetin Basoz's Blog. Just another WordPress.com site. LINQ Operators Part VII. LINQ Operators Part IX →. LINQ Operators Part VIII. July 2, 2009. 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). Gets the average of a numeric collection. T-SQL counterpart is Avg(). Sums the values in a numeric collection. T-SQL counterpart is Sum(). Scores = {60,75,89};.
cetinbasoz.wordpress.com
March | 2009 | Cetin Basoz's Blog
https://cetinbasoz.wordpress.com/2009/03
Cetin Basoz's Blog. Just another WordPress.com site. Monthly Archives: March 2009. March 22, 2009. Orderby: Is used for sorting the records. In comprehension syntax it is just like we use it in SQL. i.e: from c in Customers orderby c.Country, c.CompanyName descending select c Here we are ordering by Country (default ascending) and … Continue reading →. Query keywords group and into. March 16, 2009. Query keywords – select. March 11, 2009. Query keywords – where. March 8, 2009. Query keywords – from.
cetinbasoz.wordpress.com
Cetin Basoz's Blog | Just another WordPress.com site | Page 2
https://cetinbasoz.wordpress.com/page/2
Cetin Basoz's Blog. Just another WordPress.com site. Newer posts →. LINQ Operators Part IV. May 31, 2009. 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 row have a key and subset of sequence matching to those key. Here is a screen shot how it looks with this simple query:. Customers.GroupBy( c = c.Country ). Here is a sample with an element selector:. 160; .GroupBy (. In all thes...
cetinbasoz.wordpress.com
>LINQ Operators – Part V | Cetin Basoz's Blog
https://cetinbasoz.wordpress.com/2009/06/05/linq-operators-–-part-v
Cetin Basoz's Blog. Just another WordPress.com site. LINQ Operators Part IV. LINQ Query Operators Part VI →. LINQ Operators Part V. June 5, 2009. 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. Syntax is simple:. Customers.Join( / Customers. 160; c = c.CustomerID, / (Customers as c) on c.CustomerID. 160; (c, o) = new. 160; Orders,.
cetinbasoz.wordpress.com
June | 2009 | Cetin Basoz's Blog
https://cetinbasoz.wordpress.com/2009/06
Cetin Basoz's Blog. Just another WordPress.com site. Monthly Archives: June 2009. LINQ Operators Part VII. June 24, 2009. 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 →. LINQ Query Operators Part VI. June 21, 2009. LINQ Operators Part V. June 5, 2009. LINQ Operators Part X. LINQ Operators Part IX.
cetinbasoz.wordpress.com
>New Horizons | Cetin Basoz's Blog
https://cetinbasoz.wordpress.com/2009/02/03/new-horizons
Cetin Basoz's Blog. Just another WordPress.com site. Welcome back. →. February 3, 2009. VFP has always been good to me and it is what I use to earn my life. However it is time to move on to more promising languages. I, like many other VFP developers, started my move little by little to .Net (and chose C#/F# as my .Net language(s) . Why would I move? Want to create richer UI? Want to create web applications besides desktop applications or a hybrid of them? Want to create distributed applications? Want to ...