Skip to main content

C# and LINQ : What is LINQ ?



LINQ (Language Integrated Query) was officially introduced in .NET 3.5. Here is a simple example

string[] currentVideoGames = {"Morrowind", "BioShock"};

// Build a query expression to represent the items in the array
            // that have more than 6 letters.
IEnumerable<string> subset =           from g in currentVideoGames
                                                            where g.Length > 6
                                                            orderby g
                                                            select g;


Some Internals:
            Linq internally converts Linq Queries to some pre-build generics.

IEnumerable<int> subset = from i in numbers where i < 10 select i;
            Is Converted to:
IEnumerable<int> subset = Enumerable.Where<int>(numbers, (i => (i<10)) );

Capturing and saving results of LINQ:

            int[] subsetAsIntArray =
                        (from i in numbers where i < 10 select i).ToArray<int>();
            //It's Enumerable's extension method.



Filtering collection based on type:

            ArrayList myStuff = new ArrayList();
            myStuff.AddRange(new object[] { 10, 400, false, new Car(), "string data" });
            IEnumerable<int> myInts = myStuff.OfType<int>();
 

Popular posts from this blog

Culture Information and Localization in .NET

Namespace: System.Globalization CultureInfo Class:                 It provides information like the Format of numbers and dates, Culture’s Calendar, Culture’s language and sublanguage (if applicable), Country and region of the culture. The Basic use of CultureInfo class is shown here: • How string Comparisons are performed • How Number Comparison & Formats are performed • Date Comparison and Formats. • How resources are retrieved and used. Cultures are grouped into three categories: Invariant Culture : It’s Culture Insensitive. It can be used to build some trial application. It can be also used to build an application with hard-coded expiry date that ignores cultures. But using it for every comparison will be incorrect and inappropriate. Neutral Culture : English(en), Frensh(fr), and Spanish(sp). A neutral culture is related to language but it’s not related to specific regi...

Using ADO.NET Transaction Object, Saving CLR Objects and SqlNotificationRequest

Serializable allows one transaction to complete before the other start. SqlConnectoin support named savpoint to roll back to; that’s an equaliant to save transaction command in MS SQL Server. Using TransactionScope Object : A transaction can’t span multiple connections.   Local and distributed transaction ares supported in 1.x you have to Enterpeise seveices library to regiser multiple connections and then call EnlistDistributedTransaction. Distributed Transaction Coordinator is required for Distributed transaction that’s available on windows 2000 & +. In 2.X and later use TransactionScope object. Serializable allows one transaction to complete before the other start. SqlConnectoin support named savpoint to roll back to; that’s an equaliant to save transaction command in MS SQL Server. Using TransactionScope Object : Dispoase of the transaction must be called to complete the transaction. Distributed Transaction : ...

Text Encoding and Decoding using .Net

Namespace: System.Text To read a file, an application must write information about the encoding in which the file was written. So, the application that creates a file must write encoding information, otherwise viewer will see block and question marks in file. Unicode UTF-32 encoding : Represents a character as sequence of four bytes (32 bits). UTF32Encoding class can be used in that perspective. Unicode UTF-16 encoding : Represents a character in 16 bits. UnicodeEncoding class can be used to convert to and from UTF-16 encoding. Unicode UTF-8 encoding : Unicode UTF-8 uses 8-bit, 16-bit, 24-bit, and up to 48-bit encoding. Values 0 through 127 use 8-bit encoding and exactly match ASCII values, 128 through 2047 use 16-bit encoding, and values from 2048 and 65535 uses 24-bit encoding. UTF8Encoding class can be used to convert to and from UTF-8 encoding. ASCII encoding : ASCII encoding encodes Latin alphabets as single 7-Bit ASCII character. It is not well su...