Linq queries and lambda expressions

Question

Can anyone please provide me with 1. The differences between Linq queries and lambda expressions and the syntaxes for using them.

Ananth G · Answer

LINQ – Lambda Expression vs Query Expression As you’re probably aware of already LINQ comes in two flavours – using Lambda expressions and using SQL-like query expressions: Func int  bool > isEven = i => i % 2 == 0; int [] ints = new int [] { 1 2 3 4 5 6 7 8 9 }; // using Query expression var evensQuery = from i in ints where isEven(i) select i; // using Lambda expression var evensLambda = ints.Where(isEven); Both yields the same result because query expressions are translated into their lambda expressions before they’re compiled. So performance-wise there’s no difference whatsoever between the two. Which one you should use is mostly personal preference many people prefer lambda expressions because they’re shorter and more concise but personally I prefer the query syntax having worked extensively with SQL. With that said it’s important to bear in mind that there are situations where one will be better suited than the other. Joins Here’s an example of how you can join sequence together using Lambda and query expressions: class Person { public string Name { get ; set ; } } class Pet { public string Name { get ; set ; } public Person Owner { get ; set ; } } void Main() { var magnus = new Person { Name = Hedlund Magnus }; var terry = new Person { Name = Adams Terry }; var charlotte = new Person { Name = Weiss Charlotte }; var barley = new Pet { Name = Barley  Owner = terry }; var boots = new Pet { Name = Boots  Owner = terry }; var whiskers = new Pet { Name = Whiskers  Owner = charlotte }; var daisy = new Pet { Name = Daisy  Owner = magnus }; var people = new List { magnus terry charlotte }; var pets = new List { barley boots whiskers daisy }; // using lambda expression var lambda = people.Join(pets // outer sequence person => person // inner sequence key pet => pet.Owner // outer sequence key (person pet) => new { OwnerName = person.Name Pet = pet.Name }); // using query expression var query = from person in people join pet in pets on person equals pet.Owner select new { OwnerName = person.Name Pet = pet.Name }; } Again both yields the same result and there is no performance penalties associated with either but it’s easy to see why query syntax is far more readable and expressive of your intent here than the lambda expression! Lambda-Only Functions There are a number of methods that are only available with the Lambda expression Single() Take() Skip() First() just to name a few. Although you can mix and match the two by calling the Lambda-only methods at the end of the query: // mix and match query and Lambda syntax var query = (from person in people join pet in pets on person equals pet.Owner select new { OwnerName = person.Name Pet = pet.Name }).Skip(1).Take(2); As this reduces the readability of your code it’s generally better to first assign the result of a query expression to a variable and then use Lambda expression using that variable: var query = from person in people join pet in pets on person equals pet.Owner select new { OwnerName = person.Name Pet = pet.Name }; var result = query.Skip(1).Take(2); Both versions returns the same result because of delayed execution (the query is not executed against the underlying list until you try to iterate through the result variable). Also because query expressions are translated to Lambda expressions first before being compiled there will not be performance penalties either. BUT if you don’t want delayed execution or need to use one of the aggregate functions such as Average() or Sum() for example you should be aware of the possibility of the underlying sequence being modified between the assignments to query and result. In this caseI’d argue it’s best to use Lambda expressions to start with or add the Lambda-only methods to the query expression.

Midhun T P · Answer

Hi Please follow below links. The linq queries are converted to lambda expression before compilation - http://stackoverflow.com/questions/3914611/comparision-linq-vs-lambda-expression http://theburningmonk.com/2010/02/linq-lambda-expression-vs-query-expression/ https://blogs.msdn.microsoft.com/wriju/2006/12/06/linq-query-vs-lambda-expression/

Surya Kant · Answer

As per your question what you asking is that difference between LINQ and Lambda expression. R8 ? Their is no such any differnce in between this two they are two different thing. Lambda is Expression where as LINQ is query statement that use lambda expression to create query from programming. Don't be confuse !! Lambda is a expression which is introduced in .net framework 3.0. Note :- Lambda (=>) introduced because to create anonymous method. So if you have any idea about aonymous function then you might get clear picture about this. To know more about anonymous method read from bellow. https://msdn.microsoft.com/en-us/library/bb397687.aspx This lambda expression is used to build Linq statements. So their is no any difference but to build up LINQ we use Lambda expression. For eg:- List lststd=new Lst ; var TotalStudent= lststd.Select(x => x.CurrencyID); To know more about LINQ read from bellow:- https://msdn.microsoft.com/en-us/library/bb397933.aspx Hope this help you. Any doubt ask here. Mark as answer if it helpfull.