There are following disadvantages of using LINQ: LINQ is not good to write complex queries like SQL. LINQ doesn’t take the full advantage of SQL features like cached execution plan for stored procedure. Performance is degraded if you don’t write the LINQ query correctly. If you have done some changes… Continue reading
There are following three flavors of LINQ: LINQ to Objects : It enables you to query any in-memory object like as array, collection and generics types. It offers a new way to query objects with many powerful features like filtering, ordering and grouping with minimum code. LINQ to ADO.NET : LINQ to… Continue reading
There are following advantages of using LINQ: It provides a uniform programming model (i.e. common query syntax) to query data sources (like SQL databases, XML documents, ADO.NET Datasets, Various Web services and any other objects such as Collections, Generics etc.) It has full type checking at compile-time and IntelliSense support… Continue reading
LINQ stands for “Language Integrated Query” and pronounced as “LINK”. LINQ was introduced with .NET Framework 3.5 including Visual Studio 2008, C# 3.0 and VB.NET 2008 (VB 9.0). It enables you to query the data from the various data sources like SQL databases, XML documents, ADO.NET Datasets, Web services and… Continue reading
Select and SelectMany are projection operators. Select operator is used to select value from a collection and SelectMany operator is used to select values from a collection of collection i.e. nested collection.
Create a view in SQL server for take a random record CREATE VIEW RandomView AS SELECT NEWID() As ID Then create a functin in SQL server CREATE FUNCTION GetNewId ( ) RETURNS uniqueidentifier AS BEGIN RETURN (SELECT ID FROM RandomView) END The view is required because it’s not possible to… Continue reading