LINQ Vs DLINQ Vs XLINQ

LINQ Vs DLINQ Vs XLINQ

S.No	LINQ	DLINQ	XLINQ
1	programming model that introduces queries as a first-class concept into any Microsoft .NET language.	an extension to Linq that allows querying a database and do object-relational mapping.	an extension to Linq that allows querying XML documents, as well as creating or transforming XML.

WindowsDefaultLocation vs WindowsDefaultBounds

WindowsDefaultLocation vs WindowsDefaultBounds

S.No	Particulars	WindowsDefaultLocation	WindowsDefaultBounds
1	size	tells the form to start up at a location selected by OS, but with internally specified size.	delegates both size and starting position choices to the OS.

Store Procedure Vs Function

Store Procedure Vs Function

S.No	Particulars	Store Procedure	Function
1	Return	No return value.	Must return Value.
2	Parameter	Input/Output.	Input.
3	Call	can't called to Function.	can called to Store Procedure.
4	Mandatory Input Paramenter	not Mandatory.	Mandatory.
5	DML/Select	Allow DML/Select.	Allow Select.
6	Exception	can be handled.	can not be handled .

Primary Key vs Unique Key

Primary Key vs Unique Key

S.No	Particulars	Primary Key	Unique Key
1	null value	can't accept null values.	can accept Only One null value.
2	key	only one Primary key in a table.	more than one Unique key in a table.

Primary Key vs Foreign Key

Primary Key vs Foreign Key

S.No	Particulars	Primary Key	Foreign Key
1	null value	can't accept null values.	can accept Only One null value.
2	key	only one Primary key in a table.	more than one foreign key in a table.

IENUMERABLE vs IQUERYABLE

IENUMERABLE vs IQUERYABLE

S.No	Particulars	IENUMERABLE	IQUERYABLE
1	Namespace	System.Collections	System.Linq
2	Suitable for	LINQ to Object and LINQ to XML.	LINQ to SQL.
3	custom query	doesn’t supports.	supports custom query using CreateQuery and Execute methods.
4	lazy loading	doesn’t supports.	supports.

ILIST vs IENUMERABLE

ILIST vs IENUMERABLE

S.No	Particulars	ILIST	IENUMERABLE
1	Add/Remove Item	Support.	doesn't support.
2	Filtering	doesn't support.	Support.

Store Procedure Vs LINQ

Store Procedure Vs LINQ

S.No	Particulars	Store Procedure	LINQ
1	Faster	Faster than LINQ.	Slower than Store Procedure.
2	Debug	Not Allowed.	Allowed.
3	writing complex queries	Best Way.	Not Possible.
4	Deploy	SQL script for deployment.	easy and simple.