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.