Skip to main content

Posts

Showing posts with the label linq tutorial for beginners

LINQ Advantages and Disadvantages in .Net

The LINQ is stands for Language Integrated Query and it is a Microsoft .NET Framework component and use for data querying and it was released in .NET Framework 3.5 on November 19, 2007. The advantages and disadvantages for LINQ (Microsoft .Net) as give below in the details, Advantages 1.       It is quick turnaround for development. 2.       It is helps us to access any type of resource. 3.       It is a cleaner and type-safety. 4.       Lambda expressions are awesome. I am so happy to use it and I always recommended to others developers to use it. 5.       LINQ to SQL allows for RAD with database very nicely. 6.       Queries can be dynamically 7.       Declarative approach makes queries easier to understand and more compact. 8.       Extensibility and expression...
Read more

LINQ Queries Examples Using Query Method and Query Syntax

Basically, the LINQ queries using query syntax and method syntax. The method syntax called Lambda Expressions. The LINQ query syntax is close to native language and it is simple and easy to read. The method syntax is powerful but it is shorter and suitable tool. They compile the same and both are equivalent. Personally, I prefer to lambda extensions for most code writing. I am only using the statements if I am doing LINQ to SQL otherwise I am trying to emulate SQL. I find that the lambda methods flow better with code whereas the statements are visually distracting. You can see the LINQ Query in the below pic, So, here I am trying to explain gather T-SQL queries along with their equivalent LINQ queries in the both method and query syntax. EmpEntites empEnt = new EmpEntites();   //This is entities objects. In these entities objects, we have a table “ tbl_Employee ” and I am trying to explain T-SQL queries along with their equivalent LINQ queri...
Read more

LINQ Tutorial for beginners in ASP.Net C# Examples

What, Why and How LINQ? What is LINQ? Why LINQ? What are LINQ Query and Method Syntax? What is Lambda expression? LINQ Architecture In ASP.Net? LINQ Advantages and Disadvantages? What is LINQ API? Understanding Var and IEnumerablewith LINQ IEnumerable Vs. IList IEnumerable Vs. IQueryable LINQ - Query Operators Where OfType OrderBy and OrderByDescending ThenBy and ThenByDescending Select All and Any Contains Aggregate Average GroupBy ToLookup Join GroupJoin Sum Max ElementAt and ElementAtOrDefault First and FirstOrDefault ...
Read more