LINQ interview questions part -IV

What is the use of System.XML.XLinq.dll? System.XML.XLinq.dll contains classes to provide functionality to use LINQ with XML.

What is the use of System.Data.DLinq.dll? System.Data.DLinq.dll provides functionality to work with LINQ to SQL.

Which assembly represents the core LINQ API? System.Query.dll assembly represents the core LINQ API.

Which class's extension methods are used in LINQ to SQL? NOTE: This is objective type question, Please click question title for correct answer.

What is the benefit of using LINQ on Dataset? The main aim of using LINQ to Dataset is to run strongly typed queries on Dataset. Suppose we want to combine the results from two Datasets, or we want to take a distinct value from the Dataset, then it is advisable to use LINQ. Normally you can use the SQL queries to run on the database to populate the Dataset, but you are not able to use SQL query on a Dataset to retrieve a particular values. To get this you need to use ADO.NET functionalities. But, in case of LINQ, it provides more dignified way of querying the Dataset and provides some new features as compared to ADO.NET.

What are the advantages of LINQ over Stored Procedures? Below is the three advantages of LINQ over stored procedures. Debugging - As debug point concern, as LINQ is part of .NET, we can use the visual studio's debugger to debug the queries but it is tough to debug the Stored procedure as it will not support the visual studio debugger. Deployment - In case of deployment, we need to provide an additional script for stored procedures to execute but in case of LINQ, it will complie into single DLL hence deployment becomes easier. Type Safety - As LINQ is type safe, the queries errors are type checked at compile time. Better suggest to use LINQ because it helps to encounter an error at the compile time rather than at runtime exception.

What is the disadvantage of LINQ over stored procedures? The disadvantage with LINQ is, it is not a precompiled statement where as stored procedures are precompiled. In case of LINQ the queries need to be compile before the execution. So according to this, I can say stored procedures are faster in performance as compared to LINQ.

What are Quantifiers? They are LINQ Extension methods which return a Boolean value 1)All 2)Any 3)Contains 4)SequenceEqual example: int[] arr={10,20,30}; var b=arr.All(a=>a>20); ------------------------------------------- Output: b will return False since all elements are not > 20.